Saving your Files
File Formats
File Properties
AutoRecover
Upgrading a Workbook

Using Templates
Opening a Template
Downloading a Template
Using a Template
Creating a Template

Working with Functions and Formulas
Using Formulas in Excel
Understanding Relative and Absolute Cell References
Basic Mathematical Operators
Using Formulas with Multiple Cell References
The Formula Auditing Buttons
Fixing Formula Errors
Displaying and Printing Formulas

Exploring Excel Functions
What are Functions?
Finding the Right Function
Some Useful and Simple Functions

Using Functions in Excel
Inserting Functions
Using Functions and AutoFill to Perform Difficult Calculations
Using the IF Function
Working with Nested Functions

Working with Names and Ranges
What Are Range Names?
Defining and Using Range Names
Selecting Nonadjacent Ranges
Using AutoCalculate

Working with Array Formulas
What are Array Formulas?
Using Basic Array Formulas
Using Functions with Array Formulas
Using the IF function in Array Formulas

Managing Tables
Working with Tables
What is a Table?
Creating Tables
Modifying Tables
What is the Total Row?

Working with Records and Fields
What are Records and Fields?
Adding Fields by Inserting Columns
Adding Records by Inserting Rows
Quickly Adding Records to a Data Table
Deleting Records or Fields

Working with Tables and Filters
Sorting Data in a Table
What is an AutoFilter?
Custom AutoFilters
Using an Advanced Filter
Copying Filtered Records

Using Excel as a Database
Filtering with Wildcard Characters
Validating Your Data
What are Database Functions?

Working with Text Boxes
Adding a Text Box
Selecting a Text Box
Manipulating a Text Box
Formatting a Text Box

WordArt
Adding WordArt to your Spreadsheet
Changing the Font Color
Changing the Outline Color
Adding Effects

ClipArt
Finding ClipArt
Inserting ClipArt
Manipulating ClipArt
Inserting a Photographic Image

Using Objects
Creating New Embedded Objects
Embedding Existing Files
Editing Embedded Objects
Embedding Parts of Files

Finalizing Your Workbook
Protecting your Workbook
Protecting your Workbook
Protecting your Worksheets
Unlocking Cells
Protecting your Excel Files

Finishing Your Workbook
Using the Document Inspector
Using the Compatibility Checker
Marking a Workbook as Final

Using Excel in Word
Inserting Excel Data in Word
Linking Excel Data in a Word Document
Modifying Excel Data after Insertion
Insert an Excel Chart into a Word Document

Using Excel and Access
Linking an Excel Workbook to an Access Database
Importing Table, PivotTable, and PivotChart Data from Access
Transforming an Excel Workbook into an Access Database

Using Excel With other Programs and Files
Using Outlook to Send Excel Data
Opening an Excel File in a Different Format
Importing Data from a Text File
Importing Data from External Data Sources
Publishing a Workbook as a PDF File
Faxing a Workbook