This practical half-day course is tailored for those working in administration or office support roles.
The session focuses on real-world Excel tasks that help you stay organised, manage data, and reduce manual input.
What You’ll Learn
· Working with structured data: sorting and filtering
· Creating and editing Excel tables
· Quick ways to fill, clean, and validate data
· Adding drop-down lists and data validation
· Using absolute referencing (with $) and named cells
· Introduction to the IF function
· Applying conditional formatting to highlight key information
· Creating simple Pivot Tables to summarise data
· Who Should Attend?
· Office administrators and PA/secretarial staff
· School or charity admin teams
· Anyone in a support role who needs to manage Excel data more efficiently
Venue
· Free parking
· Unlimited refreshments
· A comfortable, professional setting
· Laptops provided – or bring your own if preferred (installed with Microsoft 365)
What’s Included
· Live expert-led training
· Digital workbook and example exercises
· Certificate of attendance
· Free post-course support by email
Your Trainer
Your session is led by an experienced IT trainer who specialises in making Microsoft applications clear, friendly, and relevant – whether you're a complete beginner or ready to advance your skills.