Beginning

Intermediate

 Advanced

Apr. 6

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

Module 2: Formulas and Formats. Create a Formula, Use the Function Wizard, Use AutoSum, Use the Fill Commands, Create Absolute References, Format Values, Use AutoFormat

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

Module 4: Charts and Maps. Use ChartWizard, Insert a Chart Sheet, Explore Chart Types, Modify a Chart, Rotate a Chart, Create a Pie Chart, Create a Map

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

Module 6: Database Management. Use AutoFilter, Use Compound Criteria, Extract Unique Records, Use Database Functions, Create a Pivot Table, Import and Export Data

Module 7: Linking and Protecting. Formula-Link Worksheets, Command-Link Worksheets, Name a Cell Range, Link Workbook Files, Consolidate Worksheets, Assign a Password, Protect Cells and Objects, 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, Determine Frequency Distribution, Use the Scenario Manager, Audit a Spreadsheet, 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-Defined Functions. Create a Function Procedure, Use an Application Object, Control Procedure Flow, Write a Subroutine

Module 12: Customizing Excel. Create a CellTip, Add Menu Options, Create a Custom Toolbar, Add Custom Tools, Modify the Environment