08/21/2024
11 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 will bring numerous features and functions to your attention that fly under the radar for many Excel users. The Table feature offers tremendous automation and data integrity improvements in any version of Excel, as do dynamic array worksheet functions in Excel 2021 and Microsoft 365. You'll see how to create self-updating stock quotes in Excel, use a better alternative to merged cells, unlock hidden shortcuts, and much more.
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 who seeking to implement ease of use and accessibility features in Excel.
Topics typically covered:
- Adding Full Screen View to the Quick Access Toolbar to view more rows in large spreadsheets
- Streamlining the filtering of lists using the Slicer feature with tables
- Comparing Center Across Selection to Merged cells for centering text across two or more columns
- Navigate Excel menus entirely by keyboard shortcuts
- Removing the Table feature from a worksheet if it’s no longer needed
- Troubleshooting the #SPILL! error that can arise in certain circumstances regarding dynamic array formulas in Excel 2021 and Microsoft 365
- Understanding how the Table feature automates formula management within lists.
- Recording a macro to automate using Center Across Selection
- Sorting lists of data dynamically from elsewhere in a spreadsheet with the new SORT function
- Managing cumbersome lists of data using the Table feature
- Making the same edits on multiple worksheets at once by grouping worksheets
- Learning how the Table feature empowers you to improve the integrity of Excel spreadsheets
Learning objectives:
- Recall the menu in Excel where the Table feature resides
- Specify which command the Remove Rows command appears on within the Power Query Editor
- State which section of Excel's File menu enables you to mark a document as trusted
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.