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
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 | Microsoft Excel Courses  SpeakerDavid 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

 
We Also Recommend
Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
  •  
    Event Title: Leverage Lookup Functions in Excel
    Presenter(s): David Ringstrom, CPA

 
 
 
Our Accreditation Partners
DMCA.com Protection Status
×

Dear Valued Customers,

We regret to announce that ProEdTech LLC and all its affiliate brands will cease operations on April 1, 2019.

We are no longer able to fulfill online orders. We will fullfill all DVD and book orders already placed.

Customers of canceled webinars and subscription products may request a refund at (800) 223-8720 or service@proedtech.com. You must do so by April 1, 2019.

Thank you for your business and loyalty over the years. We sincerely apologize for any inconvenience caused.


Best regards,
The ProEdTech Team