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 PREVIEWDownload the PDF File: 200+ Excel Shortcuts for PC & Mac
QUIZ 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
QUIZ 3: Tools and Techniques for Financial Modeling
Differences among Types of Analysis
Goal Seeking
Activity: Calculate Break Even using Goal Seek
How to Build Drop-Down Scenarios
Sensitivity Analysis with Data Tables
Activity: Projections and Estimates using Data Tables
How to use Scenario Manager (Loan Calculations made easy)
Activity: Scenario Manager
Solver
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
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
$19.99
Become a proficient Excel Macros and Excel VBA Programmer in a very short time. Excel 2019 Macros & VBA Examples included.
$14.99
Master Microsoft Power BI Desktop, Create Interactive Dashboards & Learn Advanced Analytics with DAX and Power Query
$9.99
Master 20+ Advanced Dynamic Excel Charts & Create Impressive Excel Graphs, Infographics & Data Visualization
$9.99
Master Excel with 100+ Excel Tips & Hacks, from an Excel Best Seller Instructor. Excel Project Files included.
$9.99
A Python 3 Practical Programming Course for Absolute Beginners - Learn how to Code in Python 3.9 (2022 Edition)
$14.99