Excel 2003, Level 4

PT4640
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.
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

Related Scheduled Courses