Home > Courses Certifications > Microsoft Office > Excel 2007 Level 2 synopsis

Microsoft Excel 2007 - Level 2

Prerequisites: Excel 2007 - Level 1

Duration: 1 day

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