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/folders/196suE4AlEh9oxesvBgxm6ftP-a5Ckq_R?usp=sharing

——————————————————————————————————————–

🚀 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/ytchannelPVC
Registration Link: https://thevaluationschool.in/CFAL1
Brochure CFA: https://thevaluationschool.in/CFAbrochure

🔥 Equity Research Program:
Register here: https://thevaluationschool.in/equity
Brochure: https://thevaluationschool.in/EQUITYbrochure
Note: RECORDINGS of all LIVE sessions will be provided

🔥Advanced Valuation & Financial Modelling (AVFM):
Registration Link: https://thevaluationschool.in/AVFM
Brochure: https://thevaluationschool.in/AVFMbrochure
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/chartreading
Brochure: https://thevaluationschool.in/TAbrochure

——————————————————————————————————————–

👉 Playlists by The Valuation School:

🌟Learn Financial Modelling – Step by Step – https://thevaluationschool.in/ytplaylistFM
🌟Equity Research Full Course in Hindi – https://thevaluationschool.in/ytplaylistER

🌟Learn AI for Finance – Step by Step in Simple Hindi – https://thevaluationschool.in/ytplaylistAI
🌟Mutual Fund Analysis – Full Course – https://thevaluationschool.in/ytplaylistMF

🌟Weekly Bazaar Talks – https://thevaluationschool.in/ytplaylistWBT

🌟NISM 15 Research Analyst Full Course – https://thevaluationschool.in/ytplaylistNISM15
🌟NISM 8 Exam – FULL FREE Course in Hindi – https://thevaluationschool.in/ytplaylistNISM8

🌟CFA Guidance in Hindi – https://thevaluationschool.in/ytplaylistCFA
🌟Career in Finance – Guidance Series – https://thevaluationschool.in/ytplaylistGUIDANCE
🌟Investment Banking Skills & Guidance Series – https://thevaluationschool.in/ytplaylistIB

——————————————————————————————————————–

👉 Stay connected with us: –

✅Parth Verma Classes YouTube: https://thevaluationschool.in/ytchannelPVC
✅Parth Verma Classes (CFA Level I) Instagram: https://thevaluationschool.in/instagramPVC

✅The Valuation School Instagram: https://thevaluationschool.in/instgramTVS
✅ Newsletter – https://thevaluationschool.in/newsletterTVS
✅ WhatsApp Channel – https://thevaluationschool.in/wachannelTVS

✅ LinkedIn (Parth Sir): https://thevaluationschool.in/linkedinPV
✅ LinkedIn (The Valuation School page): https://thevaluationschool.in/linkedinTVS

——————————————————————————————————————–

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

source