IT Courses – Advanced Microsoft Excel

Extend your knowledge of Excel’s advanced features and learn how to perform more complex tasks. This workshop will help put the full power and potential of Excel at your fingertips.

You must already have a good understanding of Excel’s key features. 

Course content 

Functions and Formulas

• IF Statements
• Nesting functions
• Lookup and referencing functions: VLOOKUP, HLOOKUP and XLOOKUP
• INDEX and MATCH

Creating Dashboards

• Working with Excel Tables
• Using slicers with Excel tables
• Create an Excel Table-based dashboard
• Creating a PivotTable based dashboard

An Introduction to Macros

• Understanding Macro security
• Recording a Macro
• Assigning a Macro to Command Button
• Assigning a Macro to a Quick Access Toolbar

Understanding Power Query

• Exploring the benefits of Power Query
• Important data
• Understanding transformation techniques in Power Query

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

The course will be delivered on-site.

For more information, contact dcgprofessional@dcg.ac.uk