Available Dates
-
DateVenueAvailabilityPurchase
Overview
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.
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 ...
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
