Prerequisite: Windows Introduction or equivalent knowledge, and previous level class or equivalent knowledge for intermediate and advance levels
Introduction: Learn the basic functions and features of Excel: spreadsheet terminology, the Excel environment, and the Help system. Create, edit, format, and print basic Excel worksheets.
Excel Introduction »
Intermediate: Learn how to use multiple worksheets and workbooks efficiently, and work with more advanced formatting options including styles, themes, backgrounds, outlines and subtotals, create and apply cell names, work with tables, save workbooks as Web pages, insert and edit hyperlinks, and learn to share workbooks by email. Also covered are advanced charting techniques, worksheet auditing and protection, file sharing and merging, workbook templates, and PivotTables and PivotCharts.
Excel Intermediate »
Advanced: Learn advanced formulas, lookup functions, data validation and database functions, importing and exporting data, and how to query external databases. Explore the analytical features of Excel, running and recording macros, SmartArt graphics, and conditional formatting with graphics.
Excel Advanced »