Mastering Shortcuts in Excel

Live Webinar or Recording

December 3, 2025, 12:00 pm - 1:40 pm Eastern

Credit: CPE: 2, ATATX: 1.5, ATAAA: 1.5, ATAOP: 1.5, ATAPU: 1.5 (Live Only)

Unlock the full potential of Microsoft Excel by learning how to streamline your workflow using powerful keyboard shortcuts and customization tools. This practical webinar is designed to help you reduce reliance on the mouse, perform tasks more efficiently, and eliminate repetitive steps through automation.

You'll gain hands-on strategies for navigating Excel's interface quickly, managing data with precision, and using features like the Quick Access Toolbar and Macro Recorder to create custom shortcuts tailored to your needs.

The session includes detailed, step-by-step demonstrations of each technique, along with insights into key differences between Excel versions, including Microsoft 365, Excel 2021, 2019, 2016, and earlier. Attendees will receive comprehensive reference materials, including a downloadable Excel workbook and handouts to reinforce learning and support implementation after the session.

Topics Covered:

• Accessing a free Excel template that lists 50 useful keyboard shortcuts
• Using shortcuts for efficient navigation within tables
• Displaying all formulas in a worksheet at once using the Show Formulas feature
• Streamlining copy-and-paste actions with shortcut keys
• Hiding and unhiding rows and columns quickly
• Enhancing spreadsheet integrity with the Table feature
• Creating list filters using the Quick Access Toolbar and a single keystroke
• Navigating Excel menus entirely by keyboard
• Using keyboard shortcuts to manage the Save As dialog box in Microsoft 365
• Recording macros to automate tasks and assigning keystrokes for quick access
• Reorganizing the Quick Access Toolbar for more efficient use
• Enabling and using Full Screen View via keyboard shortcuts in Excel 2013 and later

Your Benefits For Attending:

• Recall the keyboard shortcut for selecting the current region within an Excel worksheet
• Recall the location of the Scroll Lock indicator in Excel
• Recall the keyboard shortcut that allows you to close the current workbook without closing Excel

This session offers immediate, practical benefits by equipping you with techniques to work faster and more accurately in Excel. Whether you’re looking to increase productivity or reduce manual effort, this training gives you the tools to take control of your Excel tasks.

Level: Intermediate
NASBA Field of Study: Computer Software & Applications (2 hours)
Program Prerequisites: Prior experience working in Microsoft Excel
Advance Preparation: None

Guest Speaker: David H. Ringstrom, CPA - Accounting Advisors Inc.

Level: Basic

Format: Live Webcast

Field of Study: Computer Software & Applications

Program Prerequisites: None

Advanced Preparation: None

Aurora Training Advantage is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

For more information regarding administrative policies such as complaint and refund, and cancellation please contact our offices at 407-542-4317 or training@auroratrainingadvantage.com.

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in accounting.

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in administrative.

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in operations.

Aurora Training Advantage is offering continuing education points designed to recognize dedication to training and excellence in purchasing.