Templates

Creating a Template

Using In a New File

Templates and Inserting Sheets

Auto templates

For default Books or Sheets

Forms

Form Templates

Designing the Form

Tools-Combo Boxes, List Boxes, etc.

Control Properties

Protecting the Form

Sharing Workbooks and Tracking Changes

Sharing workbooks on a network

Multiple users in the same file

Controlling which changes are saved   

Importing and Exporting (2003 only)

Importing Text Files

Importing Access Tables

Exporting Data

Importing Data (2007 only)

From Another Spreadsheet

Paste Link

Insert Object

Get External Data (2007 only)

Importing from Access

Importing Text Files

Importing from Web

Working with Connections

Open External Files

Customizing Excel

Changing Default Options

Custom Lists

Numeric Formats

Custom Numeric Formats

Formatting Codes

Dates & Times

Special Characters

Codes That React To Different Number Types

Scenarios

Creating and Saving the Scenario

Displaying Scenarios

Other Scenario Options-Edit, Merge, Summary, etc.

Data Tables (version 2007 only)

Creating

Substitute Consecutive Values in a Formula

A Brief Introduction to Macros

What is a Macro?

Recording a Macro

Playing a Macro

Relative Referencing

Rerecording a Macro