Learn Financial Modelling - Step by Step - Session 2
Financial modelling is a crucial skill for professionals in finance, business, and accounting.
Start your journey towards becoming a financial modelling expert now!
📥 Download the Exercise Files - https://drive.google.com/drive/folder...
—-----------------------------------------------------------------------------------------------------------------
🚀 Want to level up?
Here are our flagship finance programs built for serious learners:
🔥CFA Level I:
Course Explainer: https://thevaluationschool.in/ytCFA
Demo Lectures: https://thevaluationschool.in/ytchann...
Registration Link: https://thevaluationschool.in/CFAL1
Brochure CFA: https://thevaluationschool.in/CFAbroc...
🔥 Equity Research Program:
Register here: https://thevaluationschool.in/equity
Brochure: https://thevaluationschool.in/EQUITYb...
Note: RECORDINGS of all LIVE sessions will be provided
🔥Advanced Valuation & Financial Modelling (AVFM):
Registration Link: https://thevaluationschool.in/AVFM
Brochure: https://thevaluationschool.in/AVFMbro...
Note: RECORDINGS of all LIVE sessions will be provided
🔥LinkedIn Mentoring Cohort:
Registration Link: https://thevaluationschool.in/linkedin
Brochure: https://thevaluationschool.in/LNbrochure
🔥Technical Analysis Workshop:
Registration Link: https://thevaluationschool.in/chartre...
Brochure: https://thevaluationschool.in/TAbrochure
—-----------------------------------------------------------------------------------------------------------------
👉 Playlists by The Valuation School:
🌟Learn Financial Modelling - Step by Step - https://thevaluationschool.in/ytplayl...
🌟Equity Research Full Course in Hindi - https://thevaluationschool.in/ytplayl...
🌟Learn AI for Finance - Step by Step in Simple Hindi - https://thevaluationschool.in/ytplayl...
🌟Mutual Fund Analysis - Full Course - https://thevaluationschool.in/ytplayl...
🌟Weekly Bazaar Talks - https://thevaluationschool.in/ytplayl...
🌟NISM 15 Research Analyst Full Course - https://thevaluationschool.in/ytplayl...
🌟NISM 8 Exam - FULL FREE Course in Hindi - https://thevaluationschool.in/ytplayl...
🌟CFA Guidance in Hindi - https://thevaluationschool.in/ytplayl...
🌟Career in Finance - Guidance Series - https://thevaluationschool.in/ytplayl...
🌟Investment Banking Skills & Guidance Series - https://thevaluationschool.in/ytplayl...
—-----------------------------------------------------------------------------------------------------------------
👉 Stay connected with us: -
✅Parth Verma Classes YouTube: https://thevaluationschool.in/ytchann...
✅Parth Verma Classes (CFA Level I) Instagram: https://thevaluationschool.in/instagr...
✅The Valuation School Instagram: https://thevaluationschool.in/instgra...
✅ Newsletter - https://thevaluationschool.in/newslet...
✅ WhatsApp Channel - https://thevaluationschool.in/wachann...
✅ LinkedIn (Parth Sir): https://thevaluationschool.in/linkedinPV
✅ LinkedIn (The Valuation School page): https://thevaluationschool.in/linkedi...
—-----------------------------------------------------------------------------------------------------------------
00:04 Understanding Excel settings and functions for Financial Modeling
02:17 Learn how to optimize Excel for financial modeling
07:07 Learn about financial modeling in Excel and how to optimize your calculations and save time
09:33 Automate data table updates and use automatic calculation for efficient financial modeling.
14:44 Learn how to use the analysis tool pack in Excel for regression analysis.
18:03 Learn how to set up the analysis tool pack in Excel.
22:30 Learn how to format cells and columns in Excel
25:32 Learn Financial Modelling step-by-step
30:23 Formatting numbers in Financial Modelling
32:25 Understanding the conventions of color coding in financial modeling.
37:56 Learn how to audit and format cells in a financial model
39:55 Learn to avoid hardcoding numbers in financial modelling
45:51 Learn to group and organize data in financial modelling
48:44 Highlight the gross profit and add a border
52:33 Understanding the process of changing and checking formulas in financial modelling.
54:58 Understanding and implementing partial anchoring in revenue calculation.
1:01:29 Understanding and implementing financial modelling techniques
1:04:03 Immediate results from 5% with 100% impact.
1:09:48 Learn about custom formatting and applying it to numbers.
1:12:55 Hard coding and absolute anchoring are important in financial modelling.
1:17:40 The start date for this year is 15th August.
1:20:25 Learn about casting analysis and how to link cells in financial modelling
1:25:57 Min function is used to find the smallest number in a sequence
1:28:48 Learn how to express the condition 'if less than' in financial modeling
1:35:36 Learn Financial Modelling - Step by Step - Session 2