Course Outline

Microsoft Excel 2004 Level 3
Become a powerful Excel user by learning to customize it to your needs. Discover how to use conditional formatting so your spreadsheets can have the “Wow” factor. Want to increase your speed and accuracy? Data Validation is the answer. Learn techniques to quickly manage and manipulate large volumes of data with Pivot Tables and how to automate your work with simple Macro commands. In the end, be taught how to Safeguard your work. 6 hours
Conditional Formatting

Data Validation

Custom Date and Number Formatting

Worksheet Protection

Workbook Protection

Moving and Copying Sheets

Exporting Data from Excel

Creating Pivot Table Reports

Consolidating Data

Getting Started with Excel Macros

  • Recording a Command Macro
  • Using the Visual Basic Editor
  • Running a Command Macro
  • Creating macros for Printing
  • Adding Macros to Buttons and Menus
  • Using the Personal Macro Workbook
Prerequisites:  Excel Levels 1 and 2 or equivalent experience.

Revised 4/13/2011
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600