• 1 Day

Entry Requirements

  • Computer literate

Students should have completed the following courses or possess Equivalent knowledge:

  • Microsoft Office Excel 2007: Level 1


Lesson 1: Calculating Data with Advanced Formulas

  • Manage Cell and Range Names
  • Calculate Data Across Worksheets
  • Use Specialized Functions
  • Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data

  • Create and Modify Tables
  • Format Tables
  • Sort or Filter Worksheet or Table Data
  • Calculate Data in a Table or Worksheet

Lesson 3: Presenting Data Using Charts

  • Create a Chart
  • Modify Charts
  • Format Charts
  • Lesson 4: Analyzing Data Using PivotTables and PivotCharts
  • Create a PivotTable Report
  • Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects

  • Insert and Modify Pictures and ClipArt
  • Draw and Modify Shapes
  • Illustrate Workflow Using SmartArt Graphics

Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment

  • Customize the Excel Environment
  • Customize Workbooks
  • Manage Themes
  • Create and Use Templates