Excel Finesse: Going Beyond VLOOKUP to Master Functions

IjonaSkills - IT Webinars

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. David shares helpful tweaks you can implement with the revered VLOOKUP function and explains several alternatives, including the INDEX and MATCH, SUMIF, SUMIFS, IFNA, and IFERROR functions.
Why should you attend?
Practitioners who may benefit from working more efficiently in Excel by utilizing lookup functions.

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. David also provides an Excel workbook that includes most of the examples he uses during the webcast.
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.
  • Eliminating inputs that could cause VLOOKUP to return #N/A with Data Validation.
  • Employing the SUMIF function to sum values related to multiple instances of criteria you specify.
  • Future-proofing VLOOKUP by referencing entire columns when available.
  • Future-proofing VLOOKUP by using Excel's Table feature versus referencing static ranges.
  • Identifying situations where VLOOKUP may return #N/A instead of a value.
  • Identifying the risks of the LOOKUP function in Excel.
  • Improving the integrity of spreadsheets with Excel?s VLOOKUP function.
  • Learning about the IFNA function available in Excel 2013 and later.
Who can Benefit:
  • Accountants.
  • CPAs.
  • CFOs.
  • Controllers.
  • Excel User.
  • Income Tax Preparers.
  • Enrolled Agents.
  • Financial Consultants.
  • IT Professionals.
  • Auditors.
  • Human Resource Personnel.
  • Bookkeepers.
  • Marketers.
  • Government Personnel.

IjonaSkills
1 302-830-3132

Location: United States

Comments

Post a Comment

Popular posts from this blog

Managing People for the First Time: The "Non-So-Common" Common Sense Principles for the New Supervisor

Image
IjonaSkills  -  HR Management Training in United States Overview Becoming a leader with direct oversight of employees can be rewarding, inspiring, and challenging. By demonstrating success in your own job, you are now (or soon will be) stepping into a role of engaging and developing employees. At the same time, you're responsible for operational success, inter-departmental coordination, and key performance indicators. It can be an overwhelming step up! Most people moving into a management position for the first time have little or no management and leadership training. As a result, they're forced to learn on-the-job, and sometimes fail to make a positive impact. Ironically, the skills and talent that resulted in success in their individual roles are not the same as the ones that lead to leadership and management success. This course is designed to provide you with a clear foundation on how to be a successful new manager and leader by learnin
Read more

The Marriage of the PFMEA and Control Plan, A Dynamic Control Plan

IjonaSkills  -  Corporate Finance Training Overview Come celebrate the union of the PFMEA and the CP! See how the Dynamic Control Plan (DCP) combines both tools into ONE enabling the savings of hundreds of hours of Engineering time, reducing the risk of documentation errors, and, actually improving QMS effectiveness while reducing repetitious work. This session will show you how you can benefit from the DCP! Process Failure Modes Effects Analysis (FMEA): High level overview of PFMEA column content. Not designed to be an in-depth session of each PFMEA column Control Plan (CP): High level overview of CP column content. Not designed to be an in-depth session of each PFMEA column Dynamic Control Plan (DCP): Step by step blend of the two documents per general AIAG standards; no column will contextually be left behind. Participants will actually observe the completion of 2-3 lines of a DCP for a modeled item including both a variable and an attribute feature Benefits Review: Pros/
Read more

Data Modelling and Analysis with Excel Power Pivot

Image
Tom Fragale Tom Fragale is Keynote Speaker at Ijona Skills. He is a computer professional with over 30 years of professional experience. He has extensive experience in consulting and providing custom software solutions. He has trained over 30,000 business people in on-line webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as........ Read More This Webinar qualifies for a recertification credit hour that may be counted toward SHRM-CP and SHRM-SCP recertification from SHRM. This Lecture contains 1. Overview If you work with data, you're likely already familiar with common frustrations with Microsoft Excel like size limitations and manually entering data from multiple sources
Read more