Must-Know Excel Functions to Increase Your Productivity (2 of 3)
What You'll Learn
Key takeaways from this session
IF: Automate data entry…if this condition is true, enter this value into a cell else enter that value into a cell
COUNTIFS: Count how many times a particular value (date, number, text) appears within a range (e.g. how many times was Customer X a late payer?)
SUMIFS: Add up a set of numbers that match a criteria (e.g. what was the total number of hours worked on Project 123)
IFERROR: Want to get rid of those ugly #DIV/0 and #N/A errors? IFERROR is your friend
XLOOKUP: Often referred to as “VLOOKUP on steroids”, XLOOKUP is the new kid in town, making searching for data in a tabular list quick, simple and straightforward!
Earn PDU Credits
PMI Professional Development Units
About the Presenter
TheExcelTrainer
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies, his primary focus and passion being Microsoft Office (especially Excel) and Power BI. In 2012 Mike founded The Excel Trainer where he has produced nearly 200 written and video-based Excel tutorials. He has recorded several Excel training courses for Pluralsight and in his career delivered thousands 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.
