Excel Business Modeling – The In-Depth Street Smart Toolkit.

A comprehensive guide to build sophisticated models, robust databases, and write powerful formulas with Excel 2007-2019.

Created by: Leon Lamprecht
Chartered Accountant and Strategic Financial Modeler

What Will I Learn?

• * Build quick and easy, street smart financial dashboards, formulas and models with multiple scenarios from scratch.
• * Learn to approach and apply Excel formulas in a logical and easy to use way, ensuring you stand out above the rest.
• * Mastering distinctive tips and tools to truly take your reporting and analysis to the next level and beyond.
• * How to practically apply the course material in a business environment, as well as in personal circumstances.
• * Approach challenges from different and more efficient angles getting to the same results within half the time.
• * Build robust data bases, formulas and business models innovatively and efficiently.
• * Gain lifetime access and knowledge to course material and engage in exercise files.
• * An easy to understand walk through video of each and every facility within your Excel arsenal.
• * Master unique business modeling tips and tools that you won't find anywhere else!
• * Practice and understand dynamic formulas like SUMIFS, CHOOSE, VLOOKUP, INDEX, MATCH, Excel's D-Functions and many many more.
• * Mastering Macros, Pivot Tables, Hyperlinks, Goal Seek, Solver and Data Validation Lists.
• * Access a comprehensive list of 100+ Excel shortcut keys illustrating the before and after scenario.
• * Highly productive and engaging lessons from an experienced business modeler and Finance professional.

Requirements

• * This course was created using Excel 2016 and Excel 2019. All tutorials will work in Excel 2010 - 2019, and most will work in 2007.
• * A computer or laptop with Microsoft Excel 2007-2019 or Microsoft 365 (Some techniques might not be available on Mac, or apply to all versions of Excel).
• * Basic knowledge of Excel is not covered in the course, however we'll review some essential formulas and functions throughout the course.

Target audience

• * This course starts at Intermediate Excel level, only certain basic functions will be referred to, and builds up to a comprehensive understanding of complex functions, techniques and data models.
• * Anyone looking to start or enhance their career in data analytics and business and / or financial modeling, enhancing the everyday skills of Engineers, Entrepreneurs, Commercial Managers, Financial Controllers, Bookkeepers, Financial Planners, Data Analysts, Stock Analysts, Stock Brokers, Company Directors, College / University students, and many more!
• * Anyone looking to build strong modeling and business analytical credentials to stand out in a competitive environment.
• * Excel users looking to vastly expand their knowledge and approach to enhance their productivity to become highly efficient.