top of page
Advanced Microsoft Excel Training
Ready to take your Microsoft Excel skills to the next level? This advanced course will help you master Excel's more powerful and practical features, enhancing your expertise and efficiency.
You'll dive deeper into creating dynamic, functional spreadsheets tailored to boost productivity in the workplace and beyond.
From advanced data analysis to automation techniques, this course equips you with the knowledge and skills to confidently tackle complex tasks.
What will you learn?
01
Functions and Formulas
-
IF Statements
-
Nesting functions
-
Lookup and referencing functions: VLOOKUP, HLOOKUP and XLOOKUP
-
INDEX and MATCH
03
An Introduction to Macros
-
Understanding Macro security
-
Recording a Macro
-
Assigning a Macro to Command Button
-
Assigning a Macro to a Quick Access Toolbar
05
Working with PowerPivot
-
Understanding and assigning Relationships
-
Working with data models and schemas
-
Creating measures and calculated columns using DAX
-
Building PowerPivot reports from data models
02
Creating Dashboards
-
Working with Excel Tables
-
Using slicers with Excel tables
-
Create an Excel Table-based dashboard
-
Creating a PivotTable based dashboard
04
Understanding Power Query
-
Exploring the benefits of Power Query
-
Important data
-
Understanding transformation techniques in Power Query
How can you learn?
Want to book? Get in touch today!
bottom of page