Excel Certification

A fast and high impact Microsoft Excel Certification for working professionals

Jeff Lenning is a CPA and Microsoft Certified Trainer, and loves sharing the things he has learned about excel over the years, especially the things that help us “number crunchers” save time and get our work done faster.

Excel Certification Highlights:

And that is exactly what we’ll cover in this Excel certification program. We’ll talk about the Excel features, functions, and techniques that help us work more efficiently.

This certification program has 9 modules, contains 14 hours of instruction including exams, consists of 70+ lecture videos and over 200 hands-on exercises so you can practice the skills presented.

Who Should Enroll in Excel Certification?

Professionals working in marketing, sales, accounting, finance or other domains who use Microsoft Excel and deal with numbers. This certification helps these professionals have better productivity and data presentation skills.

What Do You Learn from Excel Certification?

Excel Certification program begins by building a rock solid foundation that you can use to create bulletproof recurring-use workbooks. Then, we dig into formula-based reports, and use functions like VLOOKUP, INDEX, MATCH, SUMIF, EOMONTH and more.

In all, we cover over 25 worksheet functions. Then, we learn how to replace formula-based reports with PivotTables whenever possible. We wrap up by learning how to use the Get External Data command to retrieve data from external sources, and some basic data visualization features such as PivotCharts and Sparklines. Excel Certification covers following modules;

• Microsoft Excel Shortcuts
• Skills for Better Excel Workbook Design
• Mastering Fundamental Excel Functions: IF, IFERROR, List Comparisons and More
• Excel Training: Data Validation, Error Checking, Reporting
• Pivot Tabels and Pivot Charts
• Excel Formula Based Reports

Information on Certification Exams:

• Each module has a separate exam with multiple choice questions.
• Certification Passing creiteria is 70%.

Additional Certification Resources:

• Downloadable Excel files with practice tasks.
• PDF slides for revision and review.

Message from the Instructor:

This Certification program is designed for working professionals who want to get more done from Excel and learn shortcuts, formulas and functions and step towards mastering Microsoft Excel.

Listen, Excel is my favorite application of all time and I love helping people use it more effectively. So, if you think that Excel can do more, or you know there’s gotta be a faster way of doing things but don’t have time to figure it out, I’d like to invite you to take this Excel certification program. Excel has been my secret weapon for years, and I hope it can be yours as well!

A former "Big 6" auditor, accounting and finance executive at global companies and published Excel expert, Jeff Lenning CPA CITP has shown thousands of CPAs and accounting professionals across the country how to use Excel to streamline their work and become more efficient.