IT Courses – Advanced Microsoft Excel
This one-day workshop is designed to give individuals who already have a good understanding of Excel's key features the opportunity to learn more advanced skills.
Course Summary
Course Information for Students
Who is this course for?
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.
Entry Requirements
You must already have a good understanding of Excel’s key features.
What will you learn?
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
How will you learn?
The course will be delivered on-site.
What will you need to bring with you?
How will you be assessed?
Where next?
Who do you contact for more information?
For more information, contact dcgprofessional@dcg.ac.uk
Course Information for Employers
Information for Employers
Career Information
This course could lead to one of these careers...
£0
Bank and Post Office Clerks
£24776
£0
Local Government Administrative Occupations
£23997
Sales Administrators
£23972
Financial Administrative Occupations
£22154
Other Administrative Occupations
£19423
Officers of Non-governmental Organisations
£22297
School Secretaries
£20468
£0
Teachers of English as a Foreign Language
£36091
Pensions and Insurance Clerks and Assistants
£22006
DCG Success Stories
Discover how our students have achieved success. Their hard work and dedication to learning has enabled them to succeed in rewarding careers or progress onto higher education.
We encourage progress and aspirational outcomes by guiding people onto learning pathways that lead to positive destinations. Our students have gone on to achieve great things since leaving the College. We would like to share some of their inspiring success stories with you.
Course Information Last Updated On: July 18, 2025 9:26 am
