• Touring the Excel workspace
• Understanding pointer shapes
• Using Undo and Redo
• Using Excel's menus and toolbars
• Activating another cell
• Making selections within a worksheet
• Using navigation keys
• Working with sheet tabs
• Using AutoSum to add rows and columns

Customizing Toolbars and Menus

• Displaying more buttons
• Hiding or displaying toolbars
• Customizing a toolbar
• Moving, floating, and docking toolbars

Working with Dates

• Interpreting two-digit years
• Date functions
• Date formatting

Outlining

• Creating outline levels manually
• Creating outline levels automatically

Naming Cells

• Using the Name box to create a range name
• Naming cells by using existing row and column labels

Worksheet Functions

• Using the Formula Palette
• Nesting functions
• Simple vs. complex functions
• Using the PMT() function
• Using the IF() logical function
• Using the VLOOKUP() function

Linking

• Linking two cells within a worksheet
• Linking cells between two worksheets
• Linking cells between two workbooks

Working with Excel Lists

• Creating a list
• Using the Data Form
• Sorting a list
• Filtering a list using AutoFilter
• Counting and summing filtered data
• Advanced filtering
• Using Database functions with lists
• Creating automatic subtotals in a list

Protecting your workbook

• Requiring a password to open a workbook
• Specifying which cells can be changed