Register Online - Add to Cart

Credits

Sponsored by Lorman Education
Only registered attendee will receive continuing education credit.
Product ID: 406820
 
Credit & Course Provided by:

Excel® - Mastering Advanced Functions

Live Webinar
January 13, 2020
1:00 pm ET (12 pm CT, 11 am MT, 10 am PT)
1 hour 30 minutes
Live Webinar$199Register Now
Can't Attend?   Audio & Reference Manual$199Add 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.

Learning Objectives

• You will be able to define COUNTIF and COUNTIFS functions.

• You will be able to identify the IFERROR function.

• You will be able to explain how to construct and use the VLOOKUP function.

• You will be able to review how to construct and use the HLOOKUP function.

Registration

Live Webinar$199Register Now
Can't Attend?   Audio & Reference Manual$199Add to Cart