• Starting Excel 2007
• What's New in Excel 2007
• Understanding the Excel Program Screen
• Understanding the Ribbon
• Using the Office Button and Quick Access Toolbar
• Using Keyboard Commands
• Using Contextual Menus and the Mini Toolbar
• Using Help
• Exiting Excel 2007

Excel Chapter Two: Worksheet Basics

• Creating a New Workbook
• Opening a Workbook
• Navigating a Worksheet
• Entering Labels
• Entering Values
• Selecting a Cell Range
• Overview of Formulas and Using AutoSum
• Entering Formulas
• Using AutoFill
• Understanding Absolute and Relative Cell References
• Using Undo and Redo
• Saving a Workbook
• Previewing and Printing a Worksheet
• Closing a Workbook

Excel Chapter Three: Editing a Worksheet

• Editing Cell Contents
• Cutting, Copying, and Pasting Cells
• Moving and Copying Cells Using the Mouse
• Using the Office Clipboard
• Using the Paste Special Command
• Checking Your Spelling
• Inserting Cells, Rows, and Columns
• Deleting Cells, Rows, and Columns
• Using Find and Replace
• Using Cell Comments
• Using the Research Task Pane
• Tracking Changes

Excel Chapter Four:
Formatting a Worksheet

• Cutting, Copying, and Pasting Cells
• Moving and Copying Cells Using the Mouse
• Using the Office Clipboard
• Using the Paste Special Command
• Checking Your Spelling
• Inserting & Deleting Cells, Rows, and Columns
• Using Find and Replace
• Using Cell Comments
• Using the Research Task Pane
• Tracking Changes

Excel Chapter Five:
Creating and Working with Charts

• Creating a Chart
• Resizing and Moving a Chart
• Changing Chart Type
• Applying Built-in Chart Layouts and Styles
• Working with Chart Labels
• Working with Chart Axes
• Working with Chart Backgrounds
• Working with Chart Analysis Commands
• Formatting Chart Elements
• Changing a Chart's Source Data
• Using Chart Templates

Excel Chapter Six: Managing Workbooks

• Viewing a Workbook
• Working with the Workbook Window
• Splitting and Freezing a Workbook Window
• Selecting Worksheets in a Workbook
• Inserting and Deleting Worksheets
• Renaming, Moving and Copying Worksheets
• Working with Multiple Workbooks
• Hiding Rows, Columns, Worksheets and Windows
• Protecting a Workbook
• Protecting Worksheets and Worksheet Elements
• Sharing a Workbook
• Creating a Template

Excel Chapter Seven:
Working with Page Layout and Printing

• Creating Headers and Footers
• Using Page Breaks
• Adjusting Margins and Orientation
• Adjusting Size and Scale
• Adding Print Titles, Gridlines and Headings
• Printing Options

Excel Chapter Eight:
More Functions and Formulas

• Formulas with Multiple Operators
• Inserting and Editing a Function
• Auto Calculate and Manual Calculation
• Defining Names
• Using and Managing Defined Names
• Displaying and Tracing Formulas
• Understanding Formula Errors
• Working with Data Ranges
• Sorting by One Column
• Sorting by Colours or Icons
• Sorting by Multiple Columns
• Sorting by a Custom List
• Filtering Data
• Creating a Custom AutoFilter
• Using an  Filter

Excel Chapter Nine: Working with Tables

• Creating a Table
• Working with Table Size
• Working with the Total Row
• Working with Table Data
• Summarizing a Table with a PivotTable
• Using the Data Form
• Using Table Styles
• Using Table Style Options
• Creating and Deleting Custom Table Styles
• Convert or Delete a Table

Excel Chapter Ten:
Working with PivotTables

• Creating a PivotTable
• Specifying PivotTable Data
• Changing a PivotTable’s Calculation
• Filtering and Sorting a PivotTable
• Working with PivotTable Layout
• Grouping PivotTable Items
• Updating a PivotTable
• Formatting a PivotTable
• Creating a PivotChart

Excel Chapter Eleven:
Analyzing and Organizing Data

• Creating Scenarios
• Creating a Scenario Report
• Working with Data Tables
• Using Goal Seek
• Using Data Validation
• Using Text to Columns
• Removing Duplicates
• Grouping and Outlining Data
• Using Subtotals
• Consolidating Data by Position or Category
• Consolidating Data Using Formulas

Excel Chapter Twelve:
Working with the Web and External Data

• Inserting a Hyperlink
• Creating a Web Page from a Workbook
• Importing Data from Access or Text Files
• Importing Data from the Web and Other Sources
• Working with Existing Data Connections

Excel Chapter Thirteen:
Working with Macros

• Recording a Macro
• Playing and Deleting a Macro
• Adding a Macro to the Quick Access Toolbar
• Editing a Macro’s Visual Basic Code
• Inserting Copied Code in a Macro
• Declaring Variables and Adding Remarks to VBA Code
• Prompting for User Input
• Using the If...Then...Else Statement

Excel Chapter Fourteen:
Working with Objects

• Inserting Clip Art
• Inserting Pictures and Graphics Files
• Formatting Pictures and Graphics
• Inserting Shapes
• Formatting Shapes
• Resize, Move, Copy and Delete Objects
• Applying Special Effects to Objects
• Grouping Objects
• Aligning Objects
• Flipping and Rotating Objects
• Layering Objects
• Inserting SmartArt
• Working with SmartArt Elements
• Formatting SmartArt
• Using WordArt
• Inserting an Embedded Object
• Inserting Symbols

Excel Chapter Fifteen:  Topics

• Customizing the Quick Access Toolbar
• Using and Customizing AutoCorrect
• Changing Excel’s Default Options
• Recovering Your Documents
• Using Microsoft Office Diagnostics
• Viewing Document Properties and Finding a File
• Saving a Document as PDF or XPS
• Adding a Digital Signature to a Workbook
• Preparing Documents for Publishing and Distribution
• Publishing a Workbook to a Document Workspace
• Creating a Custom AutoFill List
• Creating a Custom Number Format