Loading Course Schedule...
PT4640
Training Summary
Using Advanced Functions- Part 1This module introduces the skills necessary for using advanced functions. It includes tasks such as working with data series; using advanced functions, scenarios, goal seeking, data tables, and auditing tools; and consolidatingworksheets. Students will also learn how to solve problems, and work with views.Macros, Toolbars, and PivotTables- Part 2This module introduces the skills necessary to utilize macros, customize toolbars, and work with PivotTables. It includes tasks to use, record, and edit macros; use custom toolbars and menus; and create a macro button. Students will also learn how to create and revise PivotTables
Prerequisites
Students should successfully complete Excel 2003, Level 3
Duration
1 Day/Lecture & Lab
Audience
This course is designed for those with Excel experience seeking introduction to advanced functions.
Course Topics
- Working with Data Series
- Using Advanced Functions
- Using Scenarios and Goal Seeking
- Using Data Tables
- Using Auditing Tools
- Consolidating Worksheets
- Solving Problems
- Working with Views
- Using Macros
- Recording Macros
- Editing Macros
- Using Custom Toolbars and Menus
- Creating Macro Buttons
- Creating/Revising PivotTables