Attending the course and successfully completing the post-assessment, will grant you
2 hour/s verifiable CPD, recognised by the various
professional bodies (SAICA, SAIBA, ACCA, IACSA, IRBA & etc). Please note that the
CPD certificate will only be issued once the post-assessment has been completed.
Are you working Excel or is it working you? Many users end up working harder than necessary in Excel carrying out repetitive tasks in an inefficient manner. In this webinar United States-based Excel expert and Certified Public Accountant David Ringstrom focuses on helpful shortcuts that can be used in all versions of Excel. David covers many Excel keyboard shortcuts and even shows you how to create your own custom keyboard shortcuts. He explains (1) when and where to double-click or right-click with your mouse to uncover hidden functionality, (2) how to restore the classic print preview screen in Excel 2010 and later, (3) an alternative to the merged cells feature, and (4) how to have Excel read numbers aloud to you. Tedious tasks, such as locking and unlocking worksheet cells, dont have to slow you down David demonstrates alternatives that are much more efficient. Davids courses are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants questions, so come ready to pick his brain. His detailed handouts serve as reference tools you can fall back on after participating in one of his webcasts. In addition, he provides an Excel workbook that includes a majority of the examples he uses during each session. Davids materials cover Excel 2016, 2013, 2010, and 2007.
Define how to create your own keyboard shortcuts in Excel 2007 and later. Recognize how to take advantage of hidden menus and features. Identify how to unlock hidden functionality by double-clicking on certain aspects in Excel.
Add the hidden Form Command back to Excel 2007 and later. Avoid disabled features by converting Excel 2003 files to modern workbook formats with ease. Avoid repetitive work by creating a keyboard shortcut for Excel Freeze Panes feature. Avoid wasting time when saving workbooks as .XLS files by dispatching the Compatibility Checker. Bypass filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click. Convert .XLS workbooks to the up-to-date .XLSX format with just two keystrokes. Discover how to quickly access folders and workbooks, regardless of whether theyre stored on your computer or on a network. Discover techniques that automatically provide fallback positions in the event you need to see an earlier version of your spreadsheet. Double-check manual inputs easily by having Excel read numbers aloud to you. Eliminate duplicates from a list with just a few mouse clicks. Keep an eye on how much your text is being reduced as you try to squeeze more on a page. Learn how the Table feature allows you to transform filtering tasks. Navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts. Restore classic Print Preview functionality in Excel 2007 and later. Simplify repetitive tasks by creating your own keyboard shortcuts. Wrangle long lists of data by filtering instead of sorting.
Practitioners who may benefit from learning shortcuts that will enable them to use Microsoft Excel more effectively and efficiently.
