Available Dates


With access to a large amount of data, expertise in Excel and data manipulation is highly valued in the public sector.

Delivered by Microsoft expert Alan Gilbert, this course will provide in-depth training and expert guidance on advanced Excel tools including data analysis, subtotal formulas, advanced lookups, mixed plots and Goal Seek. Learn how to effectively import, clean, and validate data, and manipulate it to make more informed decisions.

Our Advanced Excel Training is designed to help you take your Excel skills to the next level.

Deepen your understanding of innovative Excel techniques and position yourself as an invaluable contributor to your organisation’s efficiency, productivity and decision-making process.

trainer photo
Alan Gilbert
Microsoft Excel and Power BI Consultant

In his 20+ years of teaching Microsoft products, Alan has helped a vast array of industries from finance to construction, media, and government. In the past he has been both lead trainer for Go Courses, and training manager for Ultima Concepts. As work increased, he established his own IT consultancy in 2013, following on from 18 years as a full-time trainer.

Being a certified Microsoft Office Specialist, he found the demand for Microsoft Excel training and consultancy work, including Excel’s many facets, increased substantially. Subsequently, that insider’s perspective led him to establish a second consultancy specialising in Microsoft ...

Read more

Learning Outcomes

  • Understand how to manipulate data effectively
  • Gain skills to utilise pivot tables, create macros and visualisations
  • Learn how to use more advanced Excel tools to benefit your organisation: Data analysis, Advanced lookups, Subtotal formulas, and Trending
  • Benefit from expert guidance and have your Excel questions answered in an interactive learning environment
All the Understanding ModernGov courses are Continuing Professional Development (CPD) certified, with signed certificates available upon request for event.

Enquire About In-House Training

To speak to someone about a bespoke training programme, please contact us:
0800 542 9414
[email protected]


Collapse all
09:00 - 09:30


09:30 - 10:00

Trainer’s Welcome and Clarification of Learning Objectives

10:00 - 10:45

Workshop: Importing, Shaping and Validating Data

  • Import tables from external files
  • Separate data into columns
  • Concatenate and other field manipulations
  • Validate data entry
  • Set up validation for data inputs
10:45 - 11:00

Morning Break

11:00 - 12:00

Workshop: Lookup and Criteria Functions, What-If Analysis

  • The INDEX and MATCH lookups
  • SUMIFS to sum by criteria
  • Use Goal Seek to find the right input
  • Use Scenario Manager to switch values
12:00 - 13:00

Workshop: Data Analyses and Visualisations

  • Analyse data in pivot tables
  • Group data in pivot tables
  • Conduct field calculations
  • Create report dashboards
  • Learn how to utilise combo charts
  • Understand Waterfall charts and their uses
13:00 - 14:00


14:00 - 14:45

Workshop: Automating tasks in excel

  • Automate repetitive tasks with macros
  • Understand the process of a macro
  • How to execute macros
  • Editing VBA code
14:45 - 15:00

Afternoon Break

15:00 - 16:00

Workshop: Other Advanced Excel Tools

  • How to insert subtotal
  • Handle duplicate values in lookups
  • How to view trends
16:00 - 16:15

Feedback, Evaluation & Close


"An excellent and informative course delivered by knowledgeable presenters. I recommend it!"
A Guide to Successful Information and Records Management Agency Records Officer, Vehicle Certification Agency
"This course provides a good combination of general theory and very practical, experience based advice; really adding value to your day to day activities if you work with records management.”
A Guide to Successful Information and Records Management GDPR Protect Manager, DataAI
“A good introduction to an area I was completely unfamiliar with. Gives a lot to think about going forward.”
Developing Agile TeamsAssistant Economist, Food Standards Agency
"The trainer was an excellent instructor who provided insight from their own experience and applied to fun and engaging practical sessions that i can apply to my own teams."
Developing Agile Teams Operations Manager, University of Portsmouth
"A really informative, interactive and beneficial course for anyone who doesn't know much about agile."
Developing Agile Teams Programme Management Support Officer, Avon Fire and Rescue Service