• Sep 4, 2019 from 15:00 to 16:30
  • Location: Ijona Skills
  • Latest Activity: Oct 12, 2020

Topic : Going Beyond VLOOKUP to Master Excel Formulas

Overview

After participating in this informative webcast presented by Excel expert David Ringstrom, CPA, you'll have the skills needed to go beyond Excel's VLOOKUP function to master complicated formulas. VLOOKUP is the function many Excel users rely on to return data from other locations in a worksheet; however, utilizing VLOOKUP isn't always the most efficient approach.

Why should you attend?

Learn to work more efficiently in Excel by utilizing a variety of lookup formulas.

David will demonstrate every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. He?ll draw to your attention any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts.

Areas Covered in the Session:

  • Comparing HLOOKUP to VLOOKUP for performing horizontal matches versus vertical matches.
  • Contrasting the INDEX and MATCH combination to VLOOKUP or HLOOKUP.
  • Diagnosing #N/A errors that arise when numbers are stored as text or when text contains extraneous spaces.
  • Discovering how to use wildcards and multiple criteria within lookup formulas.

Learning objectives:

  • Identify the limitations of VLOOKUP and learn about alternative functions.
  • Recall how to future-proof VLOOKUP by using Excel's Table feature versus referencing static ranges.

Who can Benefit:

  • Accountants
  • CPAs
  • CFOs
  • Controllers
  • Excel User
  • Income Tax Preparers
  • Enrolled Agents
  • Financial Consultants

Speaker Profile :

David H. Ringstrom, CPA Keynote Speaker at Ijona Skills. He 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. 

Register : https://www.ijonaskills.us/webinarDetails?webinarid=585&speakerid=53&domain=1&source=GRC_LN_CH

Contact Info :

Ijona Skills

https://www.ijonaskills.us

Email : support@ijonaskills.us

Phone : +1 302-830-3132

E-mail me when people leave their comments –

You need to be a member of Global Risk Community to add comments!

Join Global Risk Community

Upcoming Featured events

    About Us

    The GlobalRisk Community is a thriving community of risk managers and associated service providers. Our purpose is to foster business, networking and educational explorations among members. Our goal is to be the worlds premier Risk forum and contribute to better understanding of the complex world of risk.

    Business Partners

    For companies wanting to create a greater visibility for their products and services among their prospects in the Risk market: Send your business partnership request by filling in the form here!

lead