Menu
By - Mike Thomas
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Master Excel Lookup & Logical Functions for Accuracy and Efficiency
Tired of wasting time on manual calculations and risking costly errors in your spreadsheets? Excel’s Lookup and Logical functions can transform how you work—helping you improve accuracy, save time, and build smarter, more reliable workbooks.
In this session, you’ll learn how to leverage VLOOKUP, HLOOKUP, INDEX, MATCH, and other powerful functions to automate data retrieval and streamline analysis. We’ll also explore logical functions such as IF, COUNTIF, and SUMIF, which allow you to calculate results based on criteria—reducing repetitive data entry and minimizing mistakes.
By mastering these tools, you’ll be able to confidently handle large datasets, build error-proof formulas, and let Excel do the heavy lifting.
This session is ideal for intermediate-to-advanced Excel users who want to take their skills to the next level and gain confidence using Lookup and Logical functions. While examples will be demonstrated in Excel 2016 for Windows, most features are also available in Excel 2010 and 2013.
Stop relying on calculators and manual checks—let Excel deliver accuracy and efficiency for you.
Vulputate eros arcu magnis donec sem pretium scelerisque a etiam. Eros aliquam elit si mattis phasellus at orci letius ligula posuere. Sodales maecenas facilisis diam egestas dictumst si fames mus fermentum conubia curabitur. Ornare nisi consectetur semper justo faucibus eget erat velit rhoncus morbi.
Mike Thomas
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. In 2012 Mike founded theexceltrainer.co.uk where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for pluralsight.com and in his career delivered hundreds of courses and webinars on a wide variety of technology-related topics. Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
Subscribe to our newsletter and be the first to receive the latest regulatory changes, training insights, and industry best practices.
Compliance Live is an industry-leading provider of quality training for business professionals.
