|
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
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
Pivot Tables
Creating a Pivot
Table
Summarizing Data
Using Totals and
Subtotals
Data Tables (version
2007 only)
Creating
Substitute
Consecutive Values in a Formula
|
Advanced Filter
Setting Up the
Ranges
Performing the
Filter
Setting Up the
Criteria Range
Using Database
Functions
Entering/Changing
Criteria
Scenarios
Creating and Saving
the Scenario
Displaying Scenarios
Other Scenario
Options - Edit, Merge, Summary, etc.
Group & Outline, &
Subtotals
Grouping
Rows/Columns on a Sheet
Showing/Hiding
Details in an Outline
Display/Hide Outline
Symbols
Adding Automatic
Subtotals
Adding Other
Automatic Analysis (Average, Mode, etc)
Removing Subtotals
Importing
and Exporting (version 2003 only)
Importing Text Files
Importing Access
Tables
Exporting Data
Importing Data (version 2007 only)
From Another Spreadsheet
Paste Link
Insert Object
Get External Data (version
2007 only)
Importing from Access
Importing Text Files
Importing from Web
Working with Connections
Open External Files
|
