|
Getting Started | Control panel
SmartIcons
Worksheet window
Worksheet tabs
Status bar |
|
Commands | Main menus
Quick menus
Dialog box
Shortcut keys
Function keys |
|
Creating a Workbook | Entering Text and Numbers
Editing Text and Numbers
Creating Basic Formulas
Saving the Workbook |
|
Formulas and Functions | Using the Formula Palette to Make Building Formulas Easier
Using Functions such as @SUM and @AVG
Using Absolute Cell References to Make Your Formulas More Powerful |
|
Formatting | Formatting Text and Numbers
Changing Row and Column Widths
Copying and Pasting Cells
Reusing Your Worksheets with Copy and Paste |
|
Printing | Using Print Preview
Setting Options in Page Setup - Headers and Footers, Paper Orientation, Page Numbering, etc.
Printing Worksheets and the Workbook |
|
Databases | Adding Records
Editing and Deleting Records
Filtering to Select Certain Records
Building Your Own Database |
|
Charting (Graphing) | Creating Charts - the Dos and Don’ts
Editing Charts
Formatting a Chart
Changing the Chart Type
Printing Charts |
|
Logical and Database Functions | PMT Function
Nesting IF Functions
ISERR Function
INDEX Function
MATCH Function
DCOUNT Function |
|
Data Analysis Features | Data Tables
Getting the answer you want with back solving
Creating Tables to Summarize Data |
|
Importing Text Files | Importing Data
Using TEXT Functions
Parsing Data into More Than One Column |
|
Forms and Macros | Creating a Form
Recording Macros
Understanding Local and Global Macros |
