In this session, CPA and author of "Microsoft 365 Excel for Dummies" David Ringstrom delivers another collection of powerful speed-enhancing techniques to help you work more efficiently in Excel. David begins by demonstrating shortcuts for navigating files and personalizing the Quick Access Toolbar. He then shifts into rapid text cleanup techniques that use Flash Fill and Text to Columns, followed by fast methods for identifying and removing duplicates with conditional formatting and the UNIQUE function. You’ll also learn how to sort data consistently using custom lists, apply lesser-known keyboard and menu shortcuts, and accelerate formatting tasks using smart paste options. The session concludes with a practical walkthrough of combining worksheets with Power Query to streamline data consolidation.

David demonstrates every technique at least twice: first on a PowerPoint slide with numbered steps, and then live in Excel for Windows using the subscription-based Microsoft 365 version. Differences between Microsoft 365 and earlier perpetual versions of Excel (2021, 2019, and earlier) are clearly identified during the session and reinforced in the accompanying handouts. Participants also receive an Excel workbook containing many of the examples used in the presentation.

This webinar is available with NO ADDITIONAL FEE if you have an active all access membership or webinar membership or can be purchased for $29.00!

Instructor: David Ringstrom Course No: COMP-SPEED2-G34125 Recommended CPE: 2.00 Delivery Method: Group Live - Seminar Date Offered: 3/2/2027 10:00 AM - 12:00 PM Level of Knowledge: Basic Prerequisites: Prior experience with Microsoft Excel is recommended Advanced Preparation: None Registration Requirements: No registration is required Recommended Field of Study: Computer Software and Applications Webinars - Group

Add To Your CartBuy A Membership