Excel Modeling Tips and Tricks (2021) Preview

Excel Modeling Tips and Tricks (2021)

With Michael McDonald Liked by 14,932 users
Duration: 1h 56m Skill level: Intermediate Released: 5/25/2021

Course details

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.

Skills you’ll gain

Earn a sharable certificate

Share what you’ve learned, and be a standout professional in your desired industry with a certificate showcasing your knowledge gained from the course.

Sample certificate

Certificate of Completion

  • Showcase on your LinkedIn profile under “Licenses and Certificate” section

  • Download or print out as PDF to share with others

  • Share as image online to demonstrate your skill

Meet the instructor

Learner reviews

4.7 out of 5

1,106 ratings
  • 5 star
    Current value: 867 78%
  • 4 star
    Current value: 187 17%
  • 3 star
    Current value: 43 4%
  • 2 star
    Current value: 5 <1%
  • 1 star
    Current value: 4 <1%

Contents

What’s included

  • Practice while you learn 1 exercise file
  • Test your knowledge 4 quizzes
  • Learn on the go Access on tablet and phone

Similar courses

Download courses

Use your iOS or Android LinkedIn Learning app, and watch courses on your mobile device without an internet connection.