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 –
——————————————————————————————————————–
🚀 Want to level up?
Here are our flagship finance programs built for serious learners:
🔥CFA Level I:
Course Explainer:
Demo Lectures:
Registration Link:
Brochure CFA:
🔥 Equity Research Program:
Register here:
Brochure:
Note: RECORDINGS of all LIVE sessions will be provided
🔥Advanced Valuation & Financial Modelling (AVFM):
Registration Link:
Brochure:
Note: RECORDINGS of all LIVE sessions will be provided
🔥LinkedIn Mentoring Cohort:
Registration Link:
Brochure:
🔥Technical Analysis Workshop:
Registration Link:
Brochure:
——————————————————————————————————————–
👉 Playlists by The Valuation School:
🌟Learn Financial Modelling – Step by Step –
🌟Equity Research Full Course in Hindi –
🌟Learn AI for Finance – Step by Step in Simple Hindi –
🌟Mutual Fund Analysis – Full Course –
🌟Weekly Bazaar Talks –
🌟NISM 15 Research Analyst Full Course –
🌟NISM 8 Exam – FULL FREE Course in Hindi –
🌟CFA Guidance in Hindi –
🌟Career in Finance – Guidance Series –
🌟Investment Banking Skills & Guidance Series –
——————————————————————————————————————–
👉 Stay connected with us: –
✅Parth Verma Classes YouTube:
✅Parth Verma Classes (CFA Level I) Instagram:
✅The Valuation School Instagram:
✅ Newsletter –
✅ WhatsApp Channel –
✅ LinkedIn (Parth Sir):
✅ LinkedIn (The Valuation School page):
——————————————————————————————————————–
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
I have attend paid classes also but this one is truly remarkable
Sir thank yuh soooooooo much for this ..means alottttttttttttttttttttttt🙌🏻❤️
Sir, you updated the 2024 revenue growth percentage, but it looks like you forgot to apply the color formatting.
Sir i am not getting items in option
Which version are you using for excel
1:11:22
Some of the options are not available for the free version of Excel like Add Ins & Error checking
, will I able to do financial modelling with it??
sir when i am downloading exercise files the exercise is already done in that file
sir ek video ke liye or sath me apply karne pe 4 hrs ghante lag gye kabhi itna kisi ne sikhaya hi nhi
i have recently started it, hoping for the best
kisi ne agar notes banaye ho financial modelling ke toh mujhe share krdena mere contact no. par
I have doubt 35:31 how you are doing divide and sums , how we understand that from this to that it is divided
thankyou sir
24JUNE 54:00
25:17 Freeze Pan
51:46 Advance Setup
41:13 sr ne yaha link kaise kya ? lke wo sare cells toh select vase h kr lye but last me vo sari baki ki values nhi aa rhi h
You've done a fantabulous job.Thanks a lot bro
the add in option in my settings is grayed out, What can i do to fix it?
32:00
Sir why you added +1 in formula ??
31:08
1:23:00
36;55, 42;53
41:18 how did you do it? autofill?
which excel version is this??
Sir, please post the content in english so that larger audience can benefit from this 🙏
I am learning Financial Modelling right now, but it denies me access to Google Drive. Is there any way to solve it?
Dear Sir,
Excellent video with great explanation… Thanks a lot!!
Kindly request anyone to help me where can download the file (Template) please……….
Thanks nice session
I have never watched a youtube video in 0.65 being a uni student it's always 2x. But your videos are so full of knowledge that one has to soak in every second with full attention. I can't thank you enough for this. If I ever get a chance to mention my mentor, I am gonna mention you. Like I have no words to thank you enough.
op
hello sir,
sir i have a doubt in time period section (monthly data , annual data, monthly period and annual period) not the calculation thing. question is that what is use and what are this, time reference is 1:18:38
43.30 getting different revenue can anyone help me
In 55:39 Alt + H + 0
1:17:15
Sir, I am having issue with auditing. When I formula audit it shows a prompt saying "No cells were found" and and when I select constant it selects all the values that are hardcoded and in which formula have been used. What should I do?
Sir, I am unable to use CTRL+ALT+V, how can I access it on my PC?
sir, these excel sheets are not downloading. what to do now please provide any solution.
What is version of excel Sir?
After completing all these sessions , can we apply for job ?
Pls reply ✨
Time stamps for my reference
50:00 border settings
52:43 checking model convention
Spent 20 mins finding an error in the Income statement.
Later realised there was change in values in basic forecasting and advanced setup sheet .
Still happy with the content.
Great work by sir.