Tomorrow: Advanced Excel Lookup Functions

Attend upcoming webinar and earn continuing education credits. Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Advanced Excel Lookup Functions December   14 1 pm - 2:40 pm ET Presenter: David Ringstrom, CPA, author and nationally recognized Excel instructor Credits: CPE (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time after the live presentation, or both. Viewing Options: View on your computer, tablet, or smartphone Course Reviews: View Testimonials Learn More Register Today Course Description   Many Excel users rely on VLOOKUP to return data from other locations in a worksheet.  But VLOOKUP isn't always the most efficient approach.  In this webinar, you'll learn how to use alternative lookup functions, including the INDEX and MATCH, SUMIF, SUMIFS, SUMPRODUCT, IFNA, and OFFSET functions. Upon completion of this course, you'll be able to: Apply a variety of lookup formulas in order to work more efficiently in Excel Recognize why the INDEX and MATCH combination often is superior to VLOOKUP or HLOOKUP Apply the SUMIF and SUMIFS functions Use the IFERROR function to display something other than an #N/A error value when VLOOKUP can't find a match Perform dual lookups, allowing you to look across columns and down rows to cross-reference data you need Use the MATCH function to find the position of an item on a list View two worksheets from within the same workbook at the same time Perform horizontal matches with the HLOOKUP function Future-proof VLOOKUP by using Excel's Table feature versus referencing static ranges Course Reviews from Past Attendees 100% of attendees recommend this webinar. "This was the most beneficial webinar from both this instructor and Clear Law that I've ever seen." Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on 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. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 1,300 on-demand courses Learn More Upcoming Webinars Researching Tax Information Online December 18 at 3 pm ET Learn More Government Contracts Lifecycle Management December 19 at 3 pm ET Learn More Comfort Letters and Other Special Procedures Engagements: A Practical Guide for CPAs December 20 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 4601 N. Fairfax Dr., Ste 1200 | Arlington | VA | 22203 Remove me from future emails. Manage email preferences. This email was sent to virginia.duffy.planetduffy@blogger.com. If you are receiving it in error, please reply to this email.