Excel Financial Modeling and Business Analysis Masterclass

Excel Financial Modelling from scratch: Financial Statements, Project Costing, Discounted Cash Flow (DCF), Accounting

Buy $19.99 Free Preview

Course curriculum

1. Welcome to the course
  FREE PREVIEW
2. Course Resources & Setting Expectations
  FREE PREVIEW
3. What is Financial Modelling?
  FREE PREVIEW
4. Why is financial modeling important?
  FREE PREVIEW
5. Recognizing the benefits and pitfalls of using Excel
  FREE PREVIEW
6. Examples of Financial Models
  FREE PREVIEW
7. Download the PDF File: 200+ Excel Shortcuts for PC & Mac
8. QUIZ 1: Introducing Financial Modelling
1. Let’s warm up by creating a budget in Excel
2. Find the Data for the Model
3. Identifying the Problem That Your Financial Model Needs to Solve
4. Steps To Building a Model
5. Methods for Including Documentation in a Model
6. Exercise 1: Mellon T-Shirt
7. Answer to Exercise 1
8. QUIZ 2: Planning & Designing your Financial Model
1. Introducing Cell Referencing
2. Naming Ranges
3. Dynamic Ranges (& UNIQUE Function)
4. DEMO: P&L Calculations
5. Restricting and Validating Data
6. QUIZ 3: Tools and Techniques for Financial Modeling
1. Differences among Types of Analysis
2. Goal Seeking
3. Activity: Calculate Break Even using Goal Seek
4. How to Build Drop-Down Scenarios
5. Sensitivity Analysis with Data Tables
6. Activity: Projections and Estimates using Data Tables
7. How to use Scenario Manager (Loan Calculations made easy)
8. Activity: Scenario Manager
9. Solver
1. Introduction
2. Create a Dates Table
3. Dates Method
4. Creating Number Patterns
5. Summing Data Through Shortcuts
6. Create A Chart through Shortcuts Keys
7. Isolate Any Part Of a Chart & Chart Templates
8. Manipulate Filter Data And Paste
9. Icon Sets With Words
10. Camera Tool
11. Pivot Tables Creation Shortcuts
12. The Advanced Filter
13. QUIZ 4: Using Shortcuts for Speed and Accuracy
1. Introduction
2. Identifying the Difference between a Formula and a Function
3. Relative vs Absolute Cell Reference
4. Commonly Used Functions - SUM, MAX, MIN, and AVERAGE
5. COUNT and COUNTA
6. ROUND, ROUNDUP and ROUNDDOWN
7. SUMIFs Function
8. VLOOKUP, HLOOKUP and XLOOKUP
9. INDEX, MATCH and their Combination
10. OFFSET Function
11. Advanced Custom Number Formatting
12. QUIZ 5: Essential Functions in Financial Modeling
1. 38_Introduction
2. Types of Interest: Simple vs. Compound
3. PMT: Calculate a loan payment
4. PPMT and IPMT: Calculate the principal and interest per loan payment
5. NPER: Calculate the number of periods in an investment
6. PV: Calculate the present value of an investment
7. NPV: Calculate the net present value of an investment
8. XNPV: Calculate net present value given irregular inputs
9. FV: Future value of an investment
10. IRR: Internal rate of return (& XIRR & MIRR & RRI Functions)
11. RATE: Discover the interest rate of an annuity
12. SLN: Depreciation using the straight-line method
13. QUIZ 6: Financial Functions
1. EOMONTH, EDATE, and timing flags
2. Calculate Pro Data Rental Costs with Date Functions
3. IF: Building Logical Comparisons
4. Calculating the Payback Period
5. Using RATE or RRI for compound annual growth rate (CAGR)
6. Creating a Debt Schedule
7. Using SLN and IF to calculate Depreciation
8. Creating a Depreciation Schedule
9. Calculating Weighted Average Cost of Capital (WACC)
10. Using NPV to calculate a Discounted Cash Flow (DCF)
11. QUIZ 7: Financial Analysis using Functions
1. Introduction
2. SUMPRODUCT and SUMIFS Functions
3. When to use SUMPRODUCT over SUMIFS
4. Advanced combinations of SUMPRODUCT, SUMIFS, INDEX & MATCH
5. LOOKUP Formulas
6. INDIRECT and ADDRESS Formulas
7. QUIZ 8: Advanced Functions in Financial Modeling
1. Introduction
2. Preparing your Data
3. Trending Column Chart
4. Stacked Column Chart
5. Four-Segment Line Chart
1. Introduction
2. Important Formulas for Accounting
3. Cash flow budgeting in Excel
4. P&L in Excel
5. Record-Keeping in Excel
6. Pivot tables for accountants
7. QUIZ 9: Excel for Accountants
1. Introduction
2. How to build the Assumptions Worksheet
3. Calculating Revenue
4. Calculating Expenses
5. Building the Profit and Loss (P&L) Statement
6. Building the Cash Flow Statement
7. Building the Balance Sheet
8. Building Scenarios
1. Introduction
2. Designing the Project Costing Model
3. Entering Assumptions
4. Entering Calculations (Operations)
5. Entering Calculations (Financing & Cash Flow Summary)
6. Building Scenarios with Goal Seek
7. Building the Output Page
1. Introduction
2. Preparing the Data
3. Discounted Cash Flow (DCF) Calculations Part: 1
4. Creating Scenarios
5. Discounted Cash Flow (DCF) Calculations Part: 2
6. Calculating Perpetual Growth Rates
1. Introduction
2. Preparing the Data
3. Building the Labour Worksheet
4. Calculating Activity-Based Costing Output: Part 1
5. Calculating Activity-Based Costing Output Part: 2
6. Building Activity-Based Costing Charts
7. Using Formulas to create filters for our data
1. Introduction
  FREE PREVIEW
2. Input (Raw) Data of the Dashboard
3. Presenting the Calculations and Dashboard Worksheets
4. Building the Calculations Part:1
5. Building the Calculations (SUMIFS & VLOOKUP) Part:2
6. Building the Calculations (SUMPRODUCT) Part:3
7. Creating a Trending Column Chart
8. Creating a Line chart with Markers
9. Creating a Bullet Chart with Performance Targets
10. Creating a Combo Chart & Setting Up the Option Buttons
11. Creating Stacked Bars with Positive & Negative Values
12. Creating a Four-Segment Line Chart
13. Finalizing our Dashboard

About this course

$19.99
140 lessons
12.5 hours of video content

Discover your potential, starting today

Enroll today

Who is Teaching the Course?

Andreas Exadaktylos

[email protected]

Hi, I am Andreas and I'm a Best Selling Teacher. I really love learning and teaching whenever I can. I have a Master's Degree in Computer Science and a Degree in Electronic Engineering. I have over 20 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an Online Learning School. I have a passion for software products that make people's lives easier. I teach Python Programming, Microsoft Excel and all Microsoft software products for over 20 years. I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family, my two kids and my lovely dog. Travel, forex trading, and reading books are my favorite hobbies.