Learn Financial Modelling - Step by Step - Learn FINANCIAL MODELLING in EXCEL - STEP BY STEP - Session 3

Master Financial Modelling: From Basics to Advanced Excel Techniques with The Valuation School – Unlock Investment Banking Excellence!

5.0 (2)

23 learners

What you'll learn

Master building comprehensive financial models in Excel
Analyze financial statements using advanced ratio and sensitivity analysis
Apply valuation techniques like DCF and WACC in investment banking contexts
Develop expertise in financial forecasting and growth rate projections

This course includes

24.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

financial modelling financial modeling in excel what is financial modeling excel financial modelling financial modelling best coaching how to build a financial model excel financial modeling financial modeling courses financial modeling and valuation financial modeling career financial modeling interview questions financial modeling for beginners

Full Transcript

In this session of FULL COURSE on FINANCIAL MODELLING in EXCEL; we have covered everything you need to know in FINANCIAL MODELLING as BEGINNER. It covers ways and TRICKS through which you can SIMPLIFY your FINANCIAL MODEL using various EXCEL functions such as NAME MANAGER, DATA VALIDATION, VLOOKUP, GOAL SEEK, DATA TABLE, SCENARIO ANALYSIS, SCENARIO MANAGER, etc. we have also touched upon, HOW TO PROTECT your FINANCIAL MODEL IN EXCEL using CELL LOCKING and WORKSHEET PROTECTION. Like our previous session in FULL COURSE on FINANCIAL MODELLING for BEGINNERS, it also breakdown everything in STEP BY STEP manner using LIVE PROJECT or EXERCISE file so you can PRACTICE it while watching this session (link below). FINANCIAL MODELLING in EXCEL is a crucial SKILL one must learn in order to make a CAREER in INVESTMENT BANKING, EQUITY RESEARCH, VALUATION, and other CORE FINANCE ROLES. By the end of this course, you will have a STRONG FOUNDATION in FINANCIAL MODELLING and be able to confidently CREATE FINANCIAL MODELS IN EXCEL to support decision-making in your professional life. Start your journey towards becoming a FINANCIAL MODELLING EXPERT now! 📥 DOWNLOAD the EXERCISE FILES - https://drive.google.com/drive/folders/19apwNdhJcMwrC4sc1q99_v7j1l63jKRa?usp=share_link —----------------------------------------------------------------------------------------------------------------- 🚀 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 —----------------------------------------------------------------------------------------------------------------- Time Stamps 0:00 - Introduction 1:14 - Mentoring Session Details 1:35 - Why Simplify the model? 2:33 - Name Management 15:10- Using VLOOKUP for Simplification 23:58 - GOAL SEEK in Modelling 28:26 - Using DATA TABLE 33:34 - SCENARIO ANALYSIS 39:58 - SCENARIO MANAGER 44:25 - DATA VALIDATION 50:45 - PROTECTING the MODEL