Excel

Microsoft Office Excel 2007: New Features

Lesson 1: Exploring the Excel Environment

• Topic 1A: Explore the User Interface
• Topic 1B: Work with the Ribbon
• Topic 1C: Work with Contextual Tabs
• Topic 1D: Use the Excel Galleries
• Topic 1E: Customize the Excel Interface

Lesson 2: Organizing Data

• Topic 2A: Explore the Enhancements in Excel 2007 Spreadsheets
• Topic 2B: Insert Tables
• Topic 2C: Format Tables

Lesson 3: Analyzing Data

• Topic 3A: Apply Conditional Formatting
• Topic 3B: Sort Data in a Spreadsheet
• Topic 3C: Filter Data in a Spreadsheet
• Topic 3D: Apply a Formula

Lesson 4: Presenting Data

• Topic 4A: Create Charts
• Topic 4B: Format Charts
• Topic 4C: Work with Illustrations
• Topic 4D: Create PivotTables and PivotCharts
• Topic 4E: Share Excel Charts
• Topic 4F: Save Data in Presentable Formats