Excel® - Mastering Advanced Functions
|OnDemand Webinar||$199||Add to Cart|
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 INDEX-MATCH? 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.
AuthorsMike Thomas, theexceltrainer.co.uk
How to Construct and Use the VLOOKUP Function
True and False - the 4th Parameter Demystified
Tables - the Key to Future-Proofing VLOOKUP
How to Construct and Use the HLOOKUP Function
How to Avoid #NA
The IF Function
The COUNTIF and COUNTIFS Functions
The SUMIF and SUMIFS Functions
The IFERROR Function