Excel Modeling Tips and Tricks
Offered By: LinkedIn Learning
Course Description
Overview
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
- Objectives in financial modeling
- Rules and best practices
- Assessing a financial model
- 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
- 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
- Determining model accuracy
- Stress testing models
- Using financial models
- Linking Excel results to PowerPoint
- Maintaining your models
- 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