IRS Form 1099, 1099-NEC, and Form 1099-MISC: Advanced Issues and Updates

Excel: Mastering Lookup Functions (OnDemand Webinar)

$149.00

SKU: 410699EAU

Description

Gain indepth knowledge of the LOOKUP functions in Excel.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? I’ve heard of VLOOKUP, but what are HLOOKUP and XLOOKUP? You can get the answers to these questions (and more) by attending this training session dedicated to mastering the various lookup functions that are built into Excel. VLOOKUP, HLOOKUP, and XLOOKUP are some of the most wellknown (and most useful) formulas in Excel. Used properly, they will help you improve the accuracy and integrity of your Excel workbooks, save a ton of time, and minimize data entry errors. This training is categorized as intermediate and is aimed at users who want to learn about the LOOKUP functions in Excel. Although the training will be delivered using the latest version of Excel, this topic is relevant for users of all versions of Excel (Note XLOOKUP is only available in certain versions of Excel.)

Date: 2023-04-26 Start Time: End Time:

Learning Objectives

VLOOKUP vs. HLOOKUP vs. XLOOKUP

How to Construct and Use the LOOKUP Functions

Tables – the Key to Future-Proofing LOOKUP

How to Avoid #NA

INDEX/MATCH vs. LOOKUP

Mike Thomas-theexceltrainer.co.uk

IRS Form 1099, 1099-NEC, and Form 1099-MISC: Advanced Issues and Updates

Excel: Mastering Lookup Functions (OnDemand Webinar)

$199.00

SKU: 407764EAU

Description

Gain indepth knowledge of the Lookup functions in Excel.VLOOKUP, HLOOKUP, INDEX and MATCH are some of the most wellknown (and most useful) formulas in Excel. Used properly, they will help you to improve the accuracy and integrity of your Excel workbooks, save a ton of time and minimize data entry errors.This topic is categorized as intermediatetoadvanced. It is aimed at users who want to learn about the Lookup functions in Excel.

Date: 2020-05-19 Start Time: End Time:

Learning Objectives

How to Construct and Use the VLOOKUP Function

TRUE and FALSE • the 4th Parameter Demystified

Tables • the Key to Future-Proofing VLOOKUP

Using MATCH and COUNTIF Functions to Compare Two Lists

INDEX-MATCH or VLOOKUP

How to Construct and Use the HLOOKUP Function

The LOOKUP Function

How to Avoid #NA

CPE ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

Mike Thomas-theexceltrainer.co.uk

IRS Form 1099, 1099-NEC, and Form 1099-MISC: Advanced Issues and Updates

Excel: Mastering Lookup Functions (OnDemand Webinar)

$199.00

SKU: 407233EAU

Description

Gain indepth knowledge of the Lookup functions in Excel.
VLOOKUP, HLOOKUP, INDEX and MATCH are some of the most wellknown (and most useful) formulas in Excel. Used properly, they will help you to improve the accuracy and integrity of your Excel workbooks, save a ton of time and minimize data entry errors.
This topic is categorized as intermediatetoadvanced. It is aimed at users who want to learn about the Lookup functions in Excel.

Date: 2020-02-05 Start Time: End Time:

Learning Objectives

How to Construct and Use the VLOOKUP Function

TRUE and FALSE • the 4th Parameter Demystified

Tables • the Key to Future-Proofing VLOOKUP

Using MATCH and COUNTIF Functions to Compare Two Lists

INDEX-MATCH or VLOOKUP

How to Construct and Use the HLOOKUP Function

The LOOKUP Function

How to Avoid #NA

Mike Thomas-theexceltrainer.co.uk