Reviewing the Basics

Using Names
Naming Cells
Creating Cell Names
Using Cell Names in Formulas
Naming Formulas
Checking and Listing Names and References
Checking the References of Names
Listing Defined Names
Creating -Dimensional Names
Working with Ranges
Creating and Naming Ranges
Formatting and Clearing Ranges
Copying and Moving Ranges

Working with Advanced Functions
Using the NOW FunctionUsing the DATE Function
Using the VLOOKUP Function
Using the IF Function
Using the PMT Function
Using the FV Function

Working with Advanced Formatting Features
Using Advanced Number Formats
Using the Time Format
Using the Fraction Format
Using the Scientific Format
Creating Custom Number Formats
Applying Outlines
Creating Outlines
Collapsing and Expanding Outlines
Removing Outlines

Locating and Updating Data
Finding and Replacing Data
Finding and Replacing Text
Finding and Replacing Numeric Data
Controlling Recalculation

Using Special Format and Print Options
Formatting Zero Values
Displaying Zero Values as Blank Cells
Displaying Zero Values as Text
Changing the Display of Negative Values
Using Print Options
Printing Titles and Gridlines
Setting Print Areas
Printing Multiple Worksheets
Previewing and Printing Workbooks

Protecting Worksheet Data
Using Comments
Creating Comments
Displaying and Hiding Comments
Editing and Deleting Comments
Using Worksheet and Range Protection
Enabling Worksheet Protection
Unprotecting Cells
Hiding and Displaying Data
Using Password Protection
Assigning Passwords
Removing Passwords

Manipulating the Screen Display
Working with Multiple Workbooks
Displaying Multiple Workbooks
Navigating Between Open Workbooks
Freezing Worksheet Panes
Freezing Rows
Clearing Frozen Panes
Freezing Columns
Freezing Rows and Columns Simultaneously
Adjusting the Zoom Setting
Working with Toolbars
Displaying and Hiding Toolbars
Moving Toolbars
Customizing Toolbars

Sharing Worksheet Data
Importing Text Files
Opening a Text File in Excel
Importing a Text File into a Refreshable Range
Exporting Data to Other Applications
Linking Workbooks
Creating Links
Updating Links

Automating Your Work
Working with Existing Templates
Customizing Templates
Creating Workbooks Based on Templates
Creating Templates
Working with Macros
Recording Macros
Executing Macros
Editing Macros
Creating Custom Lists