Introduction
Chapter 1. The Fundamentals
Lesson 1.1
Starting Excel
Lesson 1.2
What's New in Excel 2003?
Lesson 1.3
Understanding the Excel Program Screen
Lesson 1.4
Using Menus
Lesson 1.5
Using Toolbars and Creating a New Workbook
Lesson 1.6
Filling Out Dialog Boxes
Lesson 1.7
Keystroke and Right Mouse Button Shortcuts
Lesson 1.8
Opening a Workbook
Lesson 1.9
Saving a Workbook
Lesson 1.10
Moving the Cell Pointer
Lesson 1.11
Navigating a Worksheet
Lesson 1.12
Entering Labels in a Worksheet
Lesson 1.13
Entering Values in a Worksheet and Selecting a Cell Range
Lesson 1.14
Calculating Value Totals with AutoSum
Lesson 1.15
Entering Formulas
Lesson 1.16
Using AutoFill
Lesson 1.17
Previewing and Printing a Worksheet
Lesson 1.18
Getting Help
Lesson 1.19
Changing the Office Assistant and Using the "What's This" Button
Lesson 1.20
Closing a Workbook and Exiting Excel
Chapter One Review
Chapter 2. Editing a Worksheet
Lesson 2.1
Entering Date Values and Using AutoComplete
Lesson 2.2
Editing, Clearing, and Replacing Cell Contents
Lesson 2.3
Cutting, Copying, and Pasting Cells
Lesson 2.4
Moving and Copying Cells with Drag and Drop
Lesson 2.5
Collecting and Pasting Multiple Items
Lesson 2.6
Working with Absolute and Relative Cell References
Lesson 2.7
Using the Paste Special Command
Lesson 2.8
Inserting and Deleting Cells, Rows, and Columns
Lesson 2.9
Using Undo, Redo, and Repeat
Lesson 2.10
Checking Your Spelling
Lesson 2.11
Finding and Replacing Information
Lesson 2.12
Advanced Printing Options
Lesson 2.13
File Management
Lesson 2.14
Inserting Cell Comments
Lesson 2.15
Understanding Smart Tags
Lesson 2.16
Recovering Your Workbooks
Chapter Two Review
Chapter 3. Formatting a Worksheet
Lesson 3.1
Formatting Fonts with the Formatting Toolbar
Lesson 3.2
Formatting Values
Lesson 3.3
Adjusting Row Height and Column Width
Lesson 3.4
Changing Cell Alignment
Lesson 3.5
Adding Borders
Lesson 3.6
Applying Colors and Patterns
Lesson 3.7
Using the Format Painter
Lesson 3.8
Using AutoFormat
Lesson 3.9
Creating a Custom Number Format
Lesson 3.10
Creating, Applying, and Modifying a Style
Lesson 3.11
Formatting Cells with Conditional Formatting
Lesson 3.12
Merging Cells, Rotating Text, and Using AutoFit
Lesson 3.13
Finding and Replacing Formatting
Chapter Three Review
Chapter 4. Creating and Working with Charts
Lesson 4.1
Creating a Chart
Lesson 4.2
Moving and Resizing a Chart
Lesson 4.3
Formatting and Editing Objects in a Chart
Lesson 4.4
Changing a Chart's Source Data
Lesson 4.5
Changing a Chart Type and Working with Pie Charts
Lesson 4.6
Adding Titles, Gridlines, and a Data Table
Lesson 4.7
Formatting a Data Series and Chart Axis
Lesson 4.8
Annotating a Chart
Lesson 4.9
Working with 3-D Charts
Lesson 4.10
Selecting and Saving a Custom Chart
Lesson 4.11
Using Fill Effects
Chapter Four Review
Chapter 5. Managing Your Workbooks
Lesson 5.1
Switching Between Sheets in a Workbook
Lesson 5.2
Inserting and Deleting Worksheets
Lesson 5.3
Renaming and Moving Worksheets
Lesson 5.4
Working with Several Workbooks and Windows
Lesson 5.5
Splitting and Freezing a Window
Lesson 5.6
Referencing External Data
Lesson 5.7
Creating Headers, Footers, and Page Numbers
Lesson 5.8
Specifying a Print Area and Controlling Page Breaks
Lesson 5.9
Adjusting Page Margins and Orientation
Lesson 5.10
Adding Print Titles and Gridlines
Lesson 5.11
Changing the Paper Size and Print Scale
Lesson 5.12
Protecting a Worksheet
Lesson 5.13
Hiding Columns, Rows, and Sheets
Lesson 5.14
Viewing a Worksheet and Comparing Workbooks Side by Side
Lesson 5.15
Saving a Custom View
Lesson 5.16
Working with Templates
Lesson 5.17
Consolidating Worksheets
Chapter Five Review
Chapter 6. More Functions and Formulas
Lesson 6.1
Formulas with Several Operators and Cell Ranges
Lesson 6.2
Using the Insert Function Feature
Lesson 6.3
Creating and Using Range Names
Lesson 6.4
Selecting Nonadjacent Ranges and Using AutoCalculate
Lesson 6.5
Using the IF Function to Create Conditional Formulas
Lesson 6.6
Using the PMT Function
Lesson 6.7
Displaying and Printing Formulas
Lesson 6.8
Fixing Formula Errors
Mathematical Functions
Financial Functions
Date and Time Functions
Statistical Functions
Database Functions
Chapter Six Review
Chapter 7. Working with Lists
Lesson 7.1
Creating a List
Lesson 7.2
Working with Lists and Using the Total Row
Lesson 7.3
Adding Records Using the Data Form Dialog Box and Insert Row
Lesson 7.4
Finding Records
Lesson 7.5
Deleting Records
Lesson 7.6
Sorting a List
Lesson 7.7
Filtering a List with the AutoFilter
Lesson 7.8
Creating a Custom AutoFilter
Lesson 7.9
Filtering a List with an Advanced Filter
Lesson 7.10
Copying Filtered Records
Lesson 7.11
Using Data Validation
Chapter Seven Review
Chapter 8. Automating Tasks with Macros
Lesson 8.1
Recording a Macro
Lesson 8.2
Playing a Macro and Assigning a Macro a Shortcut Key
Lesson 8.3
Adding a Macro to a Toolbar
Lesson 8.4
Editing a Macro's Visual Basic Code
Lesson 8.5
Inserting Code in an Existing Macro
Lesson 8.6
Declaring Variables and Adding Remarks to VBA Code
Lesson 8.7
Prompting for User Input
Lesson 8.8
Using the If-Then-Else Statement
Chapter Eight Review
Chapter 9. Working with Other Programs
Lesson 9.1
Inserting an Excel Worksheet into a Word Document
Lesson 9.2
Modifying an Inserted Excel Worksheet
Lesson 9.3
Inserting a Linked Excel Chart in a Word Document
Lesson 9.4
Inserting a Graphic into a Worksheet
Lesson 9.5
Opening and Saving Files in Different Formats
Chapter Nine Review
Chapter 10. Using Excel with the Internet
Lesson 10.1
Adding and Working with Hyperlinks
Lesson 10.2
Browsing Hyperlinks and Using the Web Toolbar
Lesson 10.3
Saving a Workbook as a Non-Interactive Web Page
Lesson 10.4
Saving a Workbook as an Interactive Web Page
Lesson 10.5
Import an External Data Source
Lesson 10.6
Refresh a Data Source and Set Data Source Properties
Lesson 10.7
Create a New Web Query
Chapter Ten Review
Chapter 11. Data Analysis and PivotTables
Lesson 11.1
Creating a PivotTable
Lesson 11.2
Specifying the Data a PivotTable Analyzes
Lesson 11.3
Changing a PivotTable's Calculation
Lesson 11.4
Selecting What Appears in a PivotTable
Lesson 11.5
Grouping Dates in a PivotTable
Lesson 11.6
Updating a PivotTable
Lesson 11.7
Formatting and Charting a PivotTable
Lesson 11.8
Creating Subtotals
Lesson 11.9
Using Database Functions
Lesson 11.10
Using Lookup Functions
Lesson 11.11
Grouping and Outlining a Worksheet
Chapter Eleven Review
Chapter 12. What-If Analysis
Lesson 12.1
Defining a Scenario
Lesson 12.2
Creating a Scenario Summary Report
Lesson 12.3
Using a One and Two-Input Data Table
Lesson 12.4
Understanding Goal Seek
Lesson 12.5
Using Solver
Chapter Twelve Review
Chapter 13. Advanced Topics
Lesson 13.1
Hiding, Displaying, and Moving Toolbars
Lesson 13.2
Customizing Excel's Toolbars
Lesson 13.3
Sending Faxes
Lesson 13.4
Creating a Custom AutoFill List
Lesson 13.5
Changing Excel's Options
Lesson 13.6
Password Protecting a Workbook
Lesson 13.7
File Properties and Finding a File
Lesson 13.8
Sharing a Workbook and Tracking Changes
Lesson 13.9
Merging and Revising a Shared Workbook
Lesson 13.10
Using Detect and Repair
Chapter Thirteen Review
Index
