Learn FINANCIAL MODELLING in EXCEL - STEP BY STEP - Session 3

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! You can connect with Parth Sir on Linkedin -https://www.linkedin.com/in/caparthverma 📥 DOWNLOAD the EXERCISE FILES - https://drive.google.com/drive/folders/19apwNdhJcMwrC4sc1q99_v7j1l63jKRa?usp=share_link 📛 If you want to join our next LIVE masterclass on Zoom = Join our Whatsapp community (TVS Mentoring) - https://chat.whatsapp.com/KS2CNcmqgXf1KbeH4dySj7 -------------------------- 👉JOIN: 🔥 NEXT LINKEDIN COHORT - https://rzp.io/l/uHTWYlSH 🔥 NEXT EQUITY RESEARCH COHORT - https://pages.razorpay.com/ERCohort4 -------------------------- ✅ You can connect with Parth Sir on Linkedin - https://www.linkedin.com/in/caparthverma ✅Follow The Valuation School page on Linkedin - https://www.linkedin.com/school/thevaluationschool ✅Join our Instagram handle - https://www.instagram.com/thevaluationschool ✅Join our Whatsapp channel - https://whatsapp.com/channel/0029VaLf0RcKgsNyJF898b27 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