Beginning

Intermediate

 Advanced

Mar. 31

Module 1: Excel Basics. Navigate a Workbook, Explore the Excel Menus, Select Multiple Cells, Create a Spreadsheet, Save a Workbook, Use the Toolbars, Edit the Spreadsheet, Get Help

Module 2: Formulas and Formats. Write Math Statements, Use the Function Wizard, Use AutoSum, Use the Fill Commands, Create Absolute References, Format Numbers, Use AutoFormat, Use the Drawing Toolbar

Module 3: Preview and Print. Check Spelling, Orient a Printout, Alter Print Margins, Center a Printout, Create Headers and Footers, Scale the Print Area, Print the Document

Module 4: Charts. Use ChartWizard, Insert a Chart Sheet, Change Chart Types, Modify a Chart, Rotate a Chart

Module 5: Database Basics. Create a Database, Format a Database, Use the Data Form, Sort a Database, Perform Multiple Sorts, Find Records

Module 6: Database Management. Use AutoFilter, Extract Records, Delete Records, Use Database Functions, Count Specific Records, Create a Pivot Table

Module 7: Link and Protect Workbooks. Formula-Link Worksheets, Command-Link Worksheets, Name a Cell Range, Consolidate Worksheets, Assign Passwords, Protect Cells and Ob jects, Outline a Worksheet, Create Report Views

Module 8: Macros. Record a Macro, Debug a Macro, Edit a macro, Create a Macro Button

Module 9: Using IF Logic. Employ Trend Analysis, Use Goal Seek, Use the Scenario Manager, Create Custom Cell Formats, Use the IF Function, Nest IF Functions, Combine Logical Functions

Module 10: Advanced Data Management. Use HLOOKUP, Use VLOOKUP, Create a One-Input Table, Create a Two-Input Table

Module 11: User-Define Functions. Create a Function Procedure, Use an Application Object, Control Procedure Flow, Write a Subroutine

Module 12: Custom Excel. Add Menu Options, Create a Custom Toolbar, Add Custom Tools