Microsoft Office Excel 2007- Dedicated - ADC

 Microsoft® Office Excel® 2007: Intermediate – Part 1

Pre-Work:
Quick review of key concepts from Excel 2007 – Level 1
Explore the User Interface and the Ribbon
Topic 1E: Customize the Quick Access Toolbar

Lesson 1: Calculating Data with Advanced Formulas
Topic 1A: Manage Cell and Range Names
Topic 1B: Calculate Data Across Worksheets
Topic 1C: Use Specialized Functions
Topic 1D: Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data
Topic 2A: Create and Modify Tables
Topic 2B: Format Tables
Topic 2C: Sort or Filter Worksheet or Table Data
Topic 2D: Calculate Data in a Table or Worksheet

Lesson 3: Presenting Data Using Charts
Topic 3A: Create a Chart
Topic 3B: Modify Charts
Topic 3C: Format Charts