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/m44hd4mz

PW Skills-Finance Paid Batches

📕 Click Here To Enroll "🎓 Finance Upskilling Courses👇
https://physicswallah.onelink.me/ZAZB/v6dmtfll
📕 Click Here To Enroll "🎓 Certificate Program in Finance, Tax & Accounting in Asociation with PwC India👇
https://physicswallah.onelink.me/ZAZB/z3rcvwc8
📕 Click Here To Enroll "📚 Investment Banking Program in Assciation with PwC India👇
https://physicswallah.onelink.me/ZAZB/0fb1y1np
📕 Click Here To Enroll "🧾 TallyPrime Advance with GST👇
https://physicswallah.onelink.me/ZAZB/1dqovby6
📕 Click Here To Enroll "📊 TallyPrime Basic with GST👇
https://physicswallah.onelink.me/ZAZB/th16wuex
📕 Click Here To Enroll "📊 Stock Market for Beginners👇
https://physicswallah.onelink.me/ZAZB/c5jl6tj1
-------------------------------------------------------

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/m44hd4mz
📕 Click Here To Enroll "📚 Investment Banking Interview Q/A 👇
https://physicswallah.onelink.me/ZAZB/26mkh1gb
📕 Click Here To Enroll "📚 Investment banking free series batch👇
https://physicswallah.onelink.me/ZAZB/ok1t94f0
-------------------------------------------------------
📊 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
https://www.youtube.com/playlist?list=PLT1bgPSfzwDhBjXY0iD5sVkEzFH91nGPQ
-------------------------------------------------------
📲 PW App/Website: https://pwskills.com/
📚 PW Store: Link: https://pwskills.com/category/banking-and-finance/?source=pwskills.com&position=course_dropdown&page_ref=home_page
📲 Instagram: https://www.instagram.com/pwskills_finance
67fa254762d1f60d45a855c6
🔖WhatsApp Community: https://whatsapp.com/channel/0029Vb6Sopz2phHKpoQnhM1m
-------------------------------------------------------
#FinancialModelling #ExcelForFinance #FinanceCourse #FinancialAnalysis #ExcelTutorial #FinanceSkills #InvestmentBanking #CorporateFinance #FinanceTraining #FinancialModellingSession2

Видео Financial Modelling Course (Session 2) | Excel for Financial Analysis канала PW Skills - Finance