This course is not currently offered by Global Knowledge. Information here is provided for reference only.

In this Microsoft official e-Learning course, you will learn about the features and functionality in the latest version of Microsoft Office Excel. You will gain the knowledge and skills needed to organize and analyze business information in Excel.

What You'll Learn

• Interface elements of Microsoft Office Excel 2007
• Create and modify a workbook
• Analyze business information by using Excel 2007
• Share and manage business information by using Excel 2007

Who Needs to Attend

• Users of previous Microsoft Office versions, including business customers and individual Office users who plan on upgrading to Office 2007
• End users who want advanced-level proficiency in using Microsoft Excel 2007

Prerequisites

There are no prerequisites for this course.

Follow-On Courses

There are no follow-ons for this course.

Course Outline

1. Getting Started with Microsoft Office Excel 2007

• Exploring the Excel 2007 Environment
• Creating and Modifying a Workbook
• Modifying a Worksheet
• Editing Data in a Workbook

2. Performing Calculations on Data in Microsoft Office Excel 2007

• Managing Groups of Data
• Using Formulas for Performing Calculations on Data
• Identifying Errors in a Formula

3. Formatting and Printing Worksheets in Microsoft Office Excel 2007

• Changing Workbook Appearance
• Enhancing the Readability of a Workbook
• Printing Worksheets

4. Filtering and Summarizing Data in Microsoft Office Excel 2007

• Filtering Data
• Reordering Data
• Validating Data

5. Working with Pivot Tables and Charts in Microsoft Office Excel 2007

• Creating and Manipulating PivotTable Reports
• Editing and Formatting PivotTable Reports
• Creating and Customizing a Chart

6. Collaborating with Others in Microsoft Office Excel 2007

• Allowing Multiple Users to Access a Workbook
• Managing a Shared Workbook
• Protecting and Authenticating Workbooks

7. Analyzing Data and Working with Macros in Microsoft Office Excel 2007

• Analyzing Data
• Using Macros

8. What's New in Microsoft Office Excel 2007

• Exploring the New Fluent Interface
• Organizing Business Information
• Analyzing Business Information
• Sharing and Managing Business Information

Labs

Lab 1: Setting up a Workbook

Lab 2: Modifying a Workbook

Lab 3: Inserting and Modifying Columns and Rows

Lab 4: Entering a Data Series

Lab 5: Moving, Finding, and Replacing a Value in a Workbook

Lab 6: Finding a Cell in the Workbook with a Particular Format

Lab 7: Adding and Modifying a Row in a Table

Lab 8: Naming Groups of Data

Lab 9: Using Relative and Absolute References to Create a Formula

Lab 10: Auditing a Worksheet

Lab 11: Creating and Applying Styles to Cells

Lab 12: Applying Themes and Styles

Lab 13: Creating and Applying Conditional Formats

Lab 14: Creating a Custom Header for a Workbook

Lab 15: Creating and Using Filters

Lab 16: Sorting a Data List in Excel 2007

Lab 17: Creating a Validation Rule

Lab 18: Creating and Pivoting a PivotTable Report

Lab 19: Formatting a PivotTable Report

Lab 20: Customizing a Chart

Lab 21: Sharing a Workbook

Lab 22: Tracking Changes in a Workbook

Lab 23: Password-Protecting a Workbook

Lab 24: Analyzing Data and Working with Macros in Excel 2007

Lab 25: Creating Professional-Looking Charts

Lab 26: Creating PivotTable and PivotChart Reports