A Perfect Gateway To Upskill Yourself

Financial Modelling

Learn how to build a comprehensive financial model from scratch in excel with our easy to understand approach. Also, learn the FAST standards on financial modelling and how to build a financial model on these standards.

Intermediate 5(1 Ratings)
Created By Kooldox LMS Last Updated Tue, 19-Jan-2021 English
Financial Modelling Preview This Course
$5000 $7500
Buy Now
Includes:
  • 28:02:38 Hours On Demand Videos
  • 149 Lessons
  • Access on Mobile, Tab & Laptop/Desktop
What Will I Learn?
  • Learn MS Excel and many of its advanced features
  • Learn the interconnection between financial statements
  • Build comprehensive financial model from scratch
  • Learn FAST standards on financial modelling
  • Perform the tests with keyboard shortcuts and reduce the use of mouse to increase the speed
  • learn how to use a dashboard to summarise your financial model

Curriculum For This Course
149 Lessons 28:02:38 Hours
MS Excel - Beginner to Advanced
101 Lessons 09:14:37 Hours
  • How to open MS Excel 00:02:27
  • Introduction to Excel work screen 00:11:47
  • Excel essentials - Part 1 00:20:55
  • Practice file - Excel essentials
  • Excel essentials - Part 2 00:13:16
  • Set print area 00:03:47
  • Practice file - Set Print area
  • Paste special 00:14:03
  • Practice file - Paste special
  • Filter and sort 00:08:55
  • Practice file - Filter and sort
  • Custom formatting 00:11:19
  • Practice file - Custom formatting
  • Conditional formatting - Part 1 00:08:03
  • Practice file - Conditional formatting
  • Conditional formatting - Part 2 00:03:56
  • Conditional formatting - Part 3 00:05:18
  • Sum - Sumif - Sumifs 00:13:47
  • Practice file -Sum Sumif Sumifs
  • Count-Countif-Countifs 00:07:53
  • Practice file - Count Count Countifs
  • Average-Averageif-Averageifs 00:02:49
  • Practice file - Average Average Averageifs
  • Max-Min 00:01:31
  • Practice file - Max-Min
  • Large-Small 00:07:42
  • Practice file - Large Small
  • Round functions 00:11:37
  • Practice file - round functions
  • IF-AND-OR 00:26:10
  • Practice file - IF-AND-OR
  • IF error 00:05:43
  • Practice file - IF Error
  • Sumproduct 00:03:40
  • Practice file - Sumproduct
  • Subtotal 00:05:50
  • Practice file - Subtotal
  • CAGR 00:03:36
  • Practice file - CAGR
  • Cell Freezings 00:16:02
  • Practice file - Cell freezings
  • Vlookup / Hlookup 00:20:00
  • Practice file - Vlookup / Hlookup
  • Match function 00:03:47
  • Practice file - Match function
  • Lookups with Match function 00:13:49
  • List using Data Validation 00:12:29
  • Practice file - List using Data Validation
  • Lookups Continued 00:14:42
  • Index function 00:06:29
  • Practice file - Index function
  • Index with Match 00:15:54
  • Practice file - Index and Match
  • Text function 00:17:05
  • Practice file - Text functions
  • Choose function 00:08:58
  • Practice file - Choose function
  • Developer Tab 00:08:23
  • Practice file - developer tab
  • Grouping - Ungrouping 00:06:22
  • Practice file - Grouping / Ungrouping
  • Text to columns 00:08:27
  • Practice file - Text to columns
  • Date functions - Part 1 functions 00:15:49
  • Practice file - Date functions - Part 1
  • Date functions - Part 2 00:12:48
  • Practice file - Date functions - Part 2
  • Column chart 00:29:32
  • Practice file - Charts
  • Area and Line chart 00:12:30
  • Doughnut and Pie chart 00:10:36
  • Pivot table with slicer 00:16:27
  • Practice file - Pivot table with slicer
  • Formula auditing 00:06:43
  • Practice file - Formula auditing
  • Worksheet Protection 00:15:20
  • Goal Seek 00:04:20
  • Practice file - Goal seek
  • Data table 00:08:40
  • Practice File - Data table
  • Dynamic Bar chart 00:03:16
  • Practice file - Dynamic bar chart
  • Progress circle chart 00:03:41
  • Practice file - Progress circle chart
  • Battery chart 00:02:17
  • Practice file - Battery chart
  • Tornado chart 00:03:05
  • Practice file - Tornado chart
  • Variance chart 00:02:50
  • Practice file - Variance chart
  • Thermometer chart 00:02:09
  • Practice file -Thermometer chart
  • Waterfall chart 00:19:09
  • Practice file - Waterfall chart
  • Loan schedule 00:05:12
  • Offset function 00:10:24
  • Practice file - Offset function
  • Indirect function 00:06:56
  • Practice file - Indirect function
  • Capital Budgeting 00:16:22
  • Practice file - Capital budgeting
  • Insight into Financial Statements 00:36:19
  • Case Study 1 - Input Sheet 00:04:04
  • Case Study 1 - Profit & Loss Statement 00:35:40
  • Case Study 1 - Cash Flow Statement & Working Capital 00:17:52
  • Case Study 1 - Balance Sheet 00:12:47
  • Practice fie - Case Study 1
  • Case Study 2 - Financial Statements 01:12:04
  • Practice File - Case Study 2
  • Introduction to the module 00:00:38
  • Introduction to case study 00:03:45
  • Input sheet 00:09:02
  • Template sheet 00:17:34
  • Area Statement 00:15:07
  • Revenue computation - Part 1 00:27:44
  • Revenue computation - Part 2 00:28:28
  • Revenue computation - Part 3 00:15:45
  • Profit & Loss Statement 00:15:41
  • Share of land provider 00:30:03
  • Capital Expenditure 00:11:49
  • Fixed asset schedule 00:41:03
  • Debt schedule 00:33:12
  • Working capital computation 00:09:29
  • Cash flow statement 00:09:58
  • Equity schedule 00:08:06
  • Balance sheet 00:07:31
  • Dashboard 00:52:40
  • Practice file - Hospitality Industry
  • FAST standards on financial modelling 01:00:15
  • Practice file - Case Study - Manufacturing sector
  • Introduction to the case study 00:12:52
  • Template Sheet 00:16:58
  • Creating a timeline 00:31:31
  • Timeline and Flags 00:26:38
  • Creating historical financial statements 00:08:47
  • Building scenarios 00:17:02
  • Revenue computation 00:32:19
  • Cost of sales 00:27:57
  • Selling, general & administrative expenses 00:08:00
  • Corkscrew & Depreciation 00:32:03
  • Fixed asset schedule 00:05:24
  • Tax expense & Deferred tax 00:19:30
  • Working capital 00:32:44
  • Equity schedule 00:21:52
  • Linking the financial statements 00:08:38
  • Debt schedule 00:46:56
  • Dashboard 00:17:22
  • Practice file - McDonalds Corp
  • Live example - McDonalds Corp 03:04:52
Requirements
  • A computer with MS Excel and a zeal to learn
+ View More
Description
+ View More
Other Related Courses
Excel like a Pro
09:14:37 Hours
Excel like a Pro
Updated Sun, 09-Feb-2025
5 $1000 $650
Financial Modelling & Valuations
39:13:06 Hours
Financial Modelling & Valuations
Updated Sun, 09-Feb-2025
5 $12000 $10000
dummy11
00:00:00 Hours
dummy11
Updated Fri, 19-Mar-2021
0 $11 $9
About The Instructor
Financial Modelling
  • 9 Reviews
  • 40 Students
  • 6 Courses
+ View More
Kooldox LMS
Created by highly qualified professionals, Kooldox works with the motive of helping students and professionals learn and grow with customized courses.
.
Student Feedback
5
Average Rating
  • 0%
  • 0%
  • 0%
  • 0%
  • 100%
Reviews
  • Financial Modelling
    Fri, 06-Nov-2020
    Kishan Sisodia
    Dear John and Team, "It has been great to start the advanced excel and financial modelling course from Kooldox. The way video has been recorded, you feel that you are connected with the trainer. very nicely and minutely explained all the tricks of financial modelling and excel. This is surely a value addition in my portfolio."