Excel Keyboard Shortcuts (Video) (Course Id 2582)

• Who is this course for?
  This course is intended for anyone needing Continuing Professional Education (CPE), particularly CPAs and professionals who use Excel regularly in their work.

• What is this course about or what problem does this course solve?
  This course focuses on teaching essential Excel keyboard shortcuts and time-saving techniques to improve workflow and productivity in spreadsheet tasks.

• How can the knowledge from this course be used?
  Participants can apply the learned shortcuts and tips to streamline their Excel usage, enhance data entry efficiency, and navigate and audit spreadsheets more effectively.

• Why is this course important to a CPA, Accountant, or IRS Enrolled Agent?
  Mastery of Excel shortcuts enables accounting professionals to work faster and more accurately in spreadsheets, which is crucial for managing financial data and reporting tasks.

• When is this course relevant or timely?
  This course is especially timely for users of Excel for Microsoft 365, Excel 2021, 2019, or 2016, as it addresses features and differences across these versions, with updated content as of July 2025.

• How is a course like this consumed or used?
  The course is delivered as a video self-study program, featuring demonstrations with PowerPoint slides and Excel workbooks, along with review and final exam questions to complete online.

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.

Video - NASBA QAS - NASBA Registry - 2582

Course Learning Objectives

• Identify the command 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.

Chapter 1 - Excel Keyboard Shortcuts

Chapter 1 Review Questions

Key Terms