Excel Modeler Certification

This certification is designed to bolster your Excel skills and empower you to effectively and efficiently build highly functional, resilient Excel spreadsheets. In this 34-hour series, Excel expert David H. Ringstrom, CPA draws upon 30 years of spreadsheet experience to teach and explore features, functions, and techniques that will seriously level up your Excel skills, making you more effective at virtually any Excel-based task and job.

The program starts with four hours of worksheet functions, with a focus on lessening the risk of erroneous calculations as well as troubleshooting formulas. Four hours of data analysis work will assist you in gracefully sifting through large data sets, as well as effectively using pivot tables to generate self-updating reports and avoiding monstrous manipulation of data. Two hours of auditing work helps you pick apart even the most tangled spreadsheets.

The crux of the program is sixteen hours of modeling work that leads off with creating error-proof spreadsheets. You'll then explore linking workbooks not only to each other, but also to databases, Word documents, and text files. Many models entail what-if analysis, so you'll learn about Excel's Scenario Manager, Goal Seek, and Data Tables features, along with an introduction to Solver. This is followed by three separate case studies, techniques for maneuvering through large spreadsheets with ease, and user-proofing your Excel workbooks.

Any level of modeling entails some level of repetitive tasks, so the program includes six hours of automation training. The first two hours cover the Table feature from top to bottom - you'll be amazed at how many aspects of Excel can be automated by this simple feature. The next two hours introduce the concept of Excel's Macro Recorder. Then, you'll spend two hours making simple edits to recorded macros that allow for decision-making capability, error handling, and interactivity. The program closes out with two hours of data visualization work by showing you best practices for building charts that are maintenance-free; which otherwise can be yet another source of repetitive and/or error-prone work.

In summary, the courses break-down as follows:

• 4 hours of exploring worksheet functions
• 4 hours of data analysis, including filtering, pivot tables, and pivot charts
• 2 hours of auditing formulas specifically and spreadsheets in general
• 16 hours of modeling work, including minimizing errors, linking to data sources, utilizing what-if features, handling large spreadsheets, and three separate case studies
• hours of spreadsheet automation starting with Excel's Table feature, and then moving onto the Macro Recorder and finishing with editing Visual Basic for Applications programming code
• hours of data visualization and charts

David's signature teaching style is highly lauded by Illumeo members. He has thousands of course-takers and some of the highest ratings among the 200+ instructors on the platform. David's effective "show-twice" process first walks you through a procedure by way of detailed PowerPoint slides and then demonstrates the techniques firsthand in the Office 365 version of Excel. Throughout, he makes you aware of features that are either not backward compatible or unavailable in older versions of Excel. You'll come away from this program with not only a new credential, but also a vastly expanded spreadsheet toolset, greater efficiency, fewer errors and better-looking output.