"Microsoft Office Excel 2007 Level 2 (Second Edition)" by Element K

Student Course Files

• 084891dd.exe
• 084891s3.doc
• Excel2007ExamMapping.doc
• My Text and Date Functions.zip

Course Content

Lesson 1: Calculating Data with Advanced Formulas (3/3)

• Topic 1A: Manage Cell and Range Names
• Topic 1B: Calculate Data Across Worksheets
  • ! (Bang) references data on another worksheet
• Topic 1C: Use Specialized Functions
  • Function/Description Chart (Microsoft.com)
• Topic 1D: Analyze Data with Logical and Lookup Functions
  • Tutorial Videos

Lesson 2: Organizing Worksheet and Table Data (3/10)

• 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 (3/17 Hour 1)

• Topic 3A: Create a Chart
• Topic 3B: Modify Charts
• Topic 3C: Format Charts

Lesson 4: Analyzing Data Using PivotTables and PivotCharts (3/17 Hour 2)

• Topic 4A: Create a PivotTable Report
• Topic 4B: Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects (3/24 Hour 1)

• Topic 5A: Insert and Modify Pictures and ClipArt
• Topic 5B: Draw and Modify Shapes
• Topic 5C: Illustrate Workflow Using SmartArt Graphics
• Topic 5D: Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment (3/24 Hour 2)

• Topic 6A: Customize the Excel Environment
• Topic 6B: Customize Workbooks
• Topic 6C: Manage Themes
• Topic 6D: Create and Use Templates

Extras