01 - Getting Started

 1.1 - Spreadsheet Terminology
 1.2 - The Excel Environment
 1.3 - Navigating a Worksheet
 1.4 - Using a Template

02 - Entering & Editing Data

 2.1 - Entering & Editing Text & Values
 2.2 - Entering & Editing Formulas
 2.3 - Saving & Updating Workbooks
 2.4 - Lesson Exercise

03 - Modifying a Worksheet

 3.1 - Moving & Copying Data
 3.2 - Moving, Copying, & Viewing Formulas
 3.3 - Absolute & Relative References
 3.4 - Inserting & Deleting Ranges, Rows, Columns
 3.5 - Lesson Exercise

04 - Functions

 4.1 - Entering functions
 4.2 - AutoSum
 4.3 - Other Common Functions
 4.4 - Lesson Exercise

05 - Formatting

 5.1 - Text Formatting
 5.2 - Row and column formatting
 5.3 - Number formatting
 5.4 - Conditional formatting
 5.5 - Additional formatting options
 5.6 - Lesson Exercise

06 - Charts

 6.1 - Chart Basics
 6.2 - Formatting Charts
 6.3 - Lesson Exercise

07 - Graphics

 7.1 - Working with Pictures
 7.2 - Conditional Formatting w/ Graphics
 7.3 - SmartArt Graphics
 7.4 - Lesson Exercise

08 - Printing

 8.1 - Preparing to Print
 8.2 - Page Setup Options
 8.3 - Printing Worksheets
 8.4 - Lesson Exercise

00 - Getting Started

01 - Managing Workbooks And Worksheets

 1.1 - Viewing Large Worksheets
 1.2 - Printing Large Worksheets
 1.3 - Working With Multiple Worksheets
 1.4 - Linking Worksheets With 3-D Formulas
 1.5 - Using Multiple Workbooks
 1.6 - Linking Workbooks
 1.7 - Lesson Exercise

02 - Advanced Formatting

 2.1 - Using Special Number Formats
 2.2 - Other Advanced Formatting
 2.3 - Lesson Exercise

03 - Outlining And Subtotals

 3.1 - Outlining And Consolidating Data
 3.2 - Creating Subtotals
 3.3 - Lesson Exercise

04 - Cell And Range Names

 4.1 - Creating And Using Names
 4.2 - Managing Names
 4.3 - Lesson Exercise

05 - Data Structure And Tables

 5.1 - Sorting And Filtering Data
 5.2 - Working With Tables
 5.3 - Lesson Exercise

06 - Web And Sharing Features

 6.1 - Saving workbooks as Web Pages
 6.2 - Using Hyperlinks
 6.3 - Sharing workbooks
 6.4 - Lesson Exercise

07 - Documenting And Auditing

 7.1 - Auditing Features
 7.2 - Comments In Cells And Workbooks
 7.3 - Protection
 7.4 - Lesson Exercise

08 - Template and Settings

 8.1 - Changing Application Settings
 8.2 - Working with Templates
 8.3 - Lesson Exercise

00 - Getting Started

01 - Advanced Functions and Formulas

 1.1 - Logical functions
 1.2 - Conditional Functions
 1.3 - Financial Function
 1.4 - Text Functions
 1.5 - Date Functions
 1.6 - Array Formulas
 1.7 - Lesson Exercise

02 - Lookups and Data Tables

 2.1 - Using Lookup Functions
 2.2 - Using MATCH and INDEX
 2.3 - Creating Data Tables
 2.4 - Lesson Exercise

03 - Advanced Data Management

 3.1 - Validating Cell Entries
 3.2 - Advanced Filtering
 3.3 - Lesson Exercise

04 - Advanced Charting

 4.1 - Chart Formatting Options
 4.2 - Combination Charts
 4.3 - Graphical Objects
 4.4 - Lesson Exercise

05 - PivotTables and PivotCharts

 5.1 - Working with PivotTables
 5.2 - Modifying PivotTable Data
 5.3 - Formatting PivotTables
 5.4 - Using PivotCharts
 5.5 - Lesson Exercise

06 - Exporting and Importing Data

 6.1 - Exporting and Importing Text Files
 6.2 - Getting External Data
 6.3 - Lesson Exercise

07 - Analytical Tools

 7.1 - Goal Seek
 7.2 - Scenarios
 7.3 - Lesson Exercise

08 - Macros and Visual Basic

 8.1 - Running and Recording a Macro
 8.2 - Working with VBA Code
 8.3 - Lesson Exercise