The most practical Excel course

Excel Built for Reporting Efficiency

Learn Excel the Way FP&A, Business Finance, Data & Reporting Professionals Use to Analyze, Automate & Improve Reporting Workflows

Recorded ₹950 →Live ₹2,499 →

2Certifications

2,000+Learners

THE EXCEL JOURNEY

Your Journey

Excel Basics

For beginners

MIS & Dashboards

MNC Project Based

Power Query

Automate Data Preparation

Data Modelling

Connect Datasets

DAX

Build Advanced Formulas

Dynamic Reports

No VLOOKUP / SUMIF

Automated Dashboard

Change Source Data → Refresh

WHAT YOU WILL BUILD

Build the Work — Not Just Watch the Lessons

See the kinds of reporting, dashboards and automation solutions you will work through.

BASICS TO ADVANCED

Excel Dashboard Project — Automated Dashboard

Excel Project Data Table — What-IF Scenarios

Excel Project Data Files — NO TOY data. Work with real data

Excel Project Analysis — Analyze Variances

Dynamic Dashboard Project — Dashboard with User Access Control

Forecast Scenario Project — Build Scenarios

P&L Automation Project — Build MIS Reports

What-If Analysis Project — More complex What-IF scenarios

PROFESSIONAL LEVEL

Power Query Project — Power Query Basic to Advanced

Variance Analysis Project — Automated Variance Analysis

Data Modelling Project — Build data model inside Excel

THE LEARNING JOURNEY

Choose Your Level - Go From Basics to Automation

LEVEL 01 · BEGINNER

Master Excel Basics

Shortcuts

Enter & Format data

Data validation, sort

Filter, copy, paste

Assignment

LEVEL 02

MIS & Visualization Expert

Functions, XLOOKUP

Multiple Criteria Lookup

Nested IFs, IFS, SWITCH

TOPN / FILTER Functions

Basic to Advanced Pivot Tables

SUMIFs, COUNTIFS

Build First MIS Project

Build a dashboard project

Dynamic dashboard with user access

Excel Forecasting Tool

Best, worst, base case scenario

Solve What-IF Scenarios

100+Problems

20Hours

10+Analysis & MIS Projects

2Dashboard Projects

LEVEL 03 · BI & AUTOMATION

Excel BI, Analytics & Automation

Excel BI Basics

How to use Power Query

How to automate data import

How to automate data cleaning

How to automate consolidation

How to build a data model

How to make reports dynamic

Basics to Advanced DAX

How to build dynamic reports

How to make dashboards automated

PROJECTS YOU BUILD

P&L Automation

Sales Analytics

Variance Analysis Automation

Trend Analysis Automation

Revenue Reporting

Spend Analysis Automation

Dynamic Forecast Scenarios

13Hours

80Lessons

10+Analysis

1Capstone

YOUR CAREER EDGE

A Course That Can Help You
Create Better Career
Opportunities.

Build Advanced Excel BI, Analytics & Automation Skills.

Stop Reporting. Start
Providing Decision Support.

FP&A›

Data Analytics›

Business Analytics›

Financial Analyst›

R2R Analyst›

Excel-Heavy MIS Roles›

CHOOSE YOUR PLAN

Choose Your Plan

Learn at your pace. Or build it live with a mentor.

Start with the complete recorded course, or upgrade for guided live workshops and hands-on support.

STANDARD · SELF-PACED

Recorded Course

Get the complete course and learn at your convenience.

₹950

20 HRSAdvanced Excel

13 HRSExcel BI & Automation

WHAT'S INCLUDED

33 Hours of Recorded Content✓

2 Certificates (project-based)✓

Lifetime Access✓

Access to Project Data & Files✓

WhatsApp Channel Access✓

Free Course Updates✓

Ask Questions via Doubt-Clearing Form✓

Monthly Community Live Call✓

ONLY FOR 3 DAYS

ENROLL LATER @ ₹1,499

Get Instant Access — ₹950 ›

Want to Learn With a Mentor?

Live Mentor Plan — build with the instructor, solve real problems and get guided support.

₹2,499 Only

33 HRSRecorded Course

2Live Workshops

LIVEHands-on Support

LIVE PLAN INCLUDES

Everything in the ₹950 Recorded Course✓

Advanced Excel Live✓

Excel Automation Build Live✓

Live Hands-on Practice✓

Clear Doubts During the Session✓

Access to Live Recordings✓

Exclusively WhatsApp Group✓

LIVE SESSION 01

Advanced Excel Live

October 3rd · Saturday

10 AM to 1 PM

Covers important functions, Pivot Tables & MIS Report

LIVE SESSION 02

Excel Automation Live

October 10th, 17th & 24th · Saturday

10 AM to 1 PM

Covers Power Query, Data Modelling, DAX & Build an Automated Dashboard

MAXIMUM 20 STUDENTS · COHORT ALMOST FULL

I Want This Plan — ₹2,499 ›

Recorded access is immediate. Live session details are shared before the sessions.

SEE THE LIVE LEARNING EXPERIENCE

See How We Build With You — Live

A real look at the guided building, problem-solving and interaction inside the cohort.

WHATSAPP COMMUNITY

DEMO VIDEO

Get Recorded Access Now @ ₹950 Complete Recorded Course Recorded + Live Session ₹2,499 Course + Guided Live Workshops

YOUR MENTOR

Learn From a Seasoned Expert

Sobhish TP

Founder, SOBH's

19+ Years Finance & Transformation Experience

Built for professionals who want to move from repetitive reporting to higher-value MIS, FP&A and automation work.

Ex Genpact2005 – 2008

Ex IBM2008 – 2024

Six Sigma Green Belt

Certified Scrum Master

Excel Automation & Power BIFP&A Expert

EARLY JOINER BENEFIT

Enroll Today and Add These
Two Bonuses to Your Course Access — FREE

BONUS #01 · VALUE ₹1,299

The Reconciliation Magic Tool
Built on Power Query

01Upload your two data sets

02Assign reconciliation keys

03See the variances immediately

BONUS #02 · VALUE ₹999

LinkedIn for Jobs
Bonus Course

Build a recruiter-friendly profile and present your skills more effectively.

₹2,298 IN BONUSES FREE WITH YOUR ENROLLMENT

CERTIFICATION

Build the Work. Earn the
Certificate.

Complete the required project and receive your certificate.

✓ Project Based ✓ 2 Certificates ✓ Showcase Your Work

STUDENT FEEDBACK

See What Students Say

OPTIONAL · EXPLORE THE FULL PROGRAM

Course Syllabus - Detailed

Detailed chapters for FP&A, Finance Analysts, Data Analysts & MIS Reporting Roles.

Level 1 — Excel Basics

Module 1: Project Files

Sessions: 1

Level 1 Assignment Sheet --

Module 2: Excel Basics

Sessions: 17 | Time: 2 hour 57 min 38 sec

1. Welcome to the Program 3 min 8 sec

2. What is Excel 4 min 10 sec

3. How to Open Excel 2 min 12 sec

4. Excel UI - Part A 7 min 25 sec

5. Excel UI - Part B 21 min 20 sec

6. Selecting Columns & Rows 11 min 31 sec

7. Entering Data 15 min 16 sec

8. Format Data 21 min 41 sec

9 Performing Basic Calculations 15 min 52 sec

10. Filter, Sort, Copy & Paste 25 min 51 sec

11. Highlight Duplicate Values 8 min 48 sec

12. Remove Conditional Formatting, Find , Replace 9 min 38 sec

13. Data Validation 7 min 39 sec

14. Fill Series 4 min 48 sec

15. Creating Hyperlinks 5 min 13 sec

16. Protect Workbook, Worksheet 6 min 43 sec

Printing Workbook & WOrksheets 6 min 23 sec

Module 3: Assessment

Sessions: 2

Level 1 Raw Data --

Level 1 Assignment Instructions --

Level 2 — Advanced Excel

Module 1: Course Introduction

Sessions: 1 | Time: 4 min 41 sec

Course Introduction 4 min 41 sec

Module 2: Before you Start

Sessions: 1 | Time: 1 min

Guidelines 1 min

Module 3: Project Files

Sessions: 1

Project Files (2) --

Module 4: Project Walk-through

Sessions: 1 | Time: 13 min 46 sec

Project Walk-through 13 min 46 sec

Module 5: Text Functions Challenges

Sessions: 8 | Time: 20 min 7 sec

1. Join Text - Create a full name column 1 min 55 sec

2. Proper - Change Name to Proper 1 min 41 sec

3. Combine Functions 3 min 20 sec

4. Trim - Remove Extra Space 3 min 8 sec

5. Right Function - Extract Location ID 2 min 26 sec

6. Left Function - Extract Employee ID 2 min 11 sec

7. Dynamic Extraction Len & left 2 min 23 sec

8. Flash Fill 3 min 3 sec

Module 6: Date Function Challenges

Sessions: 11 | Time: 19 min 21 sec

1. DATEDIF - DAYS - Calculate Average Days 3 min 22 sec

2. DATEDIF -MONTH- Calculate Months 1 min 7 sec

3. DATEDIF-YEAR- Employees Less than 1 year old 1 min 46 sec

4. Network Days - Calculate Total Working Days 2 min 58 sec

5. YEAR Function - Employees Joined in 2023 1 min 30 sec

6. MONTH - Employees joined in March'23 59 sec

7. Quarter - Employees Joined in Q1'23 2 min 3 sec

8. TEXT - Any relieving dates on Sat or Sunday 2 min 29 sec

9 How many people relieved in 2022 1 min 18 sec

10. MONTH - Number of people relieved in Nov'22 52 sec

11. Quarter - Number of people relieved in Q1'23 57 sec

Module 7: Number Function Challenges

Sessions: 3 | Time: 18 min 51 sec

1. Number Functions - Employee Working Days 5 min 49 sec

2. Number Functions - Labour Budget Summary 6 min 1 sec

3. Number Functions - Conveyance Actuals 7 min 1 sec

Module 8: Lookup Functions Challenges

Sessions: 19 | Time: 1 hour 33 min 16 sec

1. Lookup Function Intro 32 sec

2. Problem#1 - Which employee has the highest travel amount 8 min 5 sec

Problem #3 Reasons for Vlookup Errors & How to fix them 14 min 28 sec

Problem#4 Replace #NA Error with Text Value Not found 1 min 48 sec

Problem#5. What is the total Emp Count for Bangalore 4 min 32 sec

Problem#6 What is the employee count for Manager Jayan Tharakan 6 min 57 sec

Problem#7 How to use XLOOKUP to populate manager name 2 min 40 sec

Problem#8. Populate Experience Category 6 min 11 sec

Problem#9 Populate Employee Level 3 min 7 sec

Problem#10 . Populate Weekday Weeknd based on Day 4 min 22 sec

Problem#11 How to use Xlookup with Wildcard 4 min 13 sec

Problem#12 How many people are under Leader Deepesh Jain 9 min 8 sec

Problem #13 What is the average Fresher Cost Rate 4 min 35 sec

Problem#14 How to avoid creating a Temporary Lookup column 1 min 55 sec

Problem#15 How to use Xlookup to populate Cost Rate 1 min 34 sec

Problem#16 How to use Xlookukp with multiple criterias 5 min 58 sec

Problem#17 What is the Travel cost for Project PID002 5 min 2 sec

Problem#18 What is the total Labour Plan cost for PID003 4 min 38 sec

Problem#19 Calculate Monthly Labour Plan Cost 3 min 31 sec

Module 9: Logical Function Challenges

Sessions: 14 | Time: 1 hour 9 min 49 sec

Logical Functions Introduction 14 min 35 sec

Problem#1 Categorize Baselocation vs Others 2 min 47 sec

Problem #2 Category Travel as Approval Required and Not required 5 min 44 sec

Problem#3 - Calculate 2H forecast scenario 1 4 min 56 sec

Problem#4 - Populate Weekend vs Weekday in Travel 3 min 46 sec

Problem#5 - Forecast Scenario2 3 min 40 sec

Problem#6 - Forecast Scenario 3 3 min 12 sec

Problem#7 - What is the standard vs premium employee count 2 min 36 sec

Problem#8 - 2H Forecast scenario 4 5 min 22 sec

Problem#9 - How many Level 2 approval travel charges are there 1 min 52 sec

Problem#10 - Forecast Scenario 5 4 min 31 sec

Problem #11 - Categorize Conveyance Charges 4 min 28 sec

Problem#12 - Create Experience Categories 4 min 10 sec

Problem#13 Forecast Scenario6 8 min 10 sec

Module 10: Summarize Data

Sessions: 21 | Time: 1 hour 33 min 45 sec

Pivot Tables - Setting the Context 2 min 28 sec

Pivot Tables - Why do we use it 3 min 20 sec

Problem#1 - Create a summary showing Employee Count by Location 6 min

Problem#2 - What is the Avg. Experience for each role. Sort from lagest to smallest 3 min 18 sec

Problem#3 What is the average experience by role & project 5 min 7 sec

Problem#4 Modify the Pivot table to change the design 8 min 57 sec

Problem#5 What is the count of employees under each leader 6 min 3 sec

Problem#6 Active vs In-Active employee count under each leader 7 min 15 sec

Problem#7 What is the premium vs standard employee count by project 1 min 2 sec

Problem#8 How many people joined in each year b y month 4 min 22 sec

Problem#9 How many people were relieved each year by Quarter 1 min 31 sec

Problem#10 No. of people joined under each leader by year & Month 3 min 15 sec

Problem #11 - Architect role with highest average cost rate 2 min 44 sec

Problem#12 Emp Count & Avg. cost rate for Tester & DBA Roles 3 min 1 sec

Problem#13 Percentage count of employees by location 1 min 47 sec

Problem#14 Percentage of conveyance spent in 2013 4 min 25 sec

Problem#15 Other expense total & percentage for 2023 1 min 45 sec

Problem#16 Other expense 2H'22 vs 1H'23 variance & percentage 9 min 5 sec

Problem#17 Plan labour variance & percentage variance 7 min 53 sec

Problem#18 Labour Actual variance & percentage variance 8 min 42 sec

Module 11: Budget vs Actual IT Project Financial Analysis

Sessions: 32 | Time: 2 hour 59 min 58 sec

MIS Reporting Introduction 2 min 48 sec

MIS Reporting Why to use Functions for MIS Reporting 4 min 49 sec

Problem#1 Create a summary showing location wise count 5 min 2 sec

Problem#2 Create a summary showing Premium vs Standard count 1 min 42 sec

Problem#3 Populate Employee count by Location & Status 6 min 11 sec

Problem#4 Populate Employee Count & Averate Cost rate 7 min 31 sec

Problem#5 - Calculate subtotal of employee cost rate 3 min 45 sec

Problem#6 FILTER & Average to calculate Grand total Average 4 min 6 sec

Problem#7 Travel Bduget vs Actual Reporting Requirements 6 min 25 sec

Problem#8 Requirement analysis to report structure 7 min 12 sec

Problem#9 Populate the Travel budet & actual numbers 14 min 1 sec

Problem#10 how to install Power Query 5 min 52 sec

Problem#11 Designing & validation of Report 10 min 55 sec

Problem#12 Report 2 - Requirement Analysis 2 min 7 sec

Problem#13 - Understanding KPIs & Calculations 5 min 20 sec

Problem#14 - How to do your data study 9 min 50 sec

Problem#15 - How do you structure your report 4 min 17 sec

Problem#16 - Extract source data into calculation file 6 min 32 sec

Problem#17 - Clean & Transform Budget Revenue 8 min 11 sec

Problem#18 - Clean & Transform Revenue Actuals 2 min 31 sec

Problem#19 - Clean & Transform Labour Plan Data 5 min 36 sec

Problem#20 - Clean & Transform Labour Actual 5 min 11 sec

Problem#21 - Clean & Transform Travel Plan 3 min

Problem#22 - Clean & Transform Travel Actuals 59 sec

Problem#23 - Clean & Transform Other Expenses Plan 1 min 49 sec

Problem#24 - Clean & Transform Other Exp Actuals 2 min 21 sec

Problem#25 - Populating the numbers with SUMIFs 12 min 57 sec

Problem#26 - Complete Remaining calculations 1 min 56 sec

Problem#27 - Calculating QTD and YTD Numbers 1 min 55 sec

Problem#28 - Enabling ALL FILTER for Project ID 7 min 55 sec

Problem#29 - Formating the Report 12 min 39 sec

Problem#30 - Final Validation 4 min 33 sec

Module 12: Headcount Status Dashboard

Sessions: 19 | Time: 2 hour 14 min 40 sec

Dashboard Introduction 2 min 7 sec

Two different approaches to Dashboard Building 1 min 43 sec

Dashboard Creation Process 1 min 20 sec

Dashboard Creation - Client Requirements 1 min 23 sec

Problem#1 - Analyze Client requirements 8 min 26 sec

Problem#2 - What is a wireframe and why to create it 5 min 24 sec

Problem#3 - How to create Pivot Table summaries 16 min 8 sec

Problem#4 - How & why to create a story board 6 min 50 sec

Problem#5 - Create your Charts 8 min 24 sec

Problem#6 - Which chart to choose when 17 min 2 sec

Problem 7 - Format the chart elements 17 min 20 sec

Problem#8 - Arrange Charts in Dashboard Layout 7 min 58 sec

Problem 9 - Making the alignments right 1 min 57 sec

Problem#10 - Create KPI Cards 3 min 42 sec

Problem#11 - How to format your first chart 5 min 28 sec

Problem#12 - How to use Templates 7 min 20 sec

Problem#14 Format KPI Visuals 6 min 57 sec

Problem#15 - Create a Project Lead Slicer 11 min 2 sec

Problem#16 - Final Changes 4 min 9 sec

Module 13: Course Wrap up

Sessions: 1 | Time: 1 min 1 sec

Course Wrap up 1 min 1 sec

Module 14: Excel Dynamic Dashboard

Sessions: 15 | Time: 2 hour 37 min 9 sec

1. Requirement Analysis 4 min 30 sec

2. Study Data & KPI Calculations 5 min 5 sec

3. Prepare Employee Data 7 min 36 sec

4. Prepare Travel Data 14 min 16 sec

5. Create Calculation Sheet Part 1 10 min 29 sec

6.Calculation Sheet Employee Data Part 2 6 min 26 sec

7. Calculation Sheet Travel Part 1 12 min 48 sec

8. Calculate Forecast Figures 3 min 26 sec

9. Calculation Sheet Travel Continued 8 min 40 sec

10. Creating Charts 5 min 16 sec

11. Finalizing Headcount Dashboard 16 min 1 sec

12. Finalizing Travel Dashboard 10 min 25 sec

13. Finalizing Travel Dashboard Part B 15 min 30 sec

14. Setting up Access Control 17 min 13 sec

15. Setting up Access Control Part B 19 min 28 sec

Module 15: Excel Finance Modules

Sessions: 26 | Time: 3 hour 8 min 50 sec

Files --

1. Dataset Introduction 4 min 12 sec

2. Prepare Calculation Sheet 21 min 49 sec

3. Creating a new Amount column 3 min 33 sec

4. Structuring Income Statement 12 min 10 sec

5. Formatting Income Statement 7 min 54 sec

6. Income Statement Verticle Analysis 13 min 9 sec

7. Formatting Verticle Analysis 6 min 18 sec

8. Income Statement Horizontal Analysis 5 min 20 sec

9. Verticle Analysis Conditional Formatting 8 min 10 sec

10. Trend Analysis 7 min 26 sec

11. Trend Analysis Formatting 6 min 3 sec

12. Operating Expense Budget vs Actual Analysis Part A 8 min 30 sec

13. Operating Expense_Budget vs Actual_Formatting 7 min 47 sec

14. Excel Forecasting Function Part A 7 min 5 sec

Excel Forecasting Function Part B 8 min 8 sec

Best case worst case and base case scenario Template --

Forecasting Basecase, Bestcase and Worstcase Scenarios - Part 1 4 min 13 sec

Forecasting Basecase, Bestcase and Worstcase Scenarios - Part B 11 min 26 sec

Forecasting Basecase, Bestcase and Worstcase Scenarios - Part 3 6 min 31 sec

Forecasting Basecase, Bestcase and Worstcase Scenarios - Part 4 3 min 39 sec

Forecasting Basecase, Bestcase and Worstcase Scenarios - Part 5 13 min 9 sec

Goal Seek 4 min 42 sec

Data Table 9 min 8 sec

Solver 7 min 30 sec

Course Wrap up 58 sec

Level 3 — FP&A / MIS Automation

Introduction

Sessions: 4 | Time: 12 min

1. Session Introduction 3 min 31 sec

2. How this learning is organized 2 min 24 sec

3. Excel BI Framework 5 min 5 sec

Instructions (Important) 1 min

Project Data Files (Download)

Sessions: 1

Project Files

Get Data

Sessions: 3 | Time: 18 min 9 sec

4. Getting Data into Excel 3 min 51 sec

5. Extracting first data file into Excel 5 min 38 sec

6. Load Data & save 8 min 38 sec

Power Query - Import Data

Sessions: 9 | Time: 1 hour 36 min 13 sec

7. Power Query UI Overview - 1 7 min 3 sec

8. Power Query UI Overview -2 12 min 45 sec

9. Power Query UI Overview - 3 8 min 50 sec

10. Power Query UI Overview -4 7 min 19 sec

11. Power Query UI Overview -5 12 min 7 sec

12. Power Query UI overview -6 3 min 37 sec

13. Power Query Applied Steps 15 min 33 sec

14. Power Query Import Project Data 21 min 1 sec

15. Import Sales data from folder 7 min 53 sec

Power Query - Transform Data

Sessions: 14 | Time: 1 hour 48 min 22 sec

16. Project Data Transformation -1 9 min 7 sec

17. Project Data Transformation -2 15 min 21 sec

18. Project Data Transformation 3 4 min 27 sec

19. Project Data Transformation -4 5 min 51 sec

20. Project Data Transformation-5 4 min 58 sec

21. Project Data Transformation-6 7 min 52 sec

22. Project Data Transformation-7 6 min 44 sec

23. Project Data Transformation-8 10 min 26 sec

24. Project Data Transformation-9 9 min 48 sec

25. Project Data Transformation-10 4 min 6 sec

26. Project Data Transformation-11 7 min 58 sec

27. Data Transformation - Merge Queries 5 min 43 sec

28. Data Transformation - Group Data 6 min 29 sec

29. Data Transformation Append 9 min 25 sec

Data Modelling

Sessions: 5 | Time: 1 hour 14 min 33 sec

30. Data Modelling Introduction 15 min 39 sec

31. Data Modelling Fact & Dimension Tables 14 min 22 sec

32. Data Modelling Primary & Foreign Keys 12 min 1 sec

33. Data Modelling Connecting Tables 26 min 11 sec

34- DAX & Reporting - Introduction 6 min 19 sec

DAX & Financial Reporting & Analysis

Sessions: 50 | Time: 8 hour 20 min 36 sec

34- DAX & Reporting - Introduction 6 min 19 sec

35. DAX & Reporting - Creating a Measure 12 min 54 sec

36. DAX & Reporting - Aggregation Measures 10 min 34 sec

37. DAX & Reporting- Aggregation Funtions Part B 25 min 30 sec

38. DAX & Reporting - Text , Date Functions 20 min 9 sec

39. DAX & Reporting - The Filter Context 7 min 19 sec

40. DAX & Reporting -GST Caculation with Iterative function 10 min 7 sec

41. DAX & Reporting - Iterative function measure 7 min 21 sec

42 DAX & Reporting - Forecast model with Iterative Function 16 min 22 sec

42. DAX & Reporting- Forecasting Model with Iterative _ Part B TBD

43. DAX & Reporting - Forecast bast & base case scenarios 14 min 37 sec

44. DAX & Reporting - Creating a disconnected table 9 min 31 sec

45. DAX & Reporting- Dynamic Toggle Button 12 min 3 sec

46 DAX & Reporting - Handling Default State in measure 4 min 59 sec

47. DAX & Reporting - Using SWITCH for Scenarios 9 min 42 sec

48. DAX & Reporting - Dynamic Forecast with VALUES & HASONEVALLUE 21 min 43 sec

49. DAX & Reporting- Changing Filter Context with Calculate 12 min 40 sec

50. DAX & Reporting- Calculate with multiple filters 2 min 24 sec

51 DAX & Reporting - Sales Trend Analysis against Q4'23 10 min 3 sec

52. DAX & Reporting- Sales Trend Analysis against Q4'23 Avg Part B 6 min 36 sec

53. DAX & Reporting - Formatting Sales Trend Analysis 10 min 21 sec

54. DAX & Reporting - Opex Spend Analysis Part A 1 min 37 sec

54. DAX & Reporting - Opex Budget vs Actual Analysis - Part B 14 min 21 sec

54. DAX & Reporting - Opex vs Actual Variance Analysis Part C 10 min 19 sec

55 DAX & Reporting - P&L Reporting Automation - Part A 10 min 3 sec

56. DAX & Reporting - Chart Accounts, P&L KPIs, Opening Stock 18 min 41 sec

57 DAX & Reporting - Opex, EBITDA, EBIT, Net Margin Calculation 14 min 25 sec

58. DAX & Reporting- Formatting P&L Report 13 min 6 sec

59 DAX & Reporting - Analyzing Revenue Drop PVM Analysis 16 min 10 sec

60 DAX & Reporting - Price Volume Impact Analysis - Part B 10 min 57 sec

61 DAX & Reporting- Formatting PVM Analysis 16 min 4 sec

62 DAX & Reporting- Fomatting PVM Analysis Part B 2 min 25 sec

63. DAX & Reporting- Analyzing EBITDA Drop 5 min 42 sec

64. DAX & Reporting- Opex BvM Analysis 2 min 13 sec

65. DAX & Reporting - Opex Spend Ratio Analysis 4 min 11 sec

66. DAX & Reporting- Opex Category Ratio Analysis 12 min 34 sec

67. DAX & Reporting- Opex to Revenue Analysis 8 min 17 sec

68. DAX & Reporting- Opex Monthly Budget vs Actal to Budget % 9 min 21 sec

69. DAX & Reporting - Opex Spend Deep dive 3 min 50 sec

70. DAX & Reporting - Formatting Opex Analysis 5 min 43 sec

71 DAX & Reporting - Opex Analysis - Change number formats 3 min 50 sec

72 DAX & Reporting - Opex Reporting Formatting Continued 7 min 46 sec

73 DAX & Reporting - Opex Spend Report - Finalizing 4 min 25 sec

74 DAX & Reporting - Revenue Mix Analysis 13 min 57 sec

75 DAX & Reporting - Revenue Mix Analysis Formatting 7 min 10 sec

76 DAX & Reporting - Revenue Mix Analysis Precentage performance 4 min 24 sec

77. DAX & Reporting- Addressing Challenges with ALL Filter 13 min 24 sec

78 DAX & Reporting - Analyzing Product Sales Drop 11 min 39 sec

79 DAX & Reporting- Analyzing YTD Budget vs Actual 17 min 41 sec

80 DAX & Reporting- Year over Year Analysis 4 min 44 sec

FAQ

Questions Before You Enrol?

The answers that matter before you enrol.

Will I get immediate access to recorded videos if I enroll in the Live Session?

Yes. You get immediate access to the recorded course, so you can start learning right away.

Where do I watch the course?

You will receive access to your LMS platform to watch the course.

Is this lifetime access?

Yes. You get lifetime access to the course.

Can I watch a video multiple times?

Yes. You can watch the videos multiple times.

Are project files to practice included?

Yes. Project files are included under the respective section.

How is this different from YouTube videos and other courses?

Real data, structured learning and real MNC problems, built from my experience working in MNCs like IBM and Genpact, doing leadership reporting roles and automating my work.

Where do I contact for any support?

You can contact us at hellosobhs@gmail.com.

What software do I need?

Windows & Excel 2016 or later. Mac / iPhone are not supported.

Is there a refund policy?

You can request a refund within 7 days of purchase.

3 MORE DAYS LEFT

GET THIS OFFER BEFORE IT EXPIRES

Build the Skills.
Unlock the Opportunity.

Advanced Excel Course · 20 HRS · MNC Grade₹1,299

Excel Automation · Reporting Efficiency₹1,999

The Reconciliation Magic Tool · Bonus₹1,299

LinkedIn for Jobs · Bonus Course₹999

Monthly Community CallsINCLUDED

Lifetime AccessINCLUDED

FREE Course UpdatesINCLUDED

TOTAL COURSE VALUE

₹5,596+

ONE-TIME INVESTMENT

₹950 3 MORE DAYS LEFT

ENROLL NOW — ₹950

WANT THE PREMIUM EXPERIENCE?

Get Premium Membership

Just ₹1,549 extra

2 Live Sessions · 12 Hours Build Automation Confidence Learn With Guided Hands-on Support

CHOOSE LIVE PLAN — ₹2,499

₹950 · RECORDED ₹2,499 · LIVE + RECORDED

Excel Built for Reporting Efficiency

Your Journey

Excel Basics

MIS & Dashboards

Power Query

Data Modelling

DAX

Dynamic Reports

Automated Dashboard

Build the Work — Not Just Watch the Lessons

Choose Your Level - Go From Basics to Automation

Master Excel Basics

MIS & Visualization Expert

Excel BI, Analytics & Automation

A Course That Can Help YouCreate Better CareerOpportunities.

Stop Reporting. StartProviding Decision Support.

Choose Your Plan

Recorded Course

Want to Learn With a Mentor?

Advanced Excel Live

Excel Automation Live

See How We Build With You — Live

Learn From a Seasoned Expert

Sobhish TP

Enroll Today and Add TheseTwo Bonuses to Your Course Access — FREE

The Reconciliation Magic ToolBuilt on Power Query

LinkedIn for JobsBonus Course

Build the Work. Earn theCertificate.

See What Students Say

Course Syllabus - Detailed

Questions Before You Enrol?

Build the Skills.Unlock the Opportunity.

Get Premium Membership

A Course That Can Help You
Create Better Career
Opportunities.

Stop Reporting. Start
Providing Decision Support.

Enroll Today and Add These
Two Bonuses to Your Course Access — FREE

The Reconciliation Magic Tool
Built on Power Query

LinkedIn for Jobs
Bonus Course

Build the Work. Earn the
Certificate.

Build the Skills.
Unlock the Opportunity.