Description
Master some of Excel’s most advanced functions that give you tremendous capabilities to tackle a myriad of statistical, mathematical and financial challenges.
How do I compare the items in these two lists and see which are missing? How do I look up a value in list ONE and pick up a related value from list TWO? How do I avoid my lookup formula displaying an ugly error when it can’t find a match? What’s the difference between VLOOKUP and INDEXMATCH? I’ve heard of VLOOKUP but what’s HLOOKUP? How can I automatically count items that match a criteria? These are just a few of the questions I get asked on a regular basis. You will get the answers to these questions (and more) with this topic dedicated to mastering some of Excel’s advanced functions.
Date: 2020-01-13 Start Time: End Time:
Learning Objectives