arrow_back
Are you sure you wanna do this ? 😛
Recordings & Files
Introduction to curriculum
Expectation setting
Understanding excel layouts, Navigating in excel
Freezing panes, Hiding cells and rows
Sum, Average, Product, Median, Mode, Round Filters
Sorting, Rank, Min, Max, Remove duplicates
Name ranges, IF, Nested If, Sumif, Sumproduct
Hlookup, Vlookup, Index Paste special
Data validation
conditional formatting
Grouping of rows and columns
Introduction and usage of financial statements
What do you need before starting a model creation?
Financial modelling best practices - 1 & 2
Ratio analysis -1
Ratio analysis -2 and Doubt solving
Time value of money
Building First Financial Model
Summarising the model creation process
Doubt solving
Using charts
Cost of capital
Scenario managers
discounting rate calculation
Sensitivity analysis
Using financial models for valuation -1, 2, & 3
Doubt solviing
Wrap up
Capital budgeting
The magic of time value of money Working session - Case 1
Capital Budgeting Case Study - Classroom
Financial Analysis - Classroom
Income Tax Calculation Case_b12-1
Income Tax Calculation Case_b12
Marketing Case Data_b12
Marketing Case Data
Assessment