Slicing & Dicing Your Data With VLOOKUP

SKU: PMV-0015

Learn how to add dimensional data using Excel's VLOOKUP function to increase the analysis capabilities of your spreadsheet applications. More details...

Price: $24.95

Product Details

How to slice and dice your data using VLOOKUP()

Learn how to add dimensional data using Excel's VLOOKUP function to increase the analysis capabilities of your spreadsheet applications. In this 1 hour 10 minute video, we will show you how to gain more insight from your transactional data. We will also illustrate how to create Defined Name ranges that you can use in your VLOOKUP applications, which will make your applications easier to maintain. The video agenda is as follows:

Review the four VLOOKUP() parameters
Discuss how VLOOKUP() and NA() functions can work together
Learn how to use Defined Names as your table_array argument
See when to you might want to create your new search values
Review some common errors and watch outs
Use what we learned and build a comprehensive example
Discuss dynamic Defined Name ranges and how to create them
Show how to use conditional formatting with the dynamic Defined Name ranges
Review the other LOOKUP functions

As a result of this webinar, you will learn creative new ways to leverage Excel functionality that will help you produce more action-oriented analysis.

Duration: 1 hour 10 minutes
Cost: $24.95
Delivery: Presentation & example Excel files provided along with a link to the video will emailed to you

Back to the top