Excel Level 1

Excel Level 2

Excel Level 3

• Intro to Basics
• Simple Calculations
• Move Data
• Format Data
• Print Workbooks

Excel 2010 Level 1 covers the basic skills, including: creating a basic spreadsheet, performing calculations, and modifying, formatting and printing an Excel spreadsheet.

• VLOOKUP
• Sort & Filter
• Charts
• PivotTables
• Advanced Calculations

Excel 2010 Level 2 concentrates on some more advanced skills, including: using advanced formulas, organizing worksheet and table, creating and modifying charts, analyzing data using PivotTables, Slicers, and PivotCharts, inserting and modifying graphic objects in a worksheet and customizing and enhancing Microsoft Excel workbooks.

• Intro Macros
• Protection & Sharing
• Audit Calculations
• Link Workbooks
• Import & Export Data

Excel 2010 Level 3 focuses on the more advanced concepts, including: streamlining the workflow, collaborating with other workbook users, auditing worksheets, analyzing data, working with multiple workbooks, importing and exporting data, integrating Excel data with the web and structuring workbooks with XML.