YoVDO

Excel Modeling Tips and Tricks

Offered By: LinkedIn Learning

Tags

Microsoft Excel Courses Financial Modeling Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
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

Related Courses

Financial Sustainability: The Numbers side of Social Enterprise
+Acumen via NovoEd
M&A: Free Cash Flow (FCF) Modeling
New York Institute of Finance via edX
Financial Modeling for the Social Sector
Philanthropy University via Acumen Academy
Introducción a las Finanzas Corporativas
University of Pennsylvania via Coursera
沃顿商务基础毕业项目 (中文版)
University of Pennsylvania via Coursera