Course Description
In this course, author and Excel expert David H. Ringstrom, CPA, will guide you through a comprehensive exploration of essential Excel keyboard shortcuts and time-saving techniques. You’ll learn how to streamline your workflow with shortcuts for the menu keyboard, copying and pasting, formula auditing and worksheet navigation, among others. You’ll 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 template 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 and 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.
Level: Basic
Topics:
- 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
Review our course policies and procedures page for further information