Module 1: Introduction to Excel 2007

This module discusses the new Excel interface and explains how to work with workbooks, including how to create and modify them. It also explains how to customize the Excel program window to suit your needs.

Lessons

• Becoming Familiar with the New User Interface
• Creating Workbooks
• Modifying Workbooks
• Customizing the Excel 2007 Program Window

Lab: Introduction to Excel 2007

• Create and save a new workbook, save a workbook with a new name, and work with properties.
• Insert, rename, move, hide, copy, and delete sheets.
• Change zoom level, zoom in on a range, switch and cascade workbooks, and add a button to the Quick Access Toolbar.

After completing this module, students will be able to:

Module 2: Data

This module explains how to enter and edit worksheet data, rearrange data, find and replace specific information, and use tools to check spelling, find synonyms, and translate words.

Lessons

• Entering and Revising Data
• Modifying Worksheets
• Moving Data Within a Workbook
• Finding and Replacing Data
• Correcting and Expanding Upon Worksheet Data

Lab: Data

• Enter data in different ways, including filling a data series.
• Insert columns, rows, and cells; and delete and move cells and groups of cells.
• Copy column headers, move a column of data, and choose how data is pasted.
• Find a specific value, replace every occurrence, and find a cell with specific formatting.
• Check spelling, search for synonyms, and translate a word.

After completing this module, students will be able to:

Module 3: Formatting

This module explains how to format data, cells, and cell ranges; create and apply styles such as table styles and themes; and make data easier to read.

Lessons

• Formatting Cells
• Defining Styles
• Applying Workbook Themes and Table Styles
• Making Numbers Easier to Read

Lab: Formatting

• Change the formatting of data, and add a border and fill color to a cell range.
• Create a style, apply the new style, and use the Format Painter.
• Create a table style, and apply it to a table; and create and apply a theme.
• Assign date, phone number, and currency formats to cells.

After completing this module, students will be able to:

Module 4: Charts and Data Tables

This module explains how to create and modify charts and data tables.

Lessons

• Creating Charts
• De?ning a Table

Lab: Charts and Data Tables

• Create, modify, and move a chart first within the worksheet and then to its own chart sheet.
• Create a data table, add data, summarize the data, and rename the table.

After completing this module, students will be able to:

Module 5: Calculations

This module explains how to create named ranges and how to create and edit formulas.

Lessons

• Naming Groups of Data
• Creating Formulas to Calculate Values

Lab: Calculations

• Assign range names.
• Create and edit formulas that use table references, relative references, and absolute references.

After completing this module, students will be able to:

Module 6: Printing

This module explains how to add headers and footers to printed pages and how to preview and set up a worksheet for printing.

Lessons

• Adding Headers and Footers to Printed Pages
• Preparing Worksheets for Printing

Lab: Printing

• Create a custom header and a footer containing a graphic.
• Preview a worksheet; change its margins, orientation, size, page breaks, and page printing order.

After completing this module, students will be able to: