Title: Mastering Excel Skills for Accounting Purposes - PowerPoint PPT Presentation

Description: In this presentation, David Ringstrom, CPA and an Excel expert, covers various ways to improve the accuracy and reliability of your spreadsheets using Excel's lookup functions and pivot tables. He explores alternatives to VLOOKUP such as HLOOKUP, INDEX and MATCH, SUMIF, SUMIFS, and IFNA. The presentation also includes a preview of the new XLOOKUP function, which will soon be available in Microsoft 365. David shows how to turn large amounts of data into meaningful reports through simple clicks with pivot tables. The presentation is comprehensive and provides valuable insights for improving the integrity of your spreadsheets in Excel. – PowerPoint PPT presentation