Unit 1 – Working with Large Worksheets.  This unit covers zooming in and out of a large worksheet, using the Freeze Panes command, and splitting a worksheet; hiding and displaying data, and creating outlines to organize data; and setting print titles and setting page breaks by using the Insert command and the Page Break Preview feature.

Unit 2 – Using Multiple Worksheets and Workbooks.  This unit covers navigating, managing, and printing multiple worksheets; creating 3-D formulae to link worksheets, and adding a Watch window; using the Consolidate command to summarize data from different worksheets; switching between workbooks, and creating and managing linked workbooks; and creating a workspace to manage workbooks.

Unit 3 – Customizing Excel.  This unit covers changing Excel's View, General, and Calculations settings; and customizing toolbars and menus.

Unit 4 – Advanced Formatting.  This unit covers adding borders and shading to a worksheet to emphasize data and improve worksheet appearance and readability; applying built-in and custom number formats to display data in specific formats and format cells based on conditions; working with date and time formats, and performing calculations on dates; creating, applying, and modifying styles to apply several kinds of formatting simultaneously; merging and changing orientation of cells to display text in special ways.

Unit 5 - List Management.  This unit covers using lists to organize data logically; sorting lists by the contents of their columns, and filtering lists to show only those rows that meet certain criteria; and using the Custom AutoFilter and Advanced Filter dialog boxes to filter lists based on complex criteria.

Unit 6 - Advanced Charting.  This unit covers adjusting the scale of a chart, and formatting data points; creating combination charts and trendlines to highlight different kinds of data; and adding and formatting graphic elements to highlight a specific portion of a chart, and adding a picture to a worksheet.

Unit 7 - Documenting and Auditing.  This unit covers using auditing features ato trace precedent and dependent cells, and tracing errors; adding comments and text boxes to a worksheet; protecting a worksheet or part of a worksheet against unauthorized access or unintentional changes; and sharing workbooks, merging versions of a workbook, and tracking changes by various users.

Unit 8 - Using Templates.  This unit covers using Excel's built-in templates to create invoices and expense reports, and creating and managing custom templates.