MICROSOFT EXCEL 2008 (MACINTOSH)

Level 1

Creating a Basic Worksheet

Explore the User Interface

Navigate and Select in Excel

Obtain Help

Enter Data and Save a Workbook

Customize Toolbars and Menus

Performing Calculations

Create Basic Formulas

Calculate with Functions

Copy Formulas and Functions

Modifying a Worksheet

Manipulate Data

Insert and Delete Cells, Columns, and Rows

Search for Data in a Worksheet

Spell Check a Worksheet

Formatting a Worksheet

Modify Fonts

Add Borders and Colors to Cells

Change the Column Width and Row Height

Apply Number Formats

Position Cell Contents

Apply Cell Styles

Printing Workbook Contents

Print Workbook Contents Using Default Print Options

Set Print Options

Set Page Breaks

Managing Large Workbooks

Format Worksheet Tabs

Manage Worksheets in a Workbook

Manage the View of Large Worksheets

Level 2

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 List Data

Create Lists

Sort or Filter List Data

Presenting Data Using Charts

Create a Chart

Modify Charts

Format Charts

Analyzing Data Using PivotTables

Create a PivotTable Report

Analyze PivotTable Data

Inserting Graphic Objects

Insert and Modify Pictures and ClipArt

Draw and Modify Shapes

Illustrate Workflow Using SmartArt Graphics

Arrange and Group Graphic Objects

Customizing and Enhancing Workbooks and the Excel Environment

Customize the Excel Environment

Customize Workbooks

Manage Themes

Create and Use Templates