This bite-sized session will show you how to take control of your data by mastering Excel’s powerful LOOKUP functions - essential tools for connecting and retrieving the right information across multiple data sets. If you’ve ever struggled to match data from different lists or spent ages searching for key details, this session is for you.
These are not for the faint hearted - but we're going to break things down into bitesized manageable chunks. We’ll cover everything from the basics to clever tips and tricks that make your data work harder for you - faster, smarter, and more accurately.
Here’s what we’ll cover:
✅ When and why to use LOOKUP functions
✅ How to create and use VLOOKUP and XLOOKUP with ease
✅ Combining data from different tables without copying and pasting
✅ Using INDEX & MATCH for more flexibility
✅ Avoiding common mistakes that trip people up
If you're ready to stop wrestling with multiple spreadsheets and start pulling the right information effortlessly, join me for a session packed with practical examples, real-life tips, and my usual enthusiasm.