Excel Formulas

Mastering Advanced Excel Formulas
29 May 2018
- 01:00 PM to 02:30 PM EST
90 Minutes (All time is as per EST)

Why do you need Excel formulas and functions? This collection of guides from the How-To Geek covers moderate to cutting edge lessons on the most proficient method to utilize Excel works and make formulas of your own.

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.

Why do you need Excel formulas and functions? This collection of guides from the How-To Geek covers moderate to cutting edge lessons on the most proficient method to utilize Excel works and make formulas of your own.

Webinar Overview
Expediting Excel: Mastering Advanced Excel Formulas - 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 (Mastering Advanced Excel Formulas)
• 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 (Advanced Excel Formulas)
• 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.

Why Should you Attend (Advanced Excel Formulas)
Practitioners who wish to benefit from working more efficiently in Excel by utilizing lookup formulas must attend this webinar.

David teaches from the version of Excel in use by the majority of attendees, but he explains any differences in Excel 2007, 2010, 2013, and 2016. His webcasts 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. David's detailed handouts serve as reference tools you can fall back on after participating in one of his webcasts. He also provides an Excel workbook that includes a majority of the examples he uses during each session

What You Get
• Training Materials – Sample excel workbook & webinar slides
• Live Q&A Session with the Speaker
• Participation Certificate
• Earn 100 Loyalty points with every booking. You can redeem one live webinar with 300 loyalty points.

Level: Intermediate

Who will Benefit
• Accountants and CPAs
• CFOs
• Financial consultants
• Controllers
• Accounting Personnel
• Analyst
• Excel User

At the Q&A session following the live event, ask a question and get a direct response from our expert speaker

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