Course Outline

Microsoft Excel Level 3

Apply conditional formatting to highlight data based on specified criteria. Create and apply data validation rules to help ensure accurate data entry. Create and apply custom date and number formatting. Move and copy worksheets and export data from Excel for use in Word. Create pivot table reports. Password protect at the worksheet and workbook level. Record and run macros and view and edit VBA code.
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:  MS Excel Level 2 or equivalent experience.
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600