Level: Basic
Available Durations:
- 100 Minutes Live
Description:
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 “Exploring Microsoft Excel’s Hidden Treasures: Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features”. 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.
Who should attend:
Professionals seeking to use Microsoft Excel more effectively.
Topics typically covered:
- Simplifying repetitive tasks by creating your own keyboard shortcuts.
- Adding Full Screen View to the Quick Access Toolbar to view more rows in large spreadsheets.
- Recording a macro for applying a highlight color to any selection of cells and then contrasting two different ways to create keyboard shortcuts for the macro.
- Displaying all formulas in a worksheet at once with the Show Formulas feature.
- Overcoming user interface annoyances by making simple adjustments to Excel’s options.
- Streamlining redundant data entry with a handy keyboard shortcut.
- Accessing a free template in Excel that provides a listing of 50 keyboard shortcuts.
- Creating a keyboard shortcut for simultaneously pasting data and column widths.
- Utilizing keyboard shortcuts to identify precedent and dependent worksheet cells.
- Reorganizing the Quick Access toolbar to prioritize frequently used keyboard shortcuts.
- Exploring shortcuts that can streamline copying and pasting data in Excel.
- Leveraging Excel’s Quick Access Toolbar to create a shortcut that enables you to filter lists with a keystroke instead of multiple mouse actions.
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.
- Recall the worksheet function that works best when limiting Data Validation entries to Less than Or Equal To today’s date.
Format:
Live webcast
Instructional Method:
Group: Internet-based
NASBA Field of Study:
Specialized Knowledge and Applications (2 hours)
Program Prerequisites:
None
Advance Preparation:
None
About the Instructor:
David H. Ringstrom, CPA is the owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. Throughout his career David has spoken at conferences on Microsoft Excel, and written dozens of freelance articles about spreadsheets. He offers Excel and Access training and consulting services nationwide.
Pricing and Format Options:
Click here to learn about the presentation format and view pricing information.
Click here to view other topics.