Financial Modelling Course (Session 2) | Excel for Financial Analysis

Lecture by Kuldeep Sharma Sir ------------------------------------------------------- Click The Below Link To Download FREE Notes Of This Session 👇 https://physicswallah.onelink.me/ZAZB... PW Skills-Finance Paid Batches 📕 Click Here To Enroll " Financial Modeling with AI"👇 https://bit.ly/3RTbQj6 📕 Click Here To Enroll "🎓 Certificate Program in Finance, Tax & Accounting in Asociation with PwC India👇 (CPFTA) https://bit.ly/4efrqx6 📕 Click Here To Enroll "🧾 TallyPrime Advance with GST👇 https://bit.ly/4vAwovl 📕 Click Here To Enroll "📊 TallyPrime Basic with GST👇 https://bit.ly/4xiy3az ------------------------------------------------------- 0:00 – Logical Thinking vs Execution 0:45 – Excel for Financial Analysis Intro 6:12 – Cell Anchoring Basics 8:36 – Partial Lock (Correct Method) 12:19 – Control + Enter Trick 22:30 – Subtotal (109) Formula 27:39 – Data Validation Purpose 33:34 – Date Validation 35:23 – List Validation (Dropdown) 38:13 – Input Message 39:12 – Custom Error Alert 40:06 – Dependent Dropdown Concept 41:31 – Name Manager 47:07 – Key Assumptions Naming 52:15 – Name Manager Creation 53:08 – Formula Readability 54:00 – Cross-Sheet Reference 1:00:36 – Paste Values 1:03:16 – Transpose 1:04:40 – Arithmetic Paste Special 1:08:39 – Custom Formatting 1:24:49 – Grouping Use 1:25:37 – Grouping Shortcuts 1:27:42 – Collapse & Expand 1:28:47 – EOMONTH Function 1:32:09 – CTRL + D Fill Down 1:33:41 – DATEDIF Formula 1:39:02 – IF Formula Structure 1:40:22 – Basic IF Implementation 1:41:03 – Nested IF 1:44:07 – Shrink to Fit 1:46:03 – IF with AND/OR Logic 1:49:04 – VLOOKUP Basic Structure 1:53:27 – VLOOKUP with MATCH 1:56:26 – INDEX & MATCH Function PW Skills-Finance Free Batches 📕 Click Here To Enroll "🎓Financial Modeling – Free Course"👇 https://physicswallah.onelink.me/ZAZB... 📕 Click Here To Enroll "📚 Investment Banking Interview Q/A 👇 https://physicswallah.onelink.me/ZAZB... 📕 Click Here To Enroll "📚 Investment banking free series batch👇 https://physicswallah.onelink.me/ZAZB... ------------------------------------------------------- 📊 Financial Modelling Course (Session 2) | Excel for Financial Analysis 📊 Take your financial skills to the next level with Session 2 of our Financial Modelling Course! In this session, we focus on Excel techniques for financial analysis, helping you build accurate financial models, perform data analysis, and make informed business decisions. 📘 Topics Covered: ✅ Advanced Excel Functions for Finance ✅ Financial Statement Analysis ✅ Building Dynamic Financial Models ✅ Practical Examples & Case Studies ------------------------------------------------------- 📕Financial Modeling – Free Course    • Financial Modelling & Valuation Masterclas...   ------------------------------------------------------- 📲 PW App/Website: https://pwskills.com/ 📚 PW Store: Link: https://pwskills.com/category/banking... 📲 Instagram:   / pwskills_finance   67fa254762d1f60d45a855c6 🔖WhatsApp Community: https://whatsapp.com/channel/0029Vb6S... ------------------------------------------------------- #FinancialModelling #ExcelForFinance #FinanceCourse #FinancialAnalysis #ExcelTutorial #FinanceSkills #InvestmentBanking #CorporateFinance #FinanceTraining #FinancialModellingSession2