From foundational formulas to advanced PivotTables, dynamic arrays and data analysis — built around your team's actual spreadsheets and business scenarios.
Practical Excel skills that save hours every week — built from your team's real workbooks.
Confidently use IF, IFS, SUMIFS, COUNTIFS, AVERAGEIFS and nested logic to automate calculations across large datasets.
Replace VLOOKUP with XLOOKUP, INDEX/MATCH and FILTER to retrieve data accurately from multiple tables and sheets.
Summarise thousands of rows in seconds, slice by any dimension and build dynamic charts that update automatically.
Use SORT, FILTER, UNIQUE, SEQUENCE and SPILL to build reports that automatically expand when new data is added.
Build clear, professional charts — combo charts, waterfall, funnel, sparklines — formatted to presentation standard.
Create dropdown lists, enforce data entry rules, protect sheets and cells so workbooks stay accurate and consistent.
Anyone using Excel for reporting, data entry, analysis or financial modelling.
MIS reports, budget templates, variance analysis
Data consolidation, dashboards, reporting automation
Pipeline tracking, target vs achievement, territory analysis
Production data, inventory, scheduling and tracking
Headcount, payroll, attendance and training reports
Six modules covering every level of Excel — from foundations to advanced data analysis.
Trainer at your premises. Hands-on labs using your own Excel workbooks and datasets. Most popular format.
Instructor-led via Teams. Participants share screens for one-on-one guidance during hands-on exercises.
In-room and remote participants together. Works well for organisations with teams across multiple offices.
Pradip has trained 25,000+ professionals on Excel across pharma, FMCG, manufacturing and financial services. He is well known for making advanced Excel concepts accessible — using the participant's own workbooks so every skill learnt can be applied the very next day at work.
We use your team's actual Excel workbooks and reporting scenarios — so participants learn by solving their real day-to-day challenges.
