Skill Details

View Skill (Open Access)

Skill Details

Skill Name

Skill Category

Is Accredited

NoYes

Is Apprenticeship

NoYes

Skill Overview

Master your data and take your Excel expertise to the next level with our Excel Advanced: Master Data training course.

Designed for confident users, this course will show you how to unlock Excel's most powerful features for analysing, reporting, and managing data efficiently. You 'll gain practical skills in advanced formulas, lookups, PivotTables, auditing tools, and macros - all aimed at helping you work smarter, reduce errors, and create professional, insightful reports.

Whether you're working with complex spreadsheets, dynamic datasets, or repetitive tasks, this course equips you with the tools to take full control of your data and boost your productivity.

Learning Objectives

Setting Up for Success
- Recap of Intermediate Excel tools and techniques
- Showcase of advanced reports and advanced analytical examples
- Understanding your current data challenges and learning goals

Advanced Functions
- Nested IF statements with AND, OR, ISERROR and IFERROR
- SUMIF and SUMIFS for conditional totals
- COUNTIF and COUNTIFS for counting with conditions

Date Functions
- DATEDIF and other advanced date calculations
- Combining date functions with formulas

Lookup and Information Functions
- Advanced VLOOKUP and XLOOKUP
- Creating multi-column lookups
- MATCH, INDEX, and OFFSET for dynamic referencing

Advanced List Management
- Using Advanced Filter
- Database functions
- Creating and managing Subtotals
- Outline view for grouped data

Advanced Pivot Tables
- Calculated Fields
- Changing Value Field Settings
- Grouping by date and number
- Formatting PivotTables
- Show Values As % of Total, Row, Column
- Building PivotCharts and interactive reports with Slicers and Timelines

General Analysis Tools
- Scenarios
- Custom Views
- Goal Seek
- Solver
- One and Two Input Data Tables

Protecting and Sharing Workbooks
- Sharing files and tracking changes
- Protecting cells and worksheets
- Password protecting files or read-only access

Formula Auditing
- Formula view and tracing precedents/dependents
- Using the Watch Window
- Go To Special for troubleshooting

Introduction to Macros
- Enabling and displaying the Developer Tab
- Recording and saving Macros
- Absolute vs. Relative Macros
- Introduction to Form Controls and Macro buttons

Reflections & Planning
- Recap key takeaways from the course
- Discuss how tools apply to your role and workflow
- Identify further beneficial tools

Funding Option

Funding Eligibility

Skill Price ex VAT (£)

Skill Length

Skill Level

Skill Timings

Delivery Method

Skill Eligibility (Prerequisites for skill/software requirements)

This course is ideal for:
- Experienced Excel users ready to deepen their knowledge
- Those working with large datasets or complex spreadsheets
- Learners progressing from our Excel Intermediate: Build Better Reports course

Prerequisites: Delegates should already be confident with Intermediate Excel functionality, including creating and editing formulas (such as IF, AVERAGE, and COUNTIF), using absolute and relative cell references, applying basic data tools like Sort, Filter, and Conditional Formatting, and working with charts and tables. We recommend completing our Excel Intermediate course, or having equivalent experience, before attending.

Last Application Date

Skill Enrolment

Skill Status

Skill Enquiry Details

First Name

Last Name

Telephone

Postcode

Are you a company owner or senior decision maker?

NoYes

No. of Delegates

What is your company name?

Would you like to explore skills support for your organisation through GM Business Growth Hub?

NoYes

I accept the Terms and Conditions and Privacy Policy

NoYes

Skill