Questions?

1.800.258.7246


home  |  about us  |  view cart  |  search

Follow us on: FacebookTwitterGoogle+LinkedIn
National Seminars Training - Your Complete Learning Center SEMINAR FINDER
State:
ZIP:
Sign Up for Emails or Special Offers
Email:
ZIP:
Beyond VLOOKUP in Excel®
Uncover the hidden functionality and find easy solutions to quickly access your data

Price: $199 Register Now
Date: August 28, 2017 | 11:00AM PT • 12:00PM MT • 1:00PM CT • 2:00PM ET

Can’t break away for an hour at this time? For your convenience, a
CD-ROM recording is made of each webinar. You may choose to purchase the CD-ROM either along with the webinar or separately. The CD-ROM recording will be available approximately 14-21 days after the webinar (details).

Program Description:

When you’re pulling data from multiple locations within a worksheet, Excel’s VLOOKUP works like a charm—until you get the dreaded #N/A result telling you ... there’s a problem.

If you’ve used VLOOKUP, you know that data formatting issues can slow you down. You know that there are limitations ... and frustrations. There are columns to count (which is no small matter with a large worksheet). Maybe the data you’re referencing is in two columns rather than one. You can fiddle around restructuring the data, but it all takes time—time you don’t have.

There are quicker ways to get the data you need! VLOOKUP has a lot of hidden power ... functionality that can fix these limitations and make your work much, much easier. Expand your VLOOKUP success. Learn the secrets in this new one-hour webinar crash course. Enroll now!.

Take a Glimpse at What You’ll Learn:

  • How to use the IFNA function features available to Excel  2016 users
  • Use wildcards for partial matching
  • How wildcards and multiple criteria can boost look-up formulas
  • Returning data from other spreadsheet locations without linking to individual cells
  • How to use VLOOKUP to improve the integrity of your spreadsheets
  • Identifying VLOOKUP limitations and tapping into the SUMIF and SUMIFS alternatives
  • How the MATCH function can overcome data integrity risks
  • Forcing VLOOKUP to perform exact matches or an approximate match
  • When to use the MATCH and INDEX combination and when to use the VLOOKUP or HLOOKUP functions
  • How to cross-reference data by performing dual lookups across columns and down rows
  • Defining IFNA, IFERROR and ISERROR
  • Using VLOOKUP to classify or categorize data

Q & A Session:
Upon enrolling in the Webinar, you will have the opportunity to submit your questions via e-mail. Time permitting, your trainer will address questions from Webinar participants. Many questions will be addressed in the Webinar itself. Others will be addressed in the supporting materials that will be available exclusively to Webinar participants.

QUICK LINKS

STAR12

Corporate Training

Webinar FAQs

Webinar System Check

Training Room Set Up

Invite Others to Gather Around Your Computer to Attend This Webinar Along With You . . . for FREE!

When you enroll in this webinar, you’ll be entitled to one webinar connection and the extra benefit of gathering as many people around your computer as you can.

You can maximize the reach of this training even more by setting up your own screening room in your organization. For details on how to create your own training room in your office, click here!

Why Use Web Training?

Busy professionals like you sometimes can’t get away from the office for a day to get training — even if it will make your life a thousand times easier! So let us bring the training right to your desk through your PC or Mac!

You’ll get insightful advice and training from an expert in the field, along with effective visual aids to help make the learning stick. There’s simply no easier way to “get it” quickly and effectively than our webinars!



Registration Options:

Option
Standard Fee 
Your Special Price Today
Webinar + CD-ROM **

$398
$298 – SAVE $100!

Webinar Only


$199

CD-ROM ** Only


$199

Follow this enrollment link to make your selection ... Register Now

**For your convenience, a CD-ROM recording is made of each webinar. You may choose to purchase the CD-ROM either along with the webinar or separately. The CD-ROM recording will be available approximately 14-21 days after the webinar.

Questions? Contact customer service at 1-800-258-7246.

Your confirmation will be delivered via e-mail, so an e-mail address is required for registration.

CUSTOMER SERVICE: 1.800.258.7246
National Seminars Training
1.800.258.7246