Course overview
1. Introduction
1 min
2. Resource - Excel Files
6 resources
Resources File 1
Resources File 2
Resources File 3
Resources File 4
Resources File 5
Resources File 6
3. Excel Fundamentals and Nuances
1 hr
Introduction to Spreadsheets & Understanding versions of Excel
Understand the concepts of Dates in Excel (Dateing Tips!)
Dateing Tips(PDF)
Learning Find & Replace Utility and Paste Special Dialogue Box in Excel
Find & Replace
Combine and Organise Text data for an NGO
Text date for NGO
Dollar Signs: Cell Referencing
Dollar Signs
4. Data Cleaning
50 mins
Analyse B-school Campus Data
Analyse B-school Campus Data
Clean Mobile Numbers
Clean Mobile Numbers
Clean Data Pasted from PDFs
Clean Data Pasted from PDFs
Data Cleaning & Analysis
5. Excel Formulas & Utilities
1 hr
Analyse Loan Data
Ethos of Financial Modelling
Formulas Tab and Go To Special
Modern Data Cleaning Functions
Dashboarding using INDIRECT function
VBA & Programming in Excel
VBA & Programming in Excel - Power Pivot
6. Dynamic Arrays, Key & Lookup Functions
2 hrs
Dynamic Arrays and the New Excel Calculation Engine
Dynamic Arrays and the New Excel Calculation Engine
Level 1 Lookups
Level 1 Lookups
Level 2 Approximate Lookups
Level 2 Approximate Lookups
Level 3 Multi-Lookup
Level 3 Multi-Lookup
Level 4 3D lookups
Level 4 3D lookups
Level 5 Resolving 3D lookups and Problem of Array of Arrays
Level 5 Resolving 3D lookups and Problem of Array of Arrays
Lookup
Approximate Lookups
3D Lookup
Multi-Lookup
7. Data Analysis
2 hrs
How to make charts & Visualize the Data
How to make charts & Visualize the Data
Analyse Organisational Data - Level 1
Analyse Organisational Data - Level 1
Analyse Organisational Data - Level 2
Analyse Organisational Data - Level 2
Functional Programming & Basics of Lambda Function
Functional Programming & Basics of Lambda Function
Advance use cases of Lambda Function
Advance use cases of Lambda Function
Automating Data Analysis using the latest & modern functions in Excel
Automating Data Analysis using the latest & modern functions in Excel
Dashboarding using Modern Excel Functions
Dashboarding using Modern Excel Functions
Data Visualization
Lambdas
Dashboarding
8. Power Query
1 hr
Basics of Power Query
M - Language & Introduction to Regex
Joins in Power Query/SQL and Copilot
Power Query
9. VBA & Programming in Excel
1 hr
VBA Macros - Level 1
VBA Macros - Level 2
VBA Macros - Level 3
Power Pivot
10. AI in Excel
1 hr
Python in Excel
AI - Microsoft Copilot in Excel
Creating the right MS Excel Ecosystem
AI - Microsoft Copilot in Excel
Using AI Effectively in Excel
11. Consulting Case Studies
2 hrs
Courier Company Turnover Analysis
Build Dashboard for NIFTY 50 Stocks
Building Split wise in Excel
Converting Annual Numbers to Monthly for Budgeting Model
Reverse Lookup
Solving School Teacher's Problem statement using Excel
Analyse Mutual Fund Scheme Portfolios
Compute YTD numbers and Payback Period
AI in Excel - Python in Excel
