Excel Modeling Tips and Tricks (2021)

Course details

Excel is the most widely used data analysis software on the market, but many people in business are not using it to its full potential. Excel can be a great tool for building financial and operational models, allowing users to understand what may happen in the future and how the business can position itself. In this course, learn how to build effective and useful financial models in Excel to forecast sales and costs, profits, operational KPIs, business assets and liabilities, and much more. Instructor Michael McDonald covers rules and best practices for financial modeling and then shows how to set up single-sheet and multi-sheet financial models and add inputs and assumptions, external data, projections, and more. Plus, learn how to determine the accuracy and strength of your models and keep them up to date as the data evolves. By the end of this course, you will have the tools and tricks you need to become a master of Excel modeling for businesses ranging from restaurants and manufacturing firms to banks and software companies.

Concepts

0. Introduction

01 - Getting started with Excel modeling

1. Financial Modeling - Reviewing the Basics

02 - Objectives in financial modeling
03 - Rules and best practices
04 - Assessing a financial model

2. Single-Sheet Financial Models

05 - Doing a basic loan amortization model
06 - Thinking through the model structure
07 - The three parts of Excel models
08 - Adding toggles and inputs to a model
09 - Using if then analysis in models
10 - Making assumptions in financial models
11 - Steps in building the single-sheet model

3. Multi-Sheet Financial Models

12 - Setting up a multi-sheet financial model
13 - Linking sheets in financial models
14 - Steps in building the multi-sheet model
15 - Notating and comments in models
16 - Historical data in financial models
17 - External data in financial models
18 - Projections in financial models

4. Assessing Model Accuracy

19 - Determining model accuracy
20 - Stress testing models
21 - Using financial models
22 - Linking Excel results to PowerPoint
23 - Maintaining your models

Conclusion

24 - Continuing to build Excel models

Excel Modeling Tips and Tricks (2021)

Authors

Michael McDonald