10/02/2025
1 am PT / 12 pm MT / 1 pm CT / 2 pm ET
*approximate length: 45 minutes to 1 hour
Presenter: David Ringstrom, CPA
In this presentation, author and Excel expert David H. Ringstrom, CPA, will guide participants through a comprehensive exploration of essential Excel keyboard shortcuts and time-saving techniques. Attendees will learn how to streamline their workflow with menu keyboard shortcuts, copy and paste shortcuts, and efficient worksheet navigation shortcuts. David will also demonstrate the power of Ctrl-R and Ctrl-D keyboard shortcuts, as well as the Show Formulas feature and formula auditing keyboard shortcuts. Participants will discover how to quickly hide/unhide rows and columns using keyboard shortcuts, as well as how to paste column widths effortlessly. Additionally, David will share the Alt-Down Arrow shortcut for simplifying data entry and reveal the secret to restoring Full Screen view. Attendees will also gain valuable insights into reorganizing the Quick Access Toolbar and avoiding the file close trap. As a bonus, participants will receive a 50 Excel Keyboard Shortcuts tetmplate to help them master these time-saving techniques. Don't miss this opportunity to enhance your Excel skills and boost your productivity!
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.
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.
Topics typically covered:
- Triggering the arrow keys to scroll the worksheet instead of navigating to an adjacent cell
- Creating a filter shortcut on the Quick Access Toolbar
- Creating keyboard shortcuts for repetitive Excel tasks
- Exploring shortcuts that can streamline copying and pasting data in Excel
- Displaying all formulas in a worksheet at once with the Show Formulas feature
- Accessing a free template in Excel that provides a listing of 50 keyboard shortcuts
- Selecting various areas of a worksheet with keyboard shortcuts
- Hiding and unhiding columns and rows quickly by way of keyboard shortcuts
- Most features and functions work in Excel for Mac as well but expect differences
- Simplifying filtering tasks by adding a Clear Filter shortcut to the Quick Access Toolbar
- Understanding how the Quick Access Toolbar may be evolving in Microsoft 365
- Utilizing the Error Checking command to locate cells that contain errors within a worksheet
Learning objectives:
- Identify the keystroke that you use to activate Quick Access Toolbar shortcuts
- State the Quick Access Toolbar command that allows you to filter a list based on a cell's contents with one click
- Name the keyboard shortcut that reveals a list of previous entries within the area above and below the currently selected cell
Level: Basic
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.