Excel Level I, the first course in the Excel Application Specialist certification series, is designed for beginners or self-taught users looking to improve their skills. It covers the fundamentals and progressively introduces more advanced features to help participants maximize Excel’s potential.

The course covers key Excel skills, including setting up spreadsheets, entering and manipulating data, and using AutoFill to save time. Participants will learn how to print spreadsheets correctly, create basic formulas and functions, and edit and format data efficiently. By the end, they will be equipped to manage large workbooks and use Excel’s core features to improve productivity.

Excel Level II, the second course in the Excel Application Specialist certification series, is designed for users who are already familiar with Excel and want to deepen their skills. This one-day course covers advanced features, including creating and formatting charts, working with PivotTables, and using advanced formulas.

Participants will learn to summarize data with PivotTables, clean data using text functions, and automate tasks with logical functions like AND, IF, and OR. The course also covers lookup functions such as VLOOKUP and INDEX/MATCH, converting data into Excel tables, and adding objects like logos to workbooks. Additionally, participants will explore data protection techniques. By the end, participants will be equipped to handle more advanced tasks and increase productivity in Excel.

Excel Level III, the final course in the Excel Application Specialist certification series,  is designed for regular Excel users looking to enhance their skills with advanced data analysis and automation techniques.

In this course, participants will learn to use data validation, create macros, and apply tools like scenarios and goal seek for “what-if” analysis. The course also covers auditing worksheets, working with external data, and inserting hyperlinks. Participants will learn to manage multiple workbooks, create forms, and get an introduction to Visual Basic for automating tasks. By the end, participants will be proficient in advanced Excel techniques to enhance productivity and data management.