Books & Videos

Table of Contents

  1. Chapter 1 The Fundamentals

    1. Starting Excel

    2. What's New in Excel 2003?

    3. Understanding the Excel Program Screen

    4. Using Menus

    5. Using Toolbars and Creating a New Workbook

    6. Filling Out Dialog Boxes

    7. Keystroke and Right Mouse Button Shortcuts

    8. Opening a Workbook

    9. Saving a Workbook

    10. Moving the Cell Pointer

    11. Navigating a Worksheet

    12. Entering Labels in a Worksheet

    13. Entering Values in a Worksheet and Selecting a Cell Range

    14. Calculating Value Totals with AutoSum

    15. Entering Formulas

    16. Using AutoFill

    17. Previewing and Printing a Worksheet

    18. Getting Help

    19. Changing the Office Assistant and Using the "What's This" Button

    20. Closing a Workbook and Exiting Excel

    21. Chapter One Review

  2. Chapter 2 Editing a Worksheet

    1. Entering Date Values and Using AutoComplete

    2. Editing, Clearing, and Replacing Cell Contents

    3. Cutting, Copying, and Pasting Cells

    4. Moving and Copying Cells with Drag and Drop

    5. Collecting and Pasting Multiple Items

    6. Working with Absolute and Relative Cell References

    7. Using the Paste Special Command

    8. Inserting and Deleting Cells, Rows, and Columns

    9. Using Undo, Redo, and Repeat

    10. Checking Your Spelling

    11. Finding and Replacing Information

    12. Advanced Printing Options

    13. File Management

    14. Inserting Cell Comments

    15. Understanding Smart Tags

    16. Recovering Your Workbooks

    17. Chapter Two Review

  3. Chapter 3 Formatting a Worksheet

    1. Formatting Fonts with the Formatting Toolbar

    2. Formatting Values

    3. Adjusting Row Height and Column Width

    4. Changing Cell Alignment

    5. Adding Borders

    6. Applying Colors and Patterns

    7. Using the Format Painter

    8. Using AutoFormat

    9. Creating a Custom Number Format

    10. Creating, Applying, and Modifying a Style

    11. Formatting Cells with Conditional Formatting

    12. Merging Cells, Rotating Text, and Using AutoFit

    13. Finding and Replacing Formatting

    14. Chapter Three Review

  4. Chapter 4 Creating and Working with Charts

    1. Creating a Chart

    2. Moving and Resizing a Chart

    3. Formatting and Editing Objects in a Chart

    4. Changing a Chart's Source Data

    5. Changing a Chart Type and Working with Pie Charts

    6. Adding Titles, Gridlines, and a Data Table

    7. Formatting a Data Series and Chart Axis

    8. Annotating a Chart

    9. Working with 3-D Charts

    10. Selecting and Saving a Custom Chart

    11. Using Fill Effects

    12. Chapter Four Review

  5. Chapter 5 Managing Your Workbooks

    1. Switching Between Sheets in a Workbook

    2. Inserting and Deleting Worksheets

    3. Renaming and Moving Worksheets

    4. Working with Several Workbooks and Windows

    5. Splitting and Freezing a Window

    6. Referencing External Data

    7. Creating Headers, Footers, and Page Numbers

    8. Specifying a Print Area and Controlling Page Breaks

    9. Adjusting Page Margins and Orientation

    10. Adding Print Titles and Gridlines

    11. Changing the Paper Size and Print Scale

    12. Protecting a Worksheet

    13. Hiding Columns, Rows, and Sheets

    14. Viewing a Worksheet and Comparing Workbooks Side by Side

    15. Saving a Custom View

    16. Working with Templates

    17. Consolidating Worksheets

    18. Chapter Five Review

  6. Chapter 6 More Functions and Formulas

    1. Formulas with Several Operators and Cell Ranges

    2. Using the Insert Function Feature

    3. Creating and Using Range Names

    4. Selecting Nonadjacent Ranges and Using AutoCalculate

    5. Using the IF Function to Create Conditional Formulas

    6. Using the PMT Function

    7. Displaying and Printing Formulas

    8. Fixing Formula Errors

    9. Mathematical Functions

    10. Financial Functions

    11. Date and Time Functions

    12. Statistical Functions

    13. Database Functions

    14. Chapter Six Review

  7. Chapter 7 Working with Lists

    1. Creating a List

    2. Working with Lists and Using the Total Row

    3. Adding Records Using the Data Form Dialog Box and Insert Row

    4. Finding Records

    5. Deleting Records

    6. Sorting a List

    7. Filtering a List with the AutoFilter

    8. Creating a Custom AutoFilter

    9. Filtering a List with an Advanced Filter

    10. Copying Filtered Records

    11. Using Data Validation

    12. Chapter Seven Review

  8. Chapter 8 Automating Tasks with Macros

    1. Recording a Macro

    2. Playing a Macro and Assigning a Macro a Shortcut Key

    3. Adding a Macro to a Toolbar

    4. Editing a Macro's Visual Basic Code

    5. Inserting Code in an Existing Macro

    6. Declaring Variables and Adding Remarks to VBA Code

    7. Prompting for User Input

    8. Using the If...Then...Else Statement

    9. Chapter Eight Review

  9. Chapter 9 Working with Other Programs

    1. Inserting an Excel Worksheet into a Word Document

    2. Modifying an Inserted Excel Worksheet

    3. Inserting a Linked Excel Chart in a Word Document

    4. Inserting a Graphic into a Worksheet

    5. Opening and Saving Files in Different Formats

    6. Chapter Nine Review

  10. Chapter 10 Using Excel with the Internet

    1. Adding and Working with Hyperlinks

    2. Browsing Hyperlinks and Using the Web Toolbar

    3. Saving a Workbook as a Non-Interactive Web Page

    4. Saving a Workbook as an Interactive Web Page

    5. Import an External Data Source

    6. Refresh a Data Source and Set Data Source Properties

    7. Create a New Web Query

    8. Chapter Ten Review

  11. Chapter 11 Data Analysis and PivotTables

    1. Creating a PivotTable

    2. Specifying the Data a PivotTable Analyzes

    3. Changing a PivotTable's Calculation

    4. Selecting What Appears in a PivotTable

    5. Grouping Dates in a PivotTable

    6. Updating a PivotTable

    7. Formatting and Charting a PivotTable

    8. Creating Subtotals

    9. Using Database Functions

    10. Using Lookup Functions

    11. Grouping and Outlining a Worksheet

    12. Chapter Eleven Review

  12. Chapter 12 What-If Analysis

    1. Defining a Scenario

    2. Creating a Scenario Summary Report

    3. Using a One and Two-Input Data Table

    4. Understanding Goal Seek

    5. Using Solver

    6. Chapter Twelve Review

  13. Chapter 13 Advanced Topics

    1. Hiding, Displaying, and Moving Toolbars

    2. Customizing Excel's Toolbars

    3. Sending Faxes

    4. Creating a Custom AutoFill List

    5. Changing Excel's Options

    6. Password Protecting a Workbook

    7. File Properties and Finding a File

    8. Sharing a Workbook and Tracking Changes

    9. Merging and Revising a Shared Workbook

    10. Using Detect and Repair

    11. Chapter Thirteen Review

  1. Colophon