VLOOKUP and Beyond in Microsoft Excel

    /Dennis  /Taylorspeaker of Training Doyensinvite
    Speaker: Dennis Taylor


    More Trainings by this Expert
    Duration: 90 Minutes
    Product Code: 50163
    Level: Intermediate

OVERVIEW

Lookup formulas such as VLOOKUP allow you to return data from other locations in your spreadsheets without linking to individual worksheet cells. However, VLOOKUP can't always return the data that you need. 

In this webinar, Excel expert Dennis Taylor explores the nuances and limitations of VLOOKUP, helps you expand your use of this function, and then presents you with a handful of alternatives.

WHY SHOULD YOU ATTEND

  • Compare and contrast IFNA, IFERROR, and ISERROR, and see which versions of Microsoft Excel support these worksheet functions
  • Discover how to use wildcards and multiple criteria within lookup formulas
  • Don't be caught off-guard by the new IFNA function available to Excel 2013 users
  • Improve the integrity of spreadsheets with Excel's VLOOKUP function
  • Master the versatile SUMIF and SUMIFS functions

AREAS COVERED

  • Perform dual lookups, where you look across columns and down rows to cross reference the data you need
  • See how to arrange two worksheets from within the same workbook onscreen at the same time
  • See why the MATCH and INDEX combination is often superior to the VLOOKUP or HLOOKUP function
  • Uncover the limitations of VLOOKUP, along with alternatives
  • Use the SUMIFS function to sum value based on multiple criteria

LEARNING OBJECTIVES

  • Understand how to use VLOOKUP to perform both exact and approximate matches
  • Use the MATCH function to overcome a data integrity risk with VLOOKUP
  • See how the SUMIF and SUMIFS functions can serve as alternatives to VLOOKUP

WHO WILL BENEFIT

  • CFO’s
  • Controllers 
  • Investment Analysts / Financial Analysts / Business Analysts 
  • Forecasting & Planning Personnel
  • Mergers & Acquisitions Specialists  
  • Risk Managers
  • Strategic Planners / Capital Expenditure Planners
  • Cost Accountants / Managerial Accountants

SPEAKER

Years of Experience: 25+ years

Areas of Expertise: Microsoft Excel

Dennis Taylor is an Excel expert. He has worked extensively with Microsoft products (especially spreadsheet programs) since the mid-1990s. He’s traveled the United States and Canada giving seminars to help his students unlock the full potential of Excel. Dennis has a unique ability to describe, decode, and demystify the myriad functions of Excel for individuals and businesses. He’s taught hundreds of workshops and authored numerous tomes on this program.

Accomplishments: Dennis’s 25-year track record of Excel exploits is nearly overwhelming in scope and volume. He has penned and presented more than 600 webinars on various Excel topics in the past nine years. Dennis has also produced numerous Excel courses on video, CD, and DVD. As if this wasn’t enough contribution to Excel education, he’s taught more than 500 seminars and over 5,000 workshops on the subject. Dennis partnered with Lynda.com (now part of LinkedIn) to make his training even more widely available—he’s posted nearly 200 hours (over 50 courses) of easy-to-understand Excel explanations there. Dennis also authored Teach Yourself Microsoft Office 2000 and coauthored five other titles in this field. Whether you’d prefer to read, watch, or listen, he can share his expertise with you.

View all trainings by this speaker

Purchase Options

Recorded Session

Get unlimited access to the link for six months. Login information will be shared 24 hours after the completion of Live webinar

$219

Training DVD or USB Flash Drive

Free shipment within 72 Hours, from the date of webinar completion

$399

refer friend

Approved Enablers of your
Continuing Education Credits

shrmhrci
View all CEU Approved Webinars  

View Similar Trainings

In Banking & Financial Services

  Mark Schwartz Time: 01:00 PM EDT | 10:00 AM PDT