Excel Speed Tips (Currently Unavailable)
Author: David H. Ringstrom
||3 hours for CPAs
In this popular webcast Excel expert David Ringstrom, CPA shares dozens of tricks that he uses to fly through Excel every day. Remember, either you work Excel, or it works you!
David’s materials cover Excel 2016, 2013, 2010, and 2007. When applicable, some slides include alternate instructions for Excel 2003. In this presentation, he demonstrates techniques in Excel 2010, as he finds it’s presently the version most widely utilized by Excel users. David’s detailed handouts serve as reference tools you can fall back on after completing one of his courses. He also provides an Excel workbook that includes a majority of the examples he uses during each session.
Publication Date: October 2015
Practitioners who may benefit from using Excel more effectively.
- Add the hidden Form Command back to Excel 2007 and later.
- Avoid disabled features by converting Excel 97-2003 files to modern workbook formats with ease.
- Avoid repetitive work by creating a keyboard shortcut for Excel's Freeze Panes feature.
- By-pass the filter drop-down lists by filtering based on cell contents with a single keystroke or mouse click.
- Convert XLS workbooks to the modern XLSX format with two keystrokes.
- Discover how to quickly access folders and workbooks, no matter either on your computer or a network.
- Discover techniques that automatically provide fall-back positions in the event that you need to see an earlier version of your spreadsheet.
- Double-check manual inputs with ease by having Excel read numbers aloud to you.
- Eliminate duplicates form 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 onto a page.
- Navigate large workbooks with ease by way of a hidden menu, as well as keyboard shortcuts.
- Restore "classic" Print Preview functionality to Excel 2007 and later.
- Save time when saving workbooks as .XLS files by dispatching the Compatibility Checker.
- See how the Table feature allows you to transform filtering and automate formula entry.
- Simplify repetitive tasks by creating your own keyboard shortcuts.
- Wrangle long lists of data by filtering instead of sorting.
- Recognize how to set Excel to automatically back-up key spreadsheets.
- Identify how to add and remove icons from Excel's Quick Access Toolbar.
- Identify which types of list data can be filtered in Excel.
NASBA Field of Study
Computer Software & Applications (3 hours)