Excel Financial Modeling and Business Analysis Masterclass
Excel Financial Modelling from scratch: Financial Statements, Project Costing, Discounted Cash Flow (DCF), Accounting
Welcome to the course
FREE PREVIEWCourse Resources & Setting Expectations
FREE PREVIEWWhat is Financial Modelling?
FREE PREVIEWWhy is financial modeling important?
FREE PREVIEWRecognizing the benefits and pitfalls of using Excel
FREE PREVIEWExamples of Financial Models
FREE PREVIEWQUIZ 1: Introducing Financial Modelling
Let’s warm up by creating a budget in Excel
Find the Data for the Model
Identifying the Problem That Your Financial Model Needs to Solve
Steps To Building a Model
Methods for Including Documentation in a Model
Exercise 1: Mellon T-Shirt
Answer to Exercise 1
QUIZ 2: Planning & Designing your Financial Model
Introducing Cell Referencing
Naming Ranges
Dynamic Ranges (& UNIQUE Function)
DEMO: P&L Calculations
Restricting and Validating Data
Goal Seeking
QUIZ 3: Tools and Techniques for Financial Modeling
Introduction
Create a Dates Table
Dates Method
Creating Number Patterns
Summing Data Through Shortcuts
Create A Chart through Shortcuts Keys
Isolate Any Part Of a Chart & Chart Templates
Manipulate Filter Data And Paste
Icon Sets With Words
Camera Tool
Pivot Tables Creation Shortcuts
The Advanced Filter
QUIZ 4: Using Shortcuts for Speed and Accuracy
Introduction
Identifying the Difference between a Formula and a Function
Relative vs Absolute Cell Reference
Commonly Used Functions - SUM, MAX, MIN, and AVERAGE
COUNT and COUNTA
ROUND, ROUNDUP and ROUNDDOWN
SUMIFs Function
VLOOKUP, HLOOKUP and XLOOKUP
INDEX, MATCH and their Combination
OFFSET Function
Advanced Custom Number Formatting
QUIZ 5: Essential Functions in Financial Modeling
38_Introduction
PMT: Calculate a loan payment
PPMT and IPMT: Calculate the principal and interest per loan payment
NPER: Calculate the number of periods in an investment
PV: Calculate the present value of an investment
NPV: Calculate the net present value of an investment
XNPV: Calculate net present value given irregular inputs
FV: Future value of an investment
IRR: Internal rate of return (& XIRR & MIRR & RRI Functions)
RATE: Discover the interest rate of an annuity
SLN: Depreciation using the straight-line method
QUIZ 6: Financial Functions
We get it, there are lots of great options to choose from. We’ve got Excel, Power BI, Finance, Python & Gmail courses
Learn Excel Power Query, Power Pivot, DAX, & Power BI Tools. Build Excel Data Analyst Models with Excel 365
$39
Become a proficient Excel Macros and Excel VBA Programmer in a very short time. Excel 2019 Macros & VBA Examples included.
$29
Master Microsoft Power BI Desktop, Create Interactive Dashboards & Learn Advanced Analytics with DAX and Power Query
$29
Master 20+ Advanced Dynamic Excel Charts & Create Impressive Excel Graphs, Infographics & Data Visualization
$19
Master Excel with 100+ Excel Tips & Hacks, from an Excel Best Seller Instructor. Excel Project Files included.
$19
A Python 3 Practical Programming Course for Absolute Beginners - Learn how to Code in Python 3.9 (2022 Edition)
$19