Course Outline for Microsoft Office Excel 2007, Level 2

  • Calculating Data with Advanced Formulas
    • Manage Cell and Range Names
    • Calculate Data Across Worksheets
    • Use Specialized Functions
    • Analyze Data with Logical and Lookup Functions
  • 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
  • Presenting Data Using Charts
    • Create a Chart
    • Modify Charts
    • Format Charts
  • Analyzing Data Using PivotTables and PivotCharts
    • Create a PivotTable Report
    • Analyze Data Using PivotCharts
  • Inserting Graphic Objects
    • Insert and Modify Pictures and ClipArt
    • Draw and Modify Shapes
    • Illustrate Workflow Using SmartArt Graphics
    • Layer and Group Graphic Objects
  • Customizing and Enhancing Workbooks and the Excel Environment
    • Customize the Excel Environment
    • Customize Workbooks
    • Manage Themes
    • Create and Use Templates