Make Microsoft Excel Work Harder For You.
Refresh your Microsoft Excel skills with our practical evening workshops, designed for busy professionals who want to work more confidently with data and get more from Excel in their day-to-day role. Focused one-day sessions makes it easy to fit professional development around your working commitments.
Analysis
Turn everyday data into insights that make a difference. Learn how to clean, organise and format data, then use Excel’s powerful tools to uncover what the numbers are really telling you. Through hands-on activities, you’ll build confidence with formulas and functions, Text to Columns, PivotTables and charts, helping you work faster, make smarter decisions and get more from Excel every day.
Manipulating Data
Ideal for anyone working regularly with large datasets, this hands-on session will help you organise, manage and manipulate data with confidence. You’ll learn how to structure data, create tables, and use tools such as conditional formatting, sorting, filtering, subtotals and grouping. You’ll also explore named ranges and data validation to improve accuracy, consistency and productivity.
You don't need to be in the 27%
Functions and Formulae
Whether you’re creating reports, analysing data or streamlining everyday tasks, this hands-on workshop will help you unlock more of Excel. Build confidence with essential formulas and functions such as SUM, AVERAGE and COUNT, then progress to more advanced tools including IF and percentage calculations.
Pivot Tables
Learn to turn complex data into clear, professional insights with PivotTables and PivotCharts. You’ll build confidence creating, formatting and customising reports, using slicers, grouping and drill-down tools, and applying summary calculations. You’ll also explore GETPIVOTDATA and discover how to create dynamic visualisations that make your data easier to understand and act on.
Sounds familiar?
Advanced Functions and Formulae
Already confident with Excel formulas and functions? Take your skills further by learning how to work more efficiently with complex data, automate calculations and unlock Excel’s advanced features. You’ll refresh key concepts such as absolute references and named ranges, then build practical skills using SUMIF, COUNTIF, HLOOKUP and VLOOKUP, linking data across worksheets and workbooks, and using Consolidation to combine and summarise information from multiple sources.