Excel Modeling Tips and Tricks

Learn to build effective and versatile financial models to forecast sales, profits, operations, costs, assets and liabilities, and more in Microsoft Excel.

Introduction

• Getting started with Excel modeling

1. Financial Modeling: Reviewing the Basics

• Objectives in financial modeling
• Rules and best practices
• Assessing a financial model

2. Single-Sheet Financial Models

• Doing a basic loan amortization model
• Thinking through the model structure
• The three parts of Excel models
• Adding toggles and inputs to a model
• Using if/then analysis in models
• Making assumptions in financial models
• Steps in building the single-sheet model

3. Multi-Sheet Financial Models

• Setting up a multi-sheet financial model
• Linking sheets in financial models
• Steps in building the multi-sheet model
• Notating and comments in models
• Historical data in financial models
• External data in financial models
• Projections in financial models

4. Assessing Model Accuracy

• Determining model accuracy
• Stress testing models
• Using financial models
• Linking Excel results to PowerPoint
• Maintaining your models

Conclusion

• Continuing to build Excel models