COURSES > ANALYTICS
Advanced Excel Training
Utilise Excel to Improve Performance
Previously Chaired by
Alan Gilbert
Sorry, we don’t have any upcoming dates available for individuals.
All of our training courses can be tailored specifically for your team or organisation and presented at your offices, at another suitable location or virtually.
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.
Who should attend?
If you already have an intermediate level of proficiency in excel, this training can take your skills to the next level. We also welcome anyone wanting to learn new Excel skills and up their game.
* Please note for this course, it will be useful to have two screens but not mandatory
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
Alan Gilbert
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 Our Bespoke Team Training
0800 542 9414
InHouse@moderngov.com
Agenda
09:00 - 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
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 Lunch
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
Become Part of the Understanding ModernGov Community