My Shopping Cart
 
There are no items in your shopping cart.


Leverage Lookup Functions in Excel (IME372H)

Presented by: David Ringstrom, CPA
 
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Webinar
90 minutes
  •  Mon, March 27, 2017
Event Description
See the sneak peek before you buy!
 
1.0 CPE

VLOOKUP & HLOOKUP – When to use them, how to use them, troubleshooting and efficiency tips!

Looking for specific values within a data set is the most common task in Excel. In a simple database, you can just write a query for a specified table and look at the results returned. However, in Excel you need to use lookup formulas to complete this task. Having a solid understanding of all the lookup formulas is critical to work more efficiently in Excel.

This webinar by David Ringstrom, CPA, will provide you with some fascinating time-saving functions to help you find the specific information you’re looking for—pay rates, item prices, accounting results, etc.—thereby eliminating the need to manually link to specific cells.

David will introduce you to the VLOOKUP and HLOOKUP functions, and will provide context on when you’re likely to use them. He will demonstrate troubleshooting techniques and prepare you to deal with subtle issues that can prevent lookup formulas from working properly. You’ll also learn how to improve the integrity of your spreadsheets, perform dual lookups, scan a column for # sign errors, identify differences between two lists, and much more.

Session Highlights

  • Improve the integrity of spreadsheets with Excel’s VLOOKUP function.
  • Implement the IFNA function available in Excel 2013 and later.
  • View two worksheets from within the same workbook at the same time.
  • Use the SUMIF function to summarize data based on a single criterion.
  • Perform horizontal matches using the HLOOKUP function.
  • Use VLOOKUP to perform approximate matches.
  • Use the IFERROR function to display something other than an #N/A error value when VLOOKUP can’t find a match.
  • See what types of user actions can trigger #REF! errors.

Who should attend

  • Accountants
  • CPAs
  • CFOs
  • Controllers
  • Excel User
  • Income Tax Preparers
  • Enrolled Agents
  • Financial Consultants
  • IT Professionals
  • Auditors
  • Human Resource Personnel
  • Bookkeepers
  • Marketers
  • Government Personnel
About Our Speaker(s)

David Ringstrom, Excel ExpertDavid Ringstrom CPA
David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but shou... More info

 
Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
  •  
    Subject: You might be interested in this event from AudioSolutionz
    Event Title: Leverage Lookup Functions in Excel
    Presenter(s): David Ringstrom, CPA

 
DMCA.com Protection Status