Spend less time searching through spreadsheets and more time getting the answers you need.This practical introductory Excel session will show participants how to find information quickly, understand the basics of Excel formulas, and discover simple techniques that can save time in their day-to-day work. The session is designed for anyone who uses Excel and wants to work more efficiently.
Learning Outcomes
By the end of the session, participants will be able to: · Understand the basic structure of Excel formulas. · Recognise the key components of a formula and how they work together. · Use XLOOKUP to find and return information from another table. · Use Flash Fill to automate simple repetitive tasks. · Gain awareness of additional Excel capabilities available through our full-day Excel courses.
Course Agenda
1. Welcome and Introduction · Common Excel challenges · Session objectives and outcomes 2. Formula Fundamentals · Understanding formula syntax · Functions and arguments · Common formula mistakes 3. Finding Information Faster with XLOOKUP · What XLOOKUP is and when to use it · Understanding the formula structure · Guided demonstration and practical activity · Real-world examples using a South African training dataset 4. Excel Time Saver: Flash Fill · Automating repetitive tasks · Demonstration and examples 5. What Else Can Excel Do? 6. Questions and Discussion · Key takeaways · Participant questions
Who Should Attend?
This session is suitable for anyone who works with Excel and wants to save time finding and managing information, including administrative professionals, team leaders, HR practitioners, Learning & Development professionals, Finance and Operations staff, etc.
Prerequisites
Participants should have a basic understanding of Excel, including entering data and navigating a workbook.
Key Takeaways
Walk away with a practical Excel skill you can start using immediately to reduce manual searching, improve efficiency, and build confidence when working with data.
