The analyst's first tool. Master it for data. Turn Excel into a powerful data-analysis engine with formulas, PivotTables and more.
Hands-on with real business data — formulas, lookups, PivotTables, charts and Power Query for serious analysis.
From SUMIFS to XLOOKUP — let Excel do the work.
Summarise thousands of rows in seconds.
Clean and combine data automatically.
Microsoft Excel for Data Analysis turns the world's most familiar tool into a genuine analysis engine. Working on real business data, you'll master analytical formulas and lookups, PivotTables and PivotCharts, data cleaning with Power Query, and dashboards — the practical data skills that make Excel a powerhouse and a springboard to Power BI.
Basic Excel helps! If you can enter data and simple formulas, you're ready. Ideal for analysts and anyone who works with spreadsheets.
Earn the "Excel Data Analyst" badge upon completing all modules and the hands-on final assessment.
Verifiable CredentialClean tables, formatting and good data habits.
SUMIFS, COUNTIFS, XLOOKUP and INDEX/MATCH.
Summarise, group and visualise data fast.
Import, clean and combine data automatically.
Build an interactive analysis dashboard.
Analyse business data confidently in Excel.
Build dashboards and reports that inform.
Turn spreadsheets into decisions.
A natural stepping stone to Power BI.
It is taught on Microsoft 365, and everything applies to recent desktop versions (2019 and later). We highlight any differences, including Power Query availability.
No — if you can enter data and use simple formulas, you're ready. We build the analytical skills from there on real business data.
To receive the Edmire Excel Data Analyst Certificate, complete all 5 modules and the capstone — an analysis dashboard built on a real dataset. Resubmission is free if needed.
This course focuses specifically on data analysis — analytical formulas, PivotTables, Power Query and dashboards — rather than general Excel use. It's aimed at turning data into insight.
Classroom training at our Dubai centre, live online instructor-led classes, or custom in-house delivery — with all materials yours to keep.
Fill out the form below and we'll get back to you shortly.