Welcome to Nonprofit.Courses

Live Event Calendar

When’s the next webinar or podcast or conference?

Here’s where you find out – and more.

Loading Events

« All Events

  • This event has passed.

Advanced Excel® Skills for Accountants

January 5 @ 1:00 PM - 3:00 PM EST

$199
Lorman Logo

Transform overwhelming lists of data into meaningful reports using Excel’s lookup functions and PivotTables.

 

Excel® expert David Ringstrom, CPA, explains helpful ways you can improve the integrity of your spreadsheets using Excel’s lookup functions and PivotTables. In this comprehensive topic, he reveals alternatives to VLOOKUP, including the HLOOKUP, XLOOKUP, INDEX and MATCH, SUMIF, SUMIFS, and IFNA. Lookup functions are only the start, though. In many cases, you’re only a few mouse clicks away from transforming overwhelming lists of data into meaningful reports. David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Office 365 version of Excel®. He draws attention to any differences in the older versions of Excel® (2019, 2016, 2013, and earlier) in his detailed handouts. He also provides an Excel® workbook that includes most of the examples he uses during the topic. Office 365 is a subscription-based product that provides new-feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel® have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel® 2019, Excel® 2016, and so on.

Learning Objectives

  • You will be able to explain how to apply a variety of LOOKUP functions in order to work more efficiently in Excel.
  • You will be able to recognize why the INDEX and MATCH combination is often superior to VLOOKUP or HLOOKUP.
  • You will be able to identify what types of user actions can trigger #REF! errors.
  • You will be able to discuss how to utilize Excel’s IFERROR function to display alternate values when VLOOKUP returns an error.

Details

Date:
January 5
Time:
1:00 PM - 3:00 PM EST
Cost:
$199
Event Category:
Event Tags:
https://www.lorman.com/training/accounting/advanced-excel-skills-for-accountants?affiliate=NPCS&p=19623&c=1830

Venue

On Your Computer, Phone or Tablet

Organizer

Lorman
View Organizer Website

Questions or Corrections? Contact us by Clicking Here.

Want to Post an Event?

Go HERE for Single Day Events.

Go HERE for Multi-Day Events.

Exciting New Content Upcoming Live Events Special Offers & More!
Don't miss out! Get Weekly Alerts on ...
Stay up to date
Don't miss out on the latest Content & Events!
0
Would love your thoughts, please comment.x
()
x