![]() Exploring shortcuts that can streamline copying and pasting data in Excel.Displaying all formulas in a worksheet at once with the Show Formulas feature.Capitalizing on keyboard shortcuts to make navigating within a table easier. ![]() Accessing a free template in Excel that provides a listing of 50 keyboard shortcuts. ![]() David also provides an Excel workbook that includes most of the examples he uses during the webcast. 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. Along the way David will point out the nuances involved in certain keystrokes and techniques so that you don't solve one problem in Excel and inadvertently create new ones.ĭavid 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. Not only will David review commonly used keyboard shortcuts, he'll also show you have to craft your own custom shortcuts both by way of Excel's Quick Access toolbar, and also by using Excel's Macro Recorder to create macros that can be played back with a keystroke. Ringstrom, CPA coined the phrase "Either you work Excel, or it works you!" In this comprehensive presentation David will show you ways to move efficiently through repetitive tasks by utilizing keyboard shortcuts in Microsoft Excel.
0 Comments
Leave a Reply. |