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
In a career spanning 30+ years, Mike Thomas, a UK-based IT Trainer, has delivered thousands of courses and produced hundreds of written and video-based tutorials. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI. Mike is a Fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of industries including healthcare, pharmaceutical and public sector. In addition to training, he also designs and develops Microsoft Office-based solutions that automate key business tasks and processes.
Grc Educator is an industry-leading provider of quality training for business professionals.
