Microsoft® Office Excel® 2007: Level 2

Course Specifications

Course length: 1.0 day(s)

Course Description

In Microsoft® Office Excel® 2007: Level 1, you created, edited, formatted, and printed basic spreadsheets. You now have a need to streamline repetitive tasks and display spreadsheet data in more visually effective ways. In this course, you will use Microsoft Office Excel 2007 to streamline and enhance your spreadsheets with templates, charts, graphics, and formulas.

Prerequisites: Before starting this course, students are recommended to take the following Element K course or possess equivalent knowledge: Microsoft Office Excel 2007: Level 1.

Course Content

Lesson 1: Calculating Data with Advanced Formulas

Manage Cell and Range Names

Calculate Data Across Worksheets

Use Specialized Functions

Analyze Data with Logical and Lookup Functions

Lesson 2: 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

Lesson 3: Presenting Data Using Charts

Create a Chart

Modify Charts

Format Charts

Lesson 4: Analyzing Data Using PivotTables and PivotCharts

Create a PivotTable Report

Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects

Insert and Modify Pictures and ClipArt

Draw and Modify Shapes

Illustrate Workflow Using SmartArt Graphics

Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing Workbooks and the Excel Environment

Customize the Excel Environment

Customize Workbooks

Manage Themes

Create and Use Templates