Take your skills to the next level to get more out of Excel’s advanced features, including PivotTables and Data Consolidation. You will also build on your existing knowledge by exploring worksheet and workbook protection. Work on spreadsheet automation by recording macros, then edit your macros for even greater functionality and flexibility.

This course is designed for participants who are already building more complex spreadsheets and wish to perform more detailed analysis as well as adding automation to their workbook tasks.

This is an advanced level course.

What you get

• Class size kept to a maximum of 10 participants.
• Average class is 4-6 people.
• Qualified, experienced and approachable facilitators.
• Training materials and take away practice files.
• Lifetime post course support.

We encourage you to bring along your own laptop so you are familiar with its layout and functionality. If you do not have a laptop, we can supply one on the training day.

Microsoft Excel Advanced Workshop Course Content

Data Consolidation

• Linking to Source Data
• Consolidate by Position
• Consolidate by Category

Creating PivotTables

• Building a PivotTable Shell
• Adding Fields
• Grouping Items
• Filtering
• Drilling Down
• Changing Layouts
• Using Slicers

Advanced PivotTable Features

• Creating Calculated Fields
• GetPivotData Function
• Show Report Filter Pages

Recording Macros

• Preparing Excel for Recording
• Recording Macros
• Storing Macros
• Adding Comments
• Testing Macros

Absolute vs Relative Macros

• Absolute and Relative Recording
• Testing types of Recording
• Viewing and Editing Macros

Workbook Protection

• Types of Protection
• Protecting Worksheets
• Protecting Workbooks
• Protecting Files

Building Templates

• Using Existing Templates
• Creating Templates
• Modifying Templates

If you need to book a course after the ticket sales have closed, please get in touch and we'll do our best to accommodate you.

See here for terms and conditions.