This collection of online courses covers the core skills and knowledge you will need to get the most out of Microsoft® Office Excel 2007. It is also ideal training for the exam 77-602: MOS: Using Microsoft Office Excel 2007.

This collection of courses is 6 hours long.

This collection contains the following:

Course 5425: Getting Started with Microsoft Office Excel 2007;
Course 5426: Performing Calculations on Data in Microsoft Office Excel 2007;
Course 5427: Formatting and Printing Worksheets in Microsoft Office Excel 2007;
Course 5428: Filtering and Summarizing Data in Microsoft Office Excel 2007;
Course 5429: Working with Pivot Tables and Charts in Microsoft Office Excel 2007;
Course 5430: Collaborating with Others in Microsoft Office Excel 2007

System Requirements:
Pentium II 400 MHz;
256MB RAM;
Microsoft Internet Explorer 6.0 or higher;
256k connection (broadband recommended);
Windows XP, 2000 or higher;
Flash Player 7.0 or higher;
Speakers and soundcard.

You will need Excel 2007 installed on your machine to use some of the local labs in this course.

Subscription: 1 year

Course 5425: Getting Started with Microsoft Office Excel 2007

Getting Started with Excel 2007
Module Introduction

Exploring the Excel 2007 Environment
Lesson Introduction
Elements of the Excel 2007 User Interface
Features of Excel 2007
Self Test

Creating and Modifying a Workbook
Lesson Introduction
Create a Workbook
Lab: Setting up a Workbook
Create and Rename a Worksheet in a Workbook
Lab: Modifying a Workbook
Customize a Workbook
Self Test

Modifying a Worksheet
Lesson Introduction
Modify Columns and Rows in a Worksheet
Lab: Inserting and Modifying Columns and Rows
Data Entry Options
Lab: Entering a Data Series
Self Test

Editing Data in a Workbook
Lesson Introduction
List the Paste Options Available in Excel 2007
List the Find and Replace Dialog Box Controls
Lab: Moving, Finding, and Replacing a Value in a Workbook
Lab: Finding a Cell in the Workbook with a Particular Format
Use the Dictionary and Thesaurus
Self Test
Module Summary
Glossary

Course 5426: Performing Calculations on Data in Microsoft Office Excel 2007

Performing Calculations on Data in Excel 2007
Module Introduction

Managing Groups of Data
Lesson Introduction
Create and Rename a Table
Lab: Adding and Modifying a Row in a Table
Lab: Naming Groups of Data
Self Test

Using Formulas for Performing Calculations on Data
Lesson Introduction
Create and Edit a Formula
Use the Function Library
Lab: Using Relative and Absolute References to Create a Formula
Create a Conditional Formula
Self Test

Identifying Errors in a Formula
Lesson Introduction
Identify Error Codes
Trace the Precedents and Dependents of a Cell
Evaluate Parts of a Formula
Use the Watch Window
Lab: Auditing a Worksheet
Self Test
Module Summary
Glossary

Course 5427: Formatting and Printing Worksheets in Microsoft Office Excel 2007
Formatting and Printing Worksheets in Excel 2007
Module Introduction

Changing Workbook Appearance
Lesson Introduction
Format a Cell
Lab: Creating and Applying Styles to Cells
Workbook Themes and Styles
Create and Apply a Table Style
Lab: Applying Themes and Styles
Self Test

Enhancing the Readability of a Workbook
Lesson Introduction
Format Numeric Data
Conditional Formatting
Lab: Creating and Applying Conditional Formats
Add Images to a Worksheet
Self Test

Printing Worksheets
Lesson Introduction
Headers and Footers
Lab: Creating a Custom Header for a Workbook
Set the Workbook Properties
Lab: Printing a Worksheet
Self Test

Course 5428: Filtering and Summarizing Data in Microsoft Office Excel 2007

Filtering and Summarizing Data in Excel 2007
Module Introduction
Filtering Data

Lesson Introduction
Identify Filters in Excel 2007
Lab: Creating and Using Filters
Summarize List of Data
Lab: Performing Calculations on Filtered Data
Self Test

Reordering Data
Lesson Introduction
Sorting Options in Excel 2007
Lab: Sorting a Data List in Excel 2007
Organize Data into Levels
Find Data by Using VLOOKUP
Self Test

Validating Data
Lesson Introduction
Data Validation in Excel 2007
Lab: Creating a Validation Rule
Self Test
Module Summary

Course 5429: Working with Pivot Tables and Charts in Microsoft Office Excel 2007

Working with Pivot Tables and Charts in Excel 2007
Module Introduction

Creating and Manipulating PivotTable Reports
Lesson Introduction
PivotTable Reports in Excel 2007
Organize Data in a PivotTable Report
Lab: Creating and Pivoting a PivotTable Report
Filter a PivotTable Report
Show and Hide PivotTable Report Details
Self Test

Editing and Formatting PivotTable Reports
Lesson Introduction
Edit a PivotTable Report
Change the Summary Function in a PivotTable Report
Apply Formats to a Field
Lab: Formatting a PivotTable Report
Create a PivotTable Report from External Data
Self Test

Creating and Customizing a Chart
Lesson Introduction
Create and Manipulate a Chart
Chart Styles Gallery in Excel 2007
Customize and Save a Chart as Chart Template
Lab: Customizing a Chart
Self Test
Module Summary

Course 5430: Collaborating with Others in Microsoft Office Excel 2007

Collaborating with Others in Excel 2007
Module Introduction

Allowing Multiple Users to Access a Workbook
Lesson Introduction
Share a Workbook
Save a Workbook as a Web Document
Lab: Sharing a Workbook
Self Test

Managing a Shared Workbook
Lesson Introduction
Add Comments to a Cell in a Workbook
Manage Changes in a Shared Workbook
Lab: Tracking Changes in a Workbook
Self Test

Protecting and Authenticating Workbooks
Lesson Introduction
Access Protection
Lab: Password-Protecting a Workbook
Digital Signatures and Certificates
Authenticating a Workbook
Self Test
Module Summary