Overview

Any public sector organisation can benefit from valuable employees with a strong knowledge of Excel and data manipulation. Now this can be you.

Our Advanced Excel Training virtual course has been specifically designed to help those with at least an intermediate understanding of Excel, to make better sense of their data.

Attend this course to gain a greater understanding of advanced Excel tools, such as auto filters, subtotals formulas and advanced lookups to help import, clean and validate data. You will also learn more advanced tools to manipulate data by using mixed plots and Goal seek.

Benefit from expert guidance, from Microsoft Consultant, Alan Gilbert, and increase your skills and understanding of innovative excel techniques.

Unlocking the Power of Virtual

Our virtual courses have been designed with you in mind. From group exercises in breakout rooms to live chat, whiteboards and interactive polls, we use a range of tools and techniques to ensure that you can connect with your trainer; network and share best practice with your peers and leave the day with the skills you need.

Our courses provide you with an interactive and engaging learning environment that can be accessed from any location, helping you to continue to connect, learn and grow. Click here to discover more!

Please note we will use Zoom to virtually deliver this course.

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: Auto filters, Subtotals formulas, Advanced lookups 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]

Agenda

Collapse all
09:25 - 09:30

Registration

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
  • The query editor
  • Separate data into columns
  • Concatenate and other field manipulations
  • Validate data entry
  • Set up validation for data inputs
10:45 - 11:00

Break

11:00 - 12:00

Workshop: Data Manipulation and Forecasting

  • Conditional functions IF, AND, OR
  • The XLOOKUP function
  • SUMIFS to sum by criteria
  • Use Goal Seek to find the right input
  • Forecast with a forecast sheet
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 - 13:45

Lunch

13:45 - 14:00

Reflection Session

  • Trainer will review the day’s learning and the next stages of the course
  • Delegates will have time to ask questions and share views with one another
14:00 - 14:45

Workshop: Automating functions in Excel

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

Break

15:00 - 16:00

Workshop: More Advanced Excel Tools

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

Round Up and Key Takeaways

Pricing

Central Government & Agencies - Virtual

Delegate Price
£345 + VAT

Local Government, Housing, Education & Health - Virtual

Delegate Price
£345 + VAT

Charity - Virtual

Delegate Price
£345 + VAT

Private Sector - Virtual

Delegate Price
£445 + VAT