Quickly learn and apply finance concepts in Microsoft Excel – Perfect for Beginners
What you will learn
Build a basic financial model in Excel.
Understand financial formulae in Excel and understand how to apply finance principles in Excel.
Learn the building blocks of a well structured financial model.
Description
Microsoft Excel is a powerful tool that is widely used in the finance industry for financial modelling. Financial modelling refers to the process of creating a mathematical model of a financial situation or project. It involves using Excel functions to calculate and analyze financial data to help make informed business decisions.
In this course Microsoft Excel Tools for Financial Modelling, you will:
- Learn about the Excel tools to build financial models.
- Discover the most useful Excel functions, add-ons, and formulas to build financial models, perform lookups, assess risk and scenarios and build reports.
- Uncover the secrets of Goal Seek, Solver and Data Tables for optimisation and scenario analysis.
- Understand the financial modelling process
- See why cash flow waterfalls are so important.
PLUS get:
- Downloads such as Excel shortcuts, model templates and more
- Full course slides
- Recommended reading, podcasts, and websites
- Discount codes for the annual Financial Modelling Summit, the world’s largest gathering of financial modellers
Curriculum
- The layout of a financial model
- Excel basics
- NPVs and IRRs
- Scenario Analysis
- Data Tables
- Goal Seek and Solver
- Project Finance Models Overview
- Model Auditing and Addins
- Common Model Errors
- Model Protection
- Downloads
- Recommended Reading
- Bonus – Financial Modelling for Startups
About the Instructor
The course is presented by Financial Modelling Podcast and Summit Host Matthew Bernath. Matthew is an experienced financial modeller, entrepreneur, and CFA® charterholder with a passion for finance, alternative data and analytics.
Matthew hosts the Financial Modelling Podcast, which has been rated as one of the top finance podcasts by the Corporate Finance Institute and Financial Edge. Matthew was previously in a large investment bank’s Infrastructure Finance division focusing on project finance deal structuring and modelling.
Content