Excel for data analysis
A focused analytical Excel course for structured and unstructured data.
A 16-hour program covering 10 key chapters of modern analytical Excel - including modern technologies such as Power Query and PowerPivot. Office 2016 minimum (Office 365 recommended).
Course goal
Across 10 chapters, master modern analytical Excel - from data entry and formulas to PowerPivot, Power Query and dynamic array functions.
Who it is for
Professionals across sectors who work with data analysis: financial controllers, analysts, HR managers, and procurement and sales teams.
Notes
- The course is available in person or online (Teams, Skype, Zoom).
- Office 2016 minimum is required; Office 365 is recommended.
Course content
Data entry and formulas
- How Excel stores data, backend vs frontend formatting.
- The concept of functions, the golden rule of entry, and absolute vs relative referencing.
Excel tables and lookup functions
- The difference between ranges and tables, filtering and referencing.
- Table functions: SUMIFS, SUBTOTAL, SUMPRODUCT.
- Table-joining logic: VLOOKUP, XLOOKUP and wildcard lookups.
PivotTables and PivotCharts
- Core mechanics and optimal data structures.
- Linking multiple PivotTables via a Slicer, Summarize vs Show values as.
- PivotCharts working together with Slicers.
PowerPivot
- The data model and its advantages over a classic Pivot.
- DAX basics: calculations vs columns, time intelligence and combining calculations.
Power Query
- Importing and combining sources (Excel, TXT, SQL, Web).
- Automating processing and advanced transformations.
- Introduction to the M language.
Dynamic array functions
- Why array functions are a revolution in analytical Excel.
- Core functions: FILTER, UNIQUE, SORT and combining them.
Why choose us?
We have run 60+ training sessions and share knowledge built over 10+ years of working with Power Query and DAX - we have used Power BI since its 2015 launch. Alongside training we actively deliver implementations (60+ successful projects), so we stay current with the whole ecosystem.
Get in touch with any questions about the Excel for data analysis course and request an offer.
Request an offer
Krešimir Ledinski
Microsoft Certified Trainer (MCT) and Power Platform consultant. He has taught Power BI, Power Query and DAX for more than 8 years, and has worked with Microsoft data tools for over 10 - across 60+ system implementations on Power BI, Fabric and the Power Platform. He knows data modeling, DAX and M programming inside out, as well as where Power BI fits in the wider data stack, and was an early adopter of AI/LLMs in modern data solutions. In his courses he ties theory to real projects from FMCG, finance and retail, so attendees leave with knowledge they can apply right away.
View profile →Courses most often taken alongside this one
Request an offer
Tell us what you need and we'll get back to you shortly. We'll know your message is about Excel for data analysis.
A selection of the domestic and international clients we have worked with.
