Level 1
1.0 Getting Started
1.1 Starting Excel
1.2 Workbooks and Worksheets
1.3 Task Pane
1.4 The Menu Bar
1.5 Toolbars
1.6 Navigation and the Mouse Pointer
2.0 Entering Data
2.1 Data Entry
2.2 Auto-Fill Entry
2.3 Erasing Data
2.4 AutoComplete and Preselections
2.5 Undo and Redo
3.0 Saving Opening and Closing Files
3.1 File Save and Files Save As
3.2 Opening a File
3.3 Closing a File
3.4 Creating a New Workbook
4.0 Entering Formulas
4.1 Methods of Entering Formulas
4.2 Repeating Formulas in Adjacent Fields
4.3 Formula Operators
4.4 Additional Formulas
5.0 Basic Excel Functions
5.1 Totals and Averages
5.2 Function Overview
6.0 Formatting
6.1 Adjusting Columns
6.2 Formatting Toolbar
6.3 Numeric Formatting
7.0 Changing Worksheet Layout
7.1 Inserting Columns Rows and Cells
7.2 Deleting Columns Rows and Cells
7.3 Moving Cells
7.4 Copying Cells
8.0 Printing
8.1 Using Print Preview and Page Setup
8.2 Printing Controls
8.3 Using Page Break Preview
8.4 Printing
9.0 Excel Help System
9.1 Using Excel Online Help
9.2 Using Excel Offline Help
Level 2
1.0 Additional Formatting
1.1 Cell Alignment and Orientation
1.2 Borders
1.3 Centering Text Across Columns
1.4 Hiding and Unhiding Columns and Rows
2.0 Conditional Formatting
2.1 Formatting Based on Values
2.2 Avoiding Overlapping Conditions
2.3 Using a Formula to Control Formatting
3.0 Specialized Numeric Formatting
3.1 Custom Category
3.2 Special Category
4.0 Cell References
4.1 Absolute References
4.2 Mixed References
5.0 Range Names
5.1 Naming and Using Range Names
5.2 Additional Creation Methods
5.3 Passing a List of Range Names
5.4 Deleting Range Names
5.5 Assigning a Name to a Value
6.0 Formula Auditing Techniques
6.1 Using the Formula Auditing Toolbar
6.2 Tracing Dependent Cells
6.3 Tracing Precedent Cells
7.0 Cell Protection Techniques
7.1 Unlocking/Locking Selected Cells
7.2 Protecting/Unprotecting a Worksheet
8.0 Find and Replace
8.1 Matching Entire Cells
8.2 Formulas and Wildcard Characters
8.3 Find and Replace by Format
9.0 Adjusting Worksheet Views
9.1 Freeze/Unfreeze Panes
9.2 Horizontal and Vertical Split Screens
10.0 Customizing Toolbars
10.1 Adding and Removing Buttons
10.2 Economizing Buttons
10.3 Creating New Toolbars
Level 3
1.0 The IF and VLOOKUP Functions
1.1 IF and Relational Operators
1.2 Using Text in IF Functions
1.3 Logical Operators with IF Function
1.4 Nested IF Functions
1.5 Getting Data with VLOOKUP Function
2.0 Dates and Time
2.1 Using Dates as Values
2.2 Entering a Series of Dates
2.3 Date/Time Techniques
3.0 Multi-Sheet Workbooks
3.1 Renaming Sheets and Coloring Tabs
3.2 Inserting and Deleting Sheets
3.3 Moving/Copying and Grouping Sheets
3.4 Formulas Across Multiple Sheets
4.0 Multiple Workbooks
4.1 Displaying Multiple Workbooks
4.2 Moving Sheets Across Workbooks
4.3 Linking Formulas Across Workbooks
4.3 Locating and Maintaining Links
5.0 Features and Settings
5.1 Show-Hide Gridlines and Formulas
5.2 Recently Used File List
5.3 Other Settings and Features
6.0 Overview of Charting
6.1 Quick Chart Creation
6.2 Chart Types
6.3 Titles-Gridlines and Scaling
6.4 Formatting Basics
6.5 Printing and Copying Charts
7.0 Overview of Database Features
7.1 Sorting Data
7.2 Creating Subtotals
7.3 Filtering
7.4 Pivot Tables
Additional Topics
1.0 Templates
1.1 Saving a Skeleton Workbook
1.2 Creating a New Workbook
1.3 Editing a Template
2.0 Protection
2.1 Workbook Protection
2.2 File Password
2.3 Macro Security
3.0 Sharing Workbooks
3.1 Establishing Sharing
3.2 Tracking Changes
3.3 Merging Workbooks
4.0 Exporting Data From Excel
4.1 Exporting to Access
4.2 Exporting to Word
4.3 Saving as a Text File
4.4 Saving in a New Folder
5.0 Importing Data to Excel
5.1 Using the File Open Command
5.2 Importing or Copying External Data
5.3 Hyperlinks
5.4 Tools Research
6.0 Excel and the Web
6.1 Importing Web Data
6.2 Saving Excel Data as a Webpage
7.0 Customizing Excel Environment
7.1 Creating a New Menu
7.2 Creating a Macro
7.3 Running a Macro
7.4 Editing a Macro
Special Topics
1.0 Functions
1.1 Statistical Functions
1.2 Date and Time Functions
1.3 Financial Functions
1.4 Mathematical Functions
2.0 Formula Troubleshooting
2.1 Formula Watch Window
2.2 Evaluate Formula Feature
3.0 Data Analysis Tools
3.1 Goal Seek
3.2 Solver
3.3 Scenarios
3.4 Data Table
4.0 Consolidating Data
4.1 Consolidate By Position
4.2 Consolidate By Category
5.0 Managing a List
5.1 Creating a List
5.2 Adding Data to a List
5.3 Adding Totals
6.0 File Properties
6.1 File Properties
7.0 Workbook/Worksheet
7.1 Worksheet Styles
7.2 Autoformatting
7.3 Showing Multiple Worksheets
7.4 Comparing Workbooks
| 