10 Productive Excel Features for Accountants (and 3 Timewasters) (Video) (Course Id 2614)

In this presentation, author and Excel expert David H. Ringstrom, CPA will showcase 10 powerful Excel features that can help accountants work more efficiently, including tools like XLOOKUP, SUMIF, PivotTables, and AutoRecover. You’ll see how to streamline tasks by using structured tables, filter data instantly with keyboard shortcuts, and enhance clarity with conditional formatting. David also shares clever ways to simplify your interface—like adding a Clear Filter button—and explains how to recover from common mistakes. To round things out, he’ll reveal three surprisingly time-wasting aspectis of Excel that can hinder productivity rather than help it.

David is the author of “Microsoft Excel 365 for Dummies”, “Exploring Microsoft Excel’s Hidden Treasures”, and has written or co-authored six other books. He demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Excel for Microsoft 365. David draws your attention to any differences in Excel 2021, 2019 or 2016 during the presentation and in his detailed handouts. The handouts include an Excel workbook with most of the examples he uses during his demonstrations. Most features and functions work in Excel for Mac as well but expect differences.

Excel for Microsoft 365 is a subscription-based product that receives periodic feature updates. Conversely, perpetually licensed versions have year numbers in their names and do not receive any feature updates.

Course Learning Objectives

• State which XLOOKUP argument causes an alternate value to be displayed in lieu of #N/A.
• Recall the keystroke that enables you to select two ore more non-adjacent items from a Slicer.
• Identify the keystroke that you use to activate Quick Access Toolbar shortcuts.