This course is designed for those interested to learn the basics of financial models in Excel, how to create them from scratch, learn the concepts, and execute them using real-world examples, in under two hours!
Read more.Instructor
I'm a book author of the 101 Excel Series paperback books. Courses I'm focused on range from SQL, Excel Formulas, Power Query, Power BI, and much more
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Excel users
- Accountants
- Data analysts
What you’ll learn:Â
- Brag to your friends about how you can perform Financial Modeling in Microsoft Excel confidently!
- Create your own Financial Model in Excel from scratch in just 2 hours
- Understand the essence of the Financial modeling concepts and techniques, and see them in action
- See how it is done in Excel with real examples
Requirements:Â
- Must have completed the course Create Your First Financial Model In Excel
Software version used in the course:
- Microsoft Office 365
Last time, you opened a Financial Model in Excel and are overwhelmed by the number of things to do. You don’t know how to make the best use of your time. But it doesn’t have to be this way!
If you’re like me, you use Financial Models on a daily basis for important tasks, analysis, or evaluating projects. Whether it’s for business or personal related projects, everyone wants to be able to create financial models freely and easily.
Our Promise to You
By the end of this course, you will have learned how to create financial models.
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.Â
Get started today and learn more about financial models in Excel.
Course Curriculum
| Section 1 - Intro | |||
| Intro – Modules In The Course | 00:00:00 | ||
| Design Principles | 00:00:00 | ||
| Download Workbooks | 00:00:00 | ||
| Section 2 - Core | |||
| Aggregate Functions | 00:00:00 | ||
| Lookup Functions | 00:00:00 | ||
| Forecasting | 00:00:00 | ||
| Mixed References And Named Ranges | 00:00:00 | ||
| External Links | 00:00:00 | ||
| Section 3 - Skills | |||
| Error Checks | 00:00:00 | ||
| Goal Seek | 00:00:00 | ||
| WACC | 00:00:00 | ||
| NPV And IRR | 00:00:00 | ||
| Section 4 - Model | |||
| Introduction | 00:00:00 | ||
| Staff Expenses | 00:00:00 | ||
| Staff Expenses Summary | 00:00:00 | ||
| Revenue | 00:00:00 | ||
| Market Analysis | 00:00:00 | ||
| Profit And Loss | 00:00:00 | ||
| NPV IRR | 00:00:00 | ||
| Payback Period | 00:00:00 | ||
| Scenario Analysis | 00:00:00 | ||
Course Review
4.5
2 RatingsRelated Courses
Are you interested in higher education?
I learned a lot
Thank you for this knowledge you gave me .
excellent buildup from the beginner course
this course covers a range of formulas that can be used in various situations no matter the project you are working on. great for new learners or those that need a refresher.