Advanced Excel

Go beyond formulas: XLOOKUP, dynamic arrays, Power Query, DAX, dashboards and VBA macros.

Advanced Excel takes you from everyday formulas to the tools professionals use to automate reporting. Learn advanced lookups and dynamic arrays, clean and combine data with Power Query, model data with Power Pivot and DAX, build interactive dashboards, and automate a monthly report with VBA. Every lesson has a live practice sheet, exercise files and a PDF cheat sheet, and the course ends with its own certificate.

What you will learn

• Use XLOOKUP, INDEX MATCH and multi-criteria lookups
• Work with dynamic arrays: FILTER, SORT, UNIQUE and LET
• Clean, reshape and combine data with Power Query
• Build a data model and write DAX measures
• Create advanced pivot tables, charts and slicers
• Design interactive Excel dashboards with KPI cards
• Record and write VBA macros
• Build an automated monthly report

Who this course is for

• Professionals who already use Excel and want to level up
• MIS and data analysts who want to automate reports
• Anyone building dashboards for managers

Price: ₹1,799. One payment, no subscription.

All Excel courses