|
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 =AVERAGE
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 with the Data Form
Editing and Deleting Records
Using the AutoFilter 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 |
|
Timesaving Techniques | Formatting and Formula Shortcuts
Setting Defaults for Workbooks and Charts, Adding Files to XLSTART
Using Group Selection to Make Editing Workbooks a Snap |
|
Managing Large Files | Outlining a Worksheet to Present It Differently to Different People
Using the View Manager to Save Views Created by Outlining
Creating Custom Print Reports with the Report Manager
Consolidating Data to Create a Linked Summary |
|
Logical and Database Functions | PMT Function
Nesting IF Functions
ISERR Function
INDEX Function
MATCH Function
DCOUNT Function |
|
Excel’s Data Analysis Features | Data Tables
Using Goal Seek to Find Answers
Creating "What If" Situations with Scenario Manager
Using Solver to Give an Answer Based on Many Criteria
Creating Pivot Tables to Summarize Data
Modifying Pivot Tables - Changing the Layout, Showing Detail, etc.
Creating a Pivot Chart |
|
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 |
|
Sharing Information | Sharing Files and Tracking Changes
Creating Hyperlinks to Other Files
Web Page Preview and Saving As a Web Page |
|
Timesaving Techniques | Formatting and Formula Shortcuts
Setting Defaults
Using GroupMode |
|
Managing Large Files | Consolidating Data
Linking
Converting files |
