|
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
Tools, Options
Custom
Lists
Numeric Formats
Custom Numeric
Formats
Formatting Codes
Dates & Times
Special Characters
Codes That React To
Different Number Types
|
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.
Pivot Tables
Creating a Pivot
Table
Summarizing Data
Using Totals and
Subtotals
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
Importing Text Files
Importing Access
Tables
Exporting Data
|
