Excel 2007 - Level 2

You Will Learn To

Present data in charts; analyze data with advanced formulas and pivot tables.

Who Should Attend

Excel users already familiar with editing and formatting data in Excel.

Course Content

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