More Excel Speed Tips (Currently Unavailable)
Author: David H. Ringstrom
||3 hours for CPAs
Thanks to the success of our popular Excel Speed Tips presentation, Excel expert and CPA David H. Ringstrom has developed a follow-up session packed with even more ways to save time and effort in Excel. 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.
- Avoid frustration by understanding the nuances between Enter and Edit modes.
- Avoid merging cells--use the Text Box feature instead for paragraphs of text.
- Create a keyboard shortcut for simultaneously pasting data and column widths.
- Discover how to quickly access folders and workbooks, no matter either on your computer or a network.
- Learn the right and wrong ways to make Excel appear on two or more monitors.
- Master the nuances--and power--of Excel's Transpose feature.
- Overcome user interface annoyances in by making simple adjustments to Excel's options.
- See steps to take if you can't open a damaged workbook.
- Simplify repetitive tasks by creating your own keyboard shortcuts.
- Streamline redundant data entry with a handy keyboard shortcut.
- Strike through list items with a custom shortcut.
- Identify the SQL statement that can be used to combine worksheets together.
- Identify the the mouse action that reveals a hidden menu for moving columns/rows.
- Identify the location of Excel's Text Box feature.
NASBA Field of Study
Computer Software & Applications (3 hours)