In-House: Advanced Excel Training

Overview

A highly developed understanding of Excel can help organisations to monitor and manipulate data.

This 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.

Run this course for your teams In-House and help them gain a better understanding of using more 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 our trainer to, increase skills and get a firmer understanding of more innovative techniques, while practising on public sector data.

Run this Course In-House

Learning Outcomes

Understand how to manipulate data effectively
Gain skills to utilise pivot tables, create macros and create 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

Ice Breaker and Clarification of Learning Objectives

A quick video tutorial will be shown on using the key features of Zoom
Breakout rooms will be used for delegates to introduce each other
Gain a quick overview of Excel
Refresh your Excel knowledge
Confidently navigate yourself around Excel

10:00 - 10:45

Workshop: Importing, Cleaning and Validating Data

Importing and separating data into multiple fields
Concatenation and other field manipulations
Date format clean-ups
Validating data entry
Setting up validation for data inputs
Using data validation

10:45 - 11:00

Morning Break

11:00 - 12:00

Workshop: Data Manipulation Part 1

Conditional statements, Index, Match, Offset
Grouping data, SumIfs
Transposing data, multiply/divide with a constant
CAGR and other calculations
Goal seek, Solver

12:00 - 13:00

Workshop: Data Manipulation Part 2

Creating and manipulating pivot tables
Visualising pivot tables
Mixed plots (two axes, bar/line combo, etc.)
Waterfall charts
Editing chart data

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: Beyond Executing a Single Function

The basics statements and loops in macros and VBA Visualisation
Creating macros
Debugging and executing macros

14:45 - 15:00

Afternoon Break

15:00 - 16:00

Workshop: More Advanced Excel Tools

Auto filters
Subtotals formulas
Advanced lookups
Trending

16:00 - 16:15