Excel Modeling Tips and Tricks

Focused View

Michael McDonald

1:56:50

0 View

01 - Getting started with Excel modeling.mp4

00:57

02 - Objectives in financial modeling.mp4

03:56

03 - Rules and best practices.mp4

03:14

04 - Assessing a financial model.mp4

05:29

05 - Doing a basic loan amortization model.mp4

04:41

06 - Thinking through the model structure.mp4

06:58

07 - The three parts of Excel models.mp4

05:13

08 - Adding toggles and inputs to a model.mp4

04:53

09 - Using if then analysis in models.mp4

05:08

10 - Making assumptions in financial models.mp4

04:56

11 - Steps in building the single-sheet model.mp4

06:29

12 - Setting up a multi-sheet financial model.mp4

04:45

13 - Linking sheets in financial models.mp4

06:22

14 - Steps in building the multi-sheet model.mp4

05:41

15 - Notating and comments in models.mp4

04:06

16 - Historical data in financial models.mp4

05:27

17 - External data in financial models.mp4

04:22

18 - Projections in financial models.mp4

08:30

19 - Determining model accuracy.mp4

05:17

20 - Stress testing models.mp4

04:25

21 - Using financial models.mp4

05:28

22 - Linking Excel results to PowerPoint.mp4

04:37

23 - Maintaining your models.mp4

04:20

24 - Continuing to build Excel models.mp4

01:36

Ex Files Excel Modeling.zip

Description

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Modeling

Michael McDonald

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.