More Excel Speed Tips (Currently Unavailable)

Author: David H. Ringstrom

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 teaches primarily from Excel 2010, but his handouts will include tips and techniques applicable to Excel 2013, Excel 2010, Excel 2007, and Excel 2003.

Publication Date: August 2014

Designed For
Practitioners who may benefit from using Excel more effectively.

Topics Covered

• Learn the right and wrong ways to make Excel appear on two or more monitors.
• Use a keyboard shortcut to simultaneously paste data and column widths.
• Convert Excel 97-2003 files to modern workbook formats with ease.
• Learn the risks--and rewards--of double-clicking on the fill handle in Excel.
• Streamline redundant data entry with a handy keyboard shortcut.
• Avoid frustration by understanding the nuances between Enter and Edit modes.
• Discover how to quickly access folders and workbooks, no matter either on your computer or a network
• See steps to take if you can't open a damaged workbook.
• • Embed frequently used lists, such as employees, departments, or key customers into Excel's interface for use with any spreadsheet.
• Avoid writing repetitive formulas with Excel's Data Table feature
• Learn the most efficient way to link Word documents and Excel spreadsheets
• Edit PDF documents in Word 2013--useful for unlocking data you wish to edit in Excel.
• Discover the Flash Fill feature in Excel 2013, as well as alternatives to use in earlier versions of Excel.

Learning Objectives

• Identify hidden functionality in Excel by double-clicking on common features
• Recognize the different shortcuts that Excel has to offer
• Recognize how to use Microsoft Word 2013 to edit PDFs and transfer the resulting data to Excel

Level
Intermediate

Instructional Method
Self-Study

NASBA Field of Study
Specialized Knowledge and Applications (2 hours)

Program Prerequisites
Must have basic knowledge of Excel.

Advance Preparation
None