Expediting Excel: Mastering Advanced Excel Formulas
15 May 2017
- 03:30 AM to 05:00 AM EST
90 Minutes

Expediting Excel: Mastering Advanced Excel Formulas

Expediting Excel: Mastering Advanced Excel Formulas

Acclaimed Microsoft Excel expert David H. Ringstrom, CPA, is the president and owner of Accounting Advisors Inc. based in Atlanta, Georgia. David founded Accounting Advisors in 1991 as a consulting-services business, but in 2009, he began teaching for continuing education providers as well.

There is no webinar video currently available. Please check back soon.

Overview
Many users rely on VLOOKUP for basic lookup functionality in spreadsheets, but they often are unaware of ways to improve the integrity of this venerable function. In this session, Excel expert David H. Ringstrom, CPA, introduces the VLOOKUP function and then quickly goes beyond the basics. Discover what can go awry with VLOOKUP; how to future-proof the function; and explore alternatives, such as MATCH/INDEX, SUMIF, SUMIFS, SMALL/LARGE, MIN/MAX, and OFFSET.

David’s courses are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants’ questions, so come ready to pick his brain. His detailed handouts serve as reference tools you can fall back on after participating in one of his webcasts. In addition, he provides an Excel workbook that includes a majority of the examples he uses during each session.

David’s materials cover Excel 2016, 2013, 2010, and 2007. During live presentations he teaches from the version of Excel the majority of attendees are using

Topics Covered
 Learn the risks of linked workbooks, determine if a workbook contains links, and see how links can hide within Excel features.
 Improve the integrity of spreadsheets with Excel’s VLOOKUP function.
 Use VLOOKUP to perform approximate matches.
 Use the IFERROR function to display something other than #N/A when VLOOKUP can’t find a match.
 See what types of user actions can trigger #REF! errors.
 Learn about the IFNA function available in Excel 2013 and later.
 Future-proof VLOOKUP by using Excel’s Table feature versus referencing static ranges.
 Use the MATCH function to find the position of an item on a list.
 Perform dual lookups, which allow you to look across columns and down rows to cross-reference the data you need.
 Avoid the complexity of nested IF statements with Excel’s CHOOSE function.
 Make VLOOKUP look up data from the left by using the CHOOSE function.
 Learn why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP.
 Compare the MIN, SMALL, MAX, and LARGE functions.
 Use the SUMIF function to summarize data based on a single criterion.
 Use the SUMIFS function to sum values based on multiple criteria.

Learning Objectives
 Identify which versions of Excel support the IFNA worksheet function.
 Identify two common # sign errors VLOOKUP can trigger.
 Define uses of the OFFSET worksheet function.

Level
Intermediate

You may also like

HR Certification Institute Approved Provider

Proskilleducator.com is an HRCI Approved Provider and can assign recertification credit hours (based on HR Certification Institute standards) to HR-related continuing education events, including qualification for PHR, SPHR or GPHR recertification credits. The use of this seal is not an endorsement by HR Certification Institute of the quality of the program. It means that this program has met HR Certification Institute’s criteria to be pre-approved for recertification credit.

SHRM Approved Recertification Provider

"proskilleducator.com" is recognized by SHRM to offer Professional Development Credits (PDCs) for the SHRM-CPSM or SHRM-SCPSM.  Our program is valid for PDCs for the SHRM-CPSM or SHRM-SCPSM. For more information about certification or recertification, please visit www.shrmcertification.org