Excel® - Mastering Advanced Functions

• Overview
• Credits

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.

Authors

Agenda

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