This Essentials course is for people who use Excel regularly and want to work smarter with data. Over two afternoons delegates will learn the formulas, lookups and PivotTables that save the most time at work, and how to make spreadsheets more reliable. Move your team from ‘getting by’ in Excel to analysing data properly.
Finance, admin, operations and project staff who already use Excel daily — in SMEs, property and facilities firms, estate agents, charities’ finance teams and public sector offices.
- Staff spend hours manually matching data between sheets
- Monthly reports are rebuilt from scratch every time
- Nobody quite trusts the formulas in shared workbooks
- Managers can’t get quick answers out of the data they already hold
- Use IF, SUMIFS, COUNTIFS and other logical functions
- Look up and match data with VLOOKUP / XLOOKUP and INDEX-MATCH
- Summarise large data sets with PivotTables and PivotCharts
- Use absolute and relative references correctly
- Tidy and check data so formulas give reliable results
- Pitched for existing users — no time spent on basics
- Exercises can be built around your own reports or data
- Two afternoons (Wed and Fri, 1–5pm) — no full day out of the business
- Small groups — up to 12
- At our Richmond campus, at your workplace, or live online
- Practical and hands-on, led by an experienced tutor
- Reports produced faster and more consistently
- Fewer errors in shared workbooks
- Better use of data the organisation already has
- Staff ready to move on to Power BI
- Book individual places on a scheduled course, or book the whole course for your team
- Team bookings: at our Parkshot campus in Richmond or at your premises, on dates by arrangement
- Free pre-course check: skills check + one sample spreadsheet from employer (optional) to tailor examples
- Parkshot campus is a short walk from Richmond station (train, tube and Overground); parking is limited
- Contact [employer enquiries contact] for group rates