Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Excel Modeling Tips and Tricks

via LinkedIn Learning

Go to class Write review
OpenLearning Ad

50% OFF: In-Depth AI & Machine Learning Course

Learn More → Scrimba Ad

Our career paths help you become job ready faster

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Learn to build effective and versatile financial models to forecast sales, profits, operations, costs, assets and liabilities, and more in Microsoft Excel.

Syllabus

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

Taught by

Michael McDonald

Reviews

4.7 rating at LinkedIn Learning based on 1042 ratings

Start your review of Excel Modeling Tips and Tricks

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.