Module 1: What's New in Excel 2007

This module explains the new features that are included in Excel 2007.

Lessons

• Becoming Familiar with the New User Interface
• Managing Larger Data Collections
• Using the New Microsoft Office File Format
• Formatting Cell and Worksheets
• Managing Data Tables More Effectively
• Creating Formulas More Easily by Using Formula AutoComplete
• Summarizing Data Using New Functions
• Creating Powerful Conditional Formats
• Creating More Attractive Charts
• Controlling Printouts More Carefully

After completing this module, students will be able to:

Module 2: Setting Up a Workbook

This module explains how to create and modify workbooks, create and modify worksheets, make workbooks easier to find, and customize the Excel 2007 program window.

Lessons

• Creating Workbooks
• Modifying Workbooks
• Modifying Worksheets
• Customizing the Excel 2007 Program Window

After completing this module, students will be able to:

Module 3: Working with Data and Data Tables

This module explains how to enter and revise Excel 2007 data, move data within a workbook, find and replace existing data, use proofing and reference tools to enhance data, and organize data by using Excel 2007 data tables.

Lessons

• Entering and Revising Data
• Moving Data Within a Workbook
• Finding and Replacing Data
• Correcting and Expanding Upon Worksheet Data
• Defining a Table

After completing this module, students will be able to:

Module 4: Performing Calculations on Data

This module explains how to streamline references to groups of data on worksheets and how to create and correct formulas that summarize Consolidated Messenger's business operations.

Lessons

• Naming Groups of Data
• Creating Formulas to Calculate Specific Conditions
• Finding and Correcting Errors in Calculations

After completing this module, students will be able to:

Module 5: Changing Document Appearance

This module explains how to change the appearance of data, apply existing formats to data, make numbers easier to read, change data's appearance based on its value, make printouts easier to follow, and position the data on the printed page.

Lessons

• Formatting Cells
• Defining Styles
• Applying Workbook Themes and Tables Styles
• Making Numbers Easier to Read
• Changing the Appearance of Data Based on Its Value
• Adding Images to a Document

After completing this module, students will be able to:

Module 6: Focusing on Specific Data Using Filters

This module explains how to limit the data that appears on the screen, manipulate list data, and create validation rules that limit data entry to appropriate values.

Lessons

• Limiting Data That Appears on ther Screen
• Manipulating List Data
• Defining Valid Sets of Values for Ranges of Cells

After completing this module, students will be able to:

Module 7: Reordering and Summarizing Data

This module explains how to sort the data using one or more criteria, calculate subtotals, organize data into levels, and look up information in a data list.

Lessons

• Sorting Data Lists
• Organizing Data into Levels
• Looking Up Information in a Data List

After completing this module, students will be able to:

Module 8: Combining Data from Multiple Sources

This module explains how to use a data list as a template for other lists, work with more than one set of data, link to data in other workbooks, summarize multiple sets of data, and group multiple data lists.

Lessons

• Using Data Lists as Templates for Other Lists
• Linking to Data in Other Worksheets and Workbooks
• Consolidating Multiple Sets of Data into a Single Workbook
• Grouping Multiple Sets of Data

After completing this module, students will be able to:

Module 9: Analyzing Alternative Data Sets

This module explains how to define alternative data sets and determine the necessary inputs to make a calculation produce a particular result.

Lessons

• Defining and Editing Alternative Data Sets
• Defining Multiple Alternative Data Sets
• Varying Data to Get a Desired Result Using Goal Seek
• Finding Optimal Solutions with Solver
• Analyzing Data with Descriptive Statistics

After completing this module, students will be able to:

Module 10: Creating Dynamic Lists with PivotTables

This module explains how to create and edit Microsoft Office PivotTables from an existing worksheet and how to create a PivotTable with data imported from a text file.

Lessons

• Analyzing Data Dynamically with PivotTables
• Filtering, Showing, and Hiding PivotTable Data
• Editing PivotTables
• Formatting PivotTables
• Creating PivotTables from External Data

After completing this module, students will be able to:

Module 11: Creating Charts and Graphics

This module explains how to create a chart and customize its elements, find trends in the overall data, create dynamic charts, and create and format diagrams.

Lessons

• Creating Charts
• Customizing the Appearance of Charts
• Finding Trends in Data
• Creating Dynamic Charts Using Microsoft Office PivotCharts
• Creating Diagrams by Using Microsoft Office SmartArt

After completing this module, students will be able to:

Module 12: Printing

This module explains how to print all or part of a data list, how to print charts, and how to add headers and footers to worksheets.

Lessons

• Adding Headers and Footers to Printed Pages
• Preparing Worksheets for Printing
• Printing Data Lists
• Printing Parts of Data Lists
• Printing Charts

After completing this module, students will be able to:

Module 13: Automating Repetitive Tasks with Macros

This module explains how to open, run, create, and modify macros. It also explains how to create Quick Access Toolbar buttons and shapes that enable you to run macros with a single mouse click, define macro security settings, and run a macro when a workbook is opened.

Lessons

• Introducing Macros
• Creating and Modifying Macros
• Running Macros When a Button is Clicked
• Running Macros When a Workbook is Opened

After completing this module, students will be able to:

Module 14: Working with Other Microsoft Office System Programs

This module explains how to include a Microsoft Office System document in a worksheet, store an Excel 2007 workbook as part of another Microsoft Office System document, create hyperlinks, and paste an Excel 2007 chart into another document.

Lessons

• Including Microsoft Office System Documents in Excel 2007 Worksheets
• Storing Excel 2007 Documents as Parts of Other Microsoft Office System Documents
• Creating Hyperlinks
• Pasting Charts into Other Documents

After completing this module, students will be able to:

Module 15: Collaborating with Colleagues

This module explains how to share a data list, manage comments to workbook cells, track and manage changes made by colleagues, protect workbooks and worksheets, and digitally sign workbooks.

Lessons

• Sharing Data Lists
• Managing Comments
• Tracking and Managing Colleagues' Changes
• Protecting Workbooks and Worksheets
• Authenticating Workbooks
• Saving Workbooks for the Web

After completing this module, students will be able to: