Excel VLOOKUP'S with 10 Exercises

by G BLANCO

Overview

This booklet is short and simple so you can learn some of the most used VLOOKUP's techniques faster. It comes with an Excel file already loaded with formulas and data from where you can learn and practice.

The 10 exercises mimic real business scenarios and each exercise is a different VLOOKUP technique. In addition to the 10 exercises, this booklet includes a TRY IT section with 10 more exercises from where you can keep practicing. You'll find some tips on how to fix the most common VLOOKUPs errors.

You'll learn how to do a simple VLOOKUP, how to VLOOKUP from one tab to the other, from one Excel file to the other, how to validate reports and deal with #N/As or errors. You'll also learn how to create a KEY to support your VLOOKUP formulas when your data gets more complex, and how to use the IFERROR() function within your VLOOKUP for data readability.

Product Details

ISBN-13:	9781735114613
Publisher:	Hollerdata
Publication date:	06/27/2020
Pages:	34
Product dimensions:	5.50(w) x 8.50(h) x 0.07(d)

About the Author

G.BLANCO is a Sr. Analyst based in Miami who has worked in data related positions at several companies including Cisco Systems, Hewlett-Packard, and Office Depot previously. He has a master's degree in Predictive Analytics from Northwestern University, Evanston.