• Launching Excel 97
• Exploring the Excel Worksheet
• Examining the parts of the Excel screen
• Examining the worksheet window
• The status bar
• Using the office assistant to get help
• Exploring Excel's help feature
• Exploring the toolbars
• Using the "What's This" feature to get help
• Moving around in the worksheet
• Moving to a specific cell in the worksheet
• Exiting the Excel program
• Additional Exercises: Exploring other ways to get help

Creating a Worksheet

• Creating a worksheet
• Entering row headings
• Adding figures to the worksheet
• Interactive exercises #1: Adding remaining income figures to the worksheet
• Saving and naming the workbook
• Creating functions
• Excel 97's formula AutoCorrect feature
• Deleting cell contents
• Reversing actions
• Entering the same data in multiple cells
• Creating a formula
• Saving the workbook and exiting Excel 97
• Additional Exercises: Using the Formula Palette

• Starting Excel and opening a file
• Resizing columns in a worksheet
• Adjusting column width automatically
• Resizing multiple columns
• Inserting rows into a worksheet
• Repeating an action
• Deleting a row
• Editing formulas
• Using AutoCalculate
• Copying formulas
• Using relative cell references
• Creating and copying a function
• Using the fill handle to copy cell contents
• Using drag and drop to move cell contents
• Creating division formulae
• Understanding absolute cell references
• Saving changes and exiting Excel 97
• Additional Exercises: Using AutoFill

Formatting and Printing

• Retrieving a workbook
• Formatting numbers
• Applying a currency format
• Using the format painter
• Formatting numbers as a percentage
• Aligning cell entries
• Adding borders to a range
• Indenting cell contents
• Changing fonts and font sizes
• Selecting and formatting non-adjacent cells
• Saving the worksheet
• Exploring print preview
• Exploring the print preview toolbar
• Zooming in and out in print preview
• Printing a worksheet
• Exiting Excel 97
• Additional Exercises: Using conditional formats and rotating text

• Launching Excel and retrieving a workbook
• Creating a chart using the Chart Wizard
• Exploring the Chart toolbar
• Editing a chart
• Repositioning a chart
• Changing worksheet data
• Moving a chart to another worksheet
• Resizing a chart
• Editing worksheet tabs
• Modifying a chart's layout
• Changing a chart's perspective
• Displaying a data table
• Formatting a chart
• Previewing and printing charts
• Saving changes and exiting Excel
• Additional Exercises: Using Excel to create a web page

Using Draw

• Launching Excel and retrieving a workbook
• Exploring the drawing toolbar
• Adding a drawing object
• Removing fill color
• Modifying an object's line style and color
• Adding another drawing object
• Adjusting an object's shape
• Resizing an object
• Moving an object
• Making an object 3-D
• Modifying an object's 3-D settings
• Changing an object's fill color
• Rotating an object
• Repositioning an object
• Creating and modifying an arrow
• Adding a text box
• Adding a drop shadow to an object
• Hiding the drawing toolbar
• Saving changes and exiting the program
• Additional Exercises: Grouping, moving, and modifying objects

• Launching Excel and retrieving a workbook
• Splitting the window into panes
• Scrolling through panes
• Splitting the worksheet window into four panes
• Resizing panes
• Removing the splits
• Freezing rows and columns
• Zooming
• Viewing more than one worksheet
• Copying data between worksheets
• Opening multiple workbooks
• Copying data between workbooks
• Saving a workspace
• Exiting Excel 97
• Additional Exercises: Creating and using a template

Linking and Organizing Workbooks

• Launching Excel and retrieving a workbook
• Creating a formula containing links to different worksheets
• Examining the formula
• Creating a formula with 3-D reference
• Interactive exercise #1: Entering the missing sales
• Testing the 3-D reference
• Linking multiple workbooks
• Inserting a column
• Repeating an action
• Using AutoFill
• Linking data between workbooks
• Copying a worksheet to another workbook
• Deleting a worksheet
• Creating headers and footers
• Printing a specified range
• Changing page orientation
• Printing from print preview
• Saving the changes and exiting the program
• Additional Exercises: Working with named ranges

• Launching Excel and retrieving a file
• What is a database?
• Applying a fraction format
• Sorting data
• Creating a multi-level sort
• Viewing other records in a database
• Querying a database using a data form
• Using filters
• Extracting data by copying it to a separate worksheet
• Changing column size
• Removing a filter from a database
• Summarizing information in a database
• Using an outlined worksheet
• Saving changes and exiting the program
• Additional Exercises: Creating an advanced filter

Advanced Data Analysis

• Retrieving a workbook
• Understanding data tables
• Creating a data table
• Using AutoFill
• Setting up the data table
• Filling in the table
• Applying a currency format
• Examining the data table results
• Exploring Pivot Tables
• Creating a Pivot Table using the Pivot Table Wizard
• Using a Pivot Table
• Editing the layout of a Pivot Table
• Deleting and adding fields to a Pivot Table
• Changing the order of fields of a Pivot Table
• Saving changes and exiting Excel 97
• Additional Exercises: Advanced worksheet formatting

• Launching Excel
• What is Microsoft Map?
• Creating a Microsoft Map
• Selecting the data for the map
• Compacting and moving a legend
• Examining the map
• Customizing a Microsoft Map
• Formatting data on a map
• Interactive exercise #1: Adding categories
• Resizing a map
• Examining the category legends
• Moving map elements
• Magnifying a map
• Panning across a map
• Displaying the whole map
• Adding a label to a map
• Formatting label text
• Updating a map
• Interactive exercise #2: Editing a map title
• Saving changes and exiting the program
• Additional Exercises: Creating a custom Pin map

Exploring Macros

• What is a macro?
• Creating a macro
• Recording a macro
• Testing the macro
• Examining how Excel writes a macro
• Modifying a macro
• Testing the modified macro
• Recording a macro that will format text
• Interactive exercise #3: Recording a formatting macro
• Testing the formatting macro
• Examining the structure of the formatting macro
• Combining two macros
• Testing the combined macros
• Saving your work and exiting Excel 97
• Additional Exercises: Assigning a macro to a toolbar