Sleeper Features and Functions in Microsoft Excel (Completed)

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 functions such as SORT, FILTER, and UNIQUE in Excel 2021 and Microsoft 365. You'll see how to create self-updating stock quotes in Excel and unlock hidden shortcuts, plus much more.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based Microsoft 365 (formerly Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2021, 2019, 2016 and earlier) during the presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don't change. Perpetual licensed versions have year numbers, such as Excel 2021, Excel 2019, and so on.

Who Should Attend
Professionals seeking to use Microsoft Excel more effectively.

Topics Covered

• Comparing Center Across Selection to Merged cells for centering text across two or more columns
• Creating custom views that will enable you to display all worksheets in a workbook at once as well as hide/display selected worksheets
• Diagnosing the new #CALC error that can arise within improperly crafted dynamic array formulas
• Filtering a cleaned-up accounts receivable aging report to display only overdue amounts
• Gaining control of long lists of data by filtering instead of sorting
• Learning how the Table feature empowers you to improve the integrity of Excel spreadsheets
• Learning how to use a single line of programming code to unhide all worksheets within a workbook
• Making the same edits on multiple worksheets at once by grouping worksheets
• Managing cumbersome lists of data using the Table feature
• Managing data security prompts that may appear when you link external data into Excel spreadsheets
• Navigate Excel menus entirely by keyboard shortcuts
• Recording a macro to automate using Center Across Selection

Learning Objectives

• Identify the menu in Excel where the Table feature resides
• Recognize a dynamic array function from a list of worksheet functions
• State how to use data types within Excel spreadsheets

Level
Intermediate

Instructional Method
Group: Internet-based

NASBA Field of Study
Computer Software & Applications (2 hours)

Program Prerequisites
Prior experience with Microsoft Excel.

Advance Preparation
None