Advanced Excel course
Modern Excel built on more than 10 years of real-world Excel solutions.
The course covers modern Excel tools and capabilities - PowerPivot, Power Query and Office 365 array functions. Every topic is prepared through ongoing client work solving real problems, and the modules are assembled to fit your needs.
Course goal
Learn modern Excel tools and capabilities - PowerPivot, Power Query and Office 365 array functions - through tasks prepared from real client problems.
Who it is for
The course structure adapts to both advanced and beginner users depending on the topics chosen. Participants can be individuals or a whole department within a company.
Notes
- Topics are modular and combined to fit the participants.
- We no longer offer VBA training - Power Query is recommended as the modern alternative for automating data processing.
- The course is held in person or online (Teams, Skype, Zoom).
Course content
Formulas and data entry
- The concept of functions and the golden rule of entering formulas.
- Absolute vs relative referencing, copying formulas.
- Shortcuts and tricks for faster entry and navigation.
Excel tables and lookup functions
- The difference between ranges and tables, and referencing inside tables.
- Table functions: SUMIFS, SUBTOTAL, SUMPRODUCT.
- Lookup functions: VLOOKUP, XLOOKUP, INDEX and wildcard lookups.
PivotTables and PivotCharts
- Optimal data structures and how PivotTables work.
- 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 and time intelligence.
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 modern 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 advanced Excel 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 Advanced Excel course.
A selection of the domestic and international clients we have worked with.
