Excel Workshop: Learn the basics

Speaker: Chinmaya Amte (Ex-EY, Speaker at 5 IIMs)

Disclaimers / To-Dos

The participants need to have access to a laptop with a Microsoft 365 subscription. You can check out the link here: www.office.com. You can get 1-month free access based on a credit card. This is needed for formulas like TEXTBEFORE, TEXTAFTER, and TEXTSPLIT.

Mac and work laptops may have restrictions on the installation of add-ins, etc.

About this Workshop
This Excel workshop is designed as a strong foundational program for students and early professionals who want to become confident with Excel basics before moving into advanced tools.

It focuses on the core Excel skills used in everyday corporate work.

You will learn:

1. Excel fundamentals - How to clean and structure raw data using essential spreadsheet techniques

2. Key formulas and functions like TEXT tools, AVERAGE, MIN/MAX, COUNTIFS, SUMIFS, and IF

3. Lookup fundamentals including VLOOKUP vs XLOOKUP and common real-world errors

4. Practical productivity tools like Conditional Formatting, Find & Replace, Paste Special, and Go To Special

5. Sorting, filtering, Excel Tables, and formatting workflows used in reports and analysis

6. Building accuracy, speed, and strong spreadsheet habits through hands-on practice

The workshop ends with simple real-life business case exercises to apply everything learned.

This is the perfect starting point for anyone who wants to master Excel basics before progressing to advanced topics like Power Query, VBA, Python, or AI automation.