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
Charts & Graphs
1.0 Creating a Chart
1.1 Quick Chart Creation
1.2 Chart Wizard
1.3 Using the Chart Toolbar
1.4 Copying Moving and Reshaping a Chart
2.0 Formatting a Chart
2.1 Selecting Elements to Format
2.2 Color Backgrounds and Fill Effects
2.3 Controlling Text Size and Position
2.4 Series Order and Column Options
3.0 Chart Content
3.1 Titles and Data Labels
3.2 Gridlines and Legends
3.3 Scaling Column and Line Charts
3.4 Add and Remove Data From a Chart
3.5 Adding Trendline
4.0 Specific Chart Types
4.1 Line Charts
4.2 Column Charts
4.3 Pie Charts
4.4 Combination Charts
5.0 Printing Charts
5.1 Printing a Chart From a Separate Sheet
5.2 Printing a Chart Located on a Worksheet
6.0 Annotating Charts & Worksheets
6.1 Adding Text and Arrows
6.2 Inserting Hiding and Editing Comments
6.3 Printing Comments
7.0 Outlining and Custom Views
7.1 Group and Outlining Capabilities
7.2 Custom Views
8.0 Drawing Toolbar
8.1 WordArt
8.2 Shapes Lines and Arrows
8.3 Coloring Objects and Adding Text
8.4 Clipart
8.5 Applying 3-D and Shadow Effect
Database Features
1.0 Excel Database
1.1 List Attributes and Building Lists
2.0 Data Form
2.1 Single Record With Formulas
2.2 Adding Records to a Database
2.3 Finding Records
3.0 Data Validation
3.1 Establishing Data Entry Criteria
3.2 Using Formulas and Lists to Restrict Data
3.3 Using Data Validation on Existing Data
3.4 Data Validation Exclusions
4.0 Data Sort
4.1 Sorting from the Menu
4.2 Sorting from the Toolbar
4.3 Multiple-Key Sorting
4.4 Sorting with Custom Lists
4.5 Sorting Columns
5.0 Data Subtotals
5.1 Single Level Subtotals
5.2 Multiple Level Subtotals
6.0 Data Filter
6.1 Criteria
6.2 Multiple Column
6.3 Creating Custom Filters
6.4 Top-ten
6.5 Formatting Data
6.6 Using SUBTOTAL function
6.7 Advanced Filter
7.0 Data Functions
7.1 SUMIF COUNTIF
7.2 Array Formulas
7.3 Database Functions
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
Tips & Tricks
1.0 Navigation Shortcuts
1.1 Navigating Around a Worksheet
1.2 Navigating to the End of Columns
1.3 Workbook/Worksheet Navigation
1.4 Navigating and Zooming with the Mouse
2.0 Selection Shortcuts
2.1 Selecting Ranges
2.2 Selecting Visible- Blank or Text Cells
3.0 Data Entry Shortcuts
3.1 Date and Time
3.2 Move On Enter
3.3 Multiple Cell Entries
3.4 AutoComplete with Keyboard or Mouse
3.5 Multi-line and Comment Entries
3.6 Editing Shortcuts
4.0 Operational Shortcuts
4.1 Undoing and Repeating
4.2 File and Menu Shortcuts
4.3 Columns and Rows
4.4 Re-wrapping Text Entries
4.5 Split screen Shortcuts
4.6 Toolbar Adjustments
5.0 Formula and Function Tips
5.1 Basic Formula Tips
5.2 Locating and Displaying Formulas
5.3 Dependent and Precedent Cells
5.4 Formula Conversion and Evaluation
5.5 Auto-Sum Variations
5.6 TRIM and SUBTOTAL
6.0 Numerical Formatting
6.1 Numerical Keyboard Shortcuts
6.2 Handling Large Numbers
7.0 Data Expansion
7.1 Numerical Series
7.2 Date and Time Series
7.3 Rapid Copy
8.0 Drag and Drop
8.1 Moving and Copying Cells
8.2 Inserting Copying and Moving
9.0 Graphical Shortcuts
9.1 Repeating and Duplicating Objects
9.2 Linked and Unlinked Pictures
9.3 Chart Creation and Movement Tips
| 