Beginning

Intermediate

 Advanced

Apr. 30

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

Module 2: Formulas and Formats. Create a Formula, Use Functions, Use the Formula Palette, Use AutoSum, Use the Fill Commands, Create Absolute References, Format Values, Use AutoFormat, Use Conditional Formatting

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 Chart Wizard, Insert a Chart Sheet, Explore Chart Types, Edit a Chart, Rotate a Chart, Create a Pie Chart, Create a Map, Draw Objects

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, Use a Name Range, Link Workbook Files, Consolidate Worksheets, Assign a Password, Protect Cells and Objects, Outline a Worksheet, Create Report Views

Module 8: Visual Basic. 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 Scenario Manager, Audit a Spreadsheet, Use Data Validation, 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, Create a Custom Menu, Create a Custom Toolbar, Add Custom Tools, Modify the Environment, Use Workgroup Features, Create an HTML Spreadsheet