Going Beyond VLOOKUP to Master Excel Formulas


David H. Ringstrom, CPA  Keynote Speaker at ComplianceKey. 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. David's mantra is "Either you work Excel, or it works you," so he focuses on what he sees users don't, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively.

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 this webinar?

Learn to work more efficiently in Excel by utilizing a variety of lookup formulas.
David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2016. David draws attention to any differences in Excel 2013, 2010, or 2007 during the presentation as well as in his detailed handouts. He also provides an Excel workbook that includes most of the examples he uses during the webcast.

Areas Covered in the Session:

Who can Benefit:



Webinar Id: CIFDHR001

Training Options:

Duration: 60 mins

 Stop, pause, and rewind: learn at your own place.

Ratings:
No reviews yet!!
 Recorded: [Six month unlimited access]

 $167 (Single Attendee)  $599 (Unlimited Attendee)

Refund Policy
Past Webinar of David H. Ringstrom
Upcoming Webinar: Cross Industry Functions
PTO or Sick/Vacation? With Man....
Presenter: Bob McKenzie
When: 08/22/2019 | 10:00 AM PT |01:00 PM ET
Price: $189

More Webinar

Past Webinar: Cross Industry Functions
EPA Tier II Reporting Requirem....
Presenter: Joe Keenan
View it anytime
Price: $231
What Policies Should be Part o....
Presenter: Margie Faulk
View it anytime
Price: $169

More Webinar

Insert title here
Pay Pal Logo   PayPal Verified Logo   GoDaddy Certified
Copyright © 2018 Compliance Key . All Rights Reserved. Back to Top