Excel
Certification
Master Excel with our certification program. Learn shortcuts, formulas, and functions to enhance your efficiency and data presentation skills.
Purchase Certification:
Certificate Highlights
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.
Frequently Asked Questions
FAQs
Why should I be Illumeo Certified?
In short, you would do this to get better at what you already do, or to get a significant knowledge jump on something you want to do for a living. And, via the certificate itself, to be able to show others that you have attained this knowledge.
Why should I hire a Professional with an Illumeo Certification?
You would hire this Professional because they bring deep knowledge, on concrete topics, to your team. Simply completing the Illumeo certification denotes that the person is a serious professional willing to take the time to become very good at what they do, and that they put in the time, passed the tests, and are knowledgeable in their area of certification.
What happens if I fail the exam?
There is an exam for every course and you must pass every one in order to receive your certification. You may re-study the content and re-take any exam until you pass it.
Why would I want a subscription on Illumeo?
A subscription to Illumeo helps fill out your professional knowledge with its unfettered access to hundreds of up-to-date on demand courses taught by long-time practitioners - just like the instructor of this certification program.
Instructor
Jeff Lenning
Author of Excel University
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.
9 Courses
