Only 3 Places Left!

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.

Attend this course to 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.

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
Branko Pecar
Statistics Consultant

Branko spent most of his career working for Emerson, a global and one of the largest process control equipment manufacturing corporations. His last position was VP Educational Services. In the past, he also lectured at the University of Gloucestershire in several subjects, including quantitative methods and applications of Excel.

He published a series of books in statistics with a variety of publishers, such as McGraw Hill, Oxford University Press and Amazon. Almost all of these books are based around applying a variety of sophisticated methods using the simplest Excel syntax. He has been using Excel for over ...

Read more

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:15 - 09:30

Registration

09:30 - 10:00

Trainer's Welcome and Clarification of Learning Objectives

  • 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 received data
  • Setting up validation for data inputs
  • Transposing data, multiply/divide with a constant
10:45 - 11:00

Morning Break

11:00 - 12:00

Workshop: Data Manipulation Functions

  • IF, AND, OR statements
  • Counting, summing, COUNTIF, SUMIF, COUNTIFS, SUMIFS,
  • SUMPRODUCT, SUBTOTAL
  • Location statements, LOOKUP, OFFSET, INDEX, MATCH
  • Compound Annual Growth Rate (CAGR) calculation

 

12:00 - 13:00

Workshop: Data Analysis and Visualisation

  • Creating and manipulating pivot tables
  • Visualising pivot tables
  • Mixed plots (two axes, bar/line combo, etc.)
  • Adding trend to data
  • Correlation and regression
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: Excel Built-In Tools

  • Auto filters
  • Subtotals formulas
  • Groups and subtotals
  • What-If analysis
  • Goal seek
  • Solver
  • Excel Forecast (ETS) algorithm

 

 

14:45 - 15:00

Afternoon Break

15:00 - 16:00

Workshop: Beyond Executing a Single Function

  • How the loops work
  • Creating macros
  • Debugging and executing macros
  • Macro example – Inverse order of data series

 

16:00 - 16:15

Roundup 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