Chapter One: The Fundamentals

• Starting Excel
• What's New in Excel?
• Understanding the Excel Program Screen
• Using Menus
• Using Toolbars and Creating a New Workbook
• Hiding, Displaying, and Moving Toolbars
• Filling Out Dialog Boxes
• Keystroke and Right Mouse Button Shortcuts
• Opening a Workbook
• Saving a Workbook
• Moving the Cell Pointer
• Navigating a Worksheet
• Entering Labels in a Worksheet
• Entering Values in a Worksheet and Selecting a Cell Range
• Calculating Value Totals with AutoSum
• Entering Formulas
• Using AutoFill
• Previewing and Printing a Worksheet
• Getting Help from the Office Assistant
• Changing the Office Assistant and Using the "What's This" Button
• Closing a Workbook and Exiting Excel
• Chapter One Review

Beginning

Chapter Two: Editing a Workbook

• Entering Date Values and using AutoComplete
• Editing, Clearing, and Replacing Cell Contents
• Cutting, Copying, and Pasting Cells
• Moving and Copying Cells with Drag and Drop
• Collecting and Pasting Multiple Items
• Working with Absolute and Relative Cell References
• Using the Paste Special Command
• Inserting and Deleting Cells, Rows, and Columns
• Using Undo, Redo, and Repeat
• Checking Your Spelling
• Finding and Replacing Information
• Advanced Printing Options
• File Management
• Inserting Cell Comments
• Chapter Two Review

Beginning

Chapter Three: Formatting a Worksheet

• Formatting Fonts with the Formatting Toolbar
• Formatting Values
• Adjusting Row Height and Column Width
• Changing Cell Alignment
• Adding Borders
• Applying Colors and Patterns
• Using the Format Painter
• Using AutoFormat
• Creating a Custom Number Format
• Creating, Applying, and Modifying a Style
• Formatting Cells with Conditional Formatting
• Merging Cells, Rotating Text, and using AutoFit
• Chapter Three Review

Intermediate

Chapter Four: Creating and Working with Charts

• Creating a Chart
• Moving and Resizing a Chart
• Formatting and Editing Objects in a Chart
• Changing a Chart's Source Data
• Changing a Chart Type and Working with Pie Charts
• Adding Titles, Gridlines, and a Data Table
• Formatting a Data Series and Chart Axis
• Annotating a Chart
• Working with 3-D Charts
• Selecting and Saving a Custom Chart
• Using Fill Effects
• Mapping Data
• Modifying a Map
• Chapter Four Review

Intermediate

Chapter Five: Managing Your Workbooks

• Switching Between Sheets in a Workbook
• Inserting and Deleting Worksheets
• Renaming and Moving Worksheets
• Working with Several Workbooks and Windows
• Splitting and Freezing a Window
• Referencing External Data
• Creating Headers, Footers, and Page Numbers
• Specifying a Print Area and Controlling Page Breaks
• Adjusting Page Margins and Orientation
• Adding Print Titles and Gridlines
• Changing the Paper Size and Print Scale
• Protecting a Worksheet
• Hiding Columns, Rows and Sheets
• Viewing a Worksheet and Saving a Custom View
• Working with Templates
• Consolidating Worksheets
• Chapter Five Review

Intermediate

Chapter Six: More Functions and Formulas

• Formulas with Several Operators and Cell Ranges
• Using the Formula Palette to Enter and Edit Formulas
• Creating and Using Range Names
• Selecting Nonadjacent Ranges and Using AutoCalculate
• Using the IF Function to Create Conditional Formulas
• Using the PMT Function
• Displaying and Printing Formulas
• Fixing Errors in Your Formulas
• Mathematical Functions (Reference)
• Financial Functions (Reference)
• Date and Time Functions (Reference)
• Statistical Functions (Reference)
• Database Functions (Reference)
• Chapter Six Review

Intermediate

Chapter Seven: Working with Lists

• Creating a List
• Using the Data Form to Add Records
• Finding Records
• Deleting Records
• Sorting a List
• Filtering a List with the AutoFilter
• Creating a Custom AutoFilter
• Filtering a List with an Advanced Filter
• Copying Filtered Records
• Using Data Validation
• Chapter Seven Review

Advanced

Chapter Eight: Automating Tasks with Macros

• Recording a Macro
• Playing a Macro and Assigning a Macro a Shortcut Key
• Adding a Macro to a Toolbar
• Editing a Macro's Visual Basic Code
• Inserting Code in an Existing Macro
• Declaring Variables and Adding Remarks to VBA Code
• Prompting for User Input
• Using the If-Then-Else Statement
• Chapter Eight Review

Advanced

Chapter Nine: Working with Other Programs

• Inserting an Excel Worksheet into a Word Document
• Modifying an Inserted Excel Worksheet
• Inserting a Linked Excel Chart in a Word Document
• Inserting a Graphic into a Worksheet
• Opening and Saving Files in Different Formats
• Chapter Nine Review

Advanced

Chapter Ten: Using Excel with the Internet

• Adding Hyperlinks to a Worksheet
• Browsing Hyperlinks and using the Web Toolbar
• Saving a Workbook as a Non-Interactive Web Page
• Saving a Workbook as an Interactive Web Page
• Using Queries to Retrieve Information from the Web
• Chapter Ten Review

Advanced

Chapter Eleven: Data Analysis and PivotTables

• Creating a PivotTable
• Specifying the Data a PivotTable Analyzes
• Changing a PivotTable's Calculation
• Selecting What Appears in a PivotTable
• Grouping Dates in a PivotTable
• Updating a PivotTable
• Formatting and Charting a PivotTable
• Creating Subtotals
• Using Database Functions
• Using Lookup Functions
• Grouping and Outlining a Worksheet
• Chapter Eleven Review

Advanced

Chapter Twelve: What-If Analysis

• Defining a Scenario
• Creating a Scenario Summery Report
• Using a One and Two-Input Data Table
• Understanding Goal Seek
• Using Solver
• Chapter Twelve Review

Advanced

Chapter Thirteen: Advanced Topics

• Creating and Using Custom Toolbars
• Creating a Custom AutoFill List
• Changing Excel's Options
• Password Protecting a Workbook
• File Properties and Finding a File
• Sharing a Workbook and Tracking Changes
• Merging and Revising a Shared Workbook
• Using Detect and Repair
• Chapter Thirteen Review

Advanced