A focused Excel course designed for MBA students to build proficiency in core functions and tools used for handling and analyzing business data. The course covers essential concepts required to work efficiently with datasets and perform structured analysis using Excel.

USP (Key Highlights)

1. Covers only essential Excel concepts relevant for MBA coursework
2. Function-focused learning with clear understanding of usage
3. Structured progression from basics to application

Curriculum Breakdown

1. Referencing in Excel

1. Relative Reference
2. Absolute Reference ($ sign to fix row & column)
3. Mixed Reference (Hybrid/Composite)

2. Data Handling

1. Data Split
2. Data Validation

3. Logical Functions

1. IF
2. Nested IF
3. IFS

4. Lookup Functions

1. VLOOKUP
2. HLOOKUP
3. INDEX + MATCH

5. Conditional Functions

1. COUNTIFS
2. SUMIFS
3. AVERAGEIFS
4. MINIFS
5. MAXIFS

6. SUM-PRODUCT Use Cases

7. Number Formatting

8. Pivot Table

9. Business Case Study

10. Dashboard

Add-On (Limited Access Resources)

1. Get access to the exact practice sheets used during the session
2. A curated Excel shortcut manual to significantly speed up your workflow
3. MBA-ready Excel templates that are typically used in projects and internships