|
Module One: Getting Started |
 |
Icebreaker |
 |
Housekeeping items |
 |
PreAssignment
Review |
 |
Workshop objectives |
 |
Action plans and evaluation forms |
| |
|
|
|
Module Two: Opening and Closing
Excel |
 |
Opening Excel |
 |
Understanding the Interface |
 |
Working with the Backstage View |
 |
Understanding Worksheets |
 |
Understanding Workbooks |
 |
Closing Excel |
| |
|
|
|
Module Three: Your First Worksheet |
 |
Entering Data |
 |
Using the Wrap Command |
 |
Editing Data |
 |
Adding Rows and Columns |
 |
Checking Your Spelling |
| |
|
|
|
Module Four: Working with Excel
Files |
 |
Saving Files |
 |
Publishing Files to PDF |
 |
Sending Files via EMail |
 |
Opening Files |
| |
|
|
|
Module Five: Viewing Excel Data |
 |
An Overview of Excel’s Views |
 |
Switching Views |
 |
Creating Custom Views |
 |
Using Zoom |
 |
Switching Between Open Files |
| |
|
|
|
Module Six: Printing Excel Data |
 |
An Overview of the Page Layout Tab |
 |
Setting up Your Page |
 |
Using Print Preview |
 |
Printing Data |
| |
|
|
|
Module Seven: Building Formulas |
 |
The Math Basics of Excel |
 |
Building a Formula |
 |
Editing a Formula |
 |
Copying a Formula |
 |
Relative vs. Absolute References |
| |
|
|
|
Module Eight: Using Excel
Functions |
 |
Formulas vs. Functions |
 |
Understanding the New Function
Names |
 |
Understanding the Formulas Tab |
 |
Using the SUM Function |
 |
Using Other Basic Excel Functions |
 |
Using the Status Bar to Perform
Calculations |
| |
|
|
|
Module Nine: Using Time Saving
Tools |
 |
Using AutoFill |
 |
Using AutoComplete |
 |
Sorting Data |
 |
Filtering Data |
 |
Adding Sparklines |
| |
|
|
|
Module Ten: Formatting Your Data |
 |
Changing the Appearance of Text |
 |
Changing the Appearance of
Numbers |
 |
Setting Alignment Options |
 |
Using Merge |
 |
Removing Formatting |
| |
|
|
|
Module Eleven: Advanced Formatting
Tools |
 |
Adding Borders |
 |
Adding Shading |
 |
Using Cell Styles |
 |
Using Conditional Formatting |
 |
Changing the Theme |
| |
|
|
|
Module Twelve: Wrapping Up |
 |
Words from the Wise |
 |
Review of Parking Lot |
 |
Lessons Learned |
 |
Completion of Action Plans and
Evaluations |