Excel Essentials: Tips and Tricks Part II


Overview
In this exciting webcast Excel expert David Ringstrom, CPA shares dozens of the tricks that he uses to fly through Excel every day. David is fond of saying "Either you work Excel, or it works you!" This two-part series is designed to help you work more efficiently in Excel.

Objectives
Discover the features and shortcuts that can make you in an Excel power user.

Emphasis

  • Discover how to disable worksheet animation in Excel 2013.
  • Edit PDF documents in Word 2013--useful for unlocking data you wish to edit in Excel.
  • Learn the most efficient way to link Word documents and Excel spreadsheets
  • Use the Group and Ungroup feature to expand or collapse
  • Transform text by way of Excel's UPPER, LOWER, PROPER, and TRIM functions.
  • When Text to Columns won't do, use the LEFT, MID, and RIGHT functions to extract text from a cell.                                                                                                                                         
  • Quickly clean-up accounting data by way of Excel's Text to Columns feature.
  • Embed frequently used lists, such as employees, departments, or key customers into Excel's interface for use with any spreadsheet.
  • Double-check manual inputs with ease by having Excel read numbers aloud to you.
  • Simplify repetitive tasks by creating your own keyboard shortcuts
  • Discover how to quickly access folders and workbooks, no matter either on your computer or a network                                                                                                                                      
  • Never type $ signs manually in a formula again, use a keyboard shortcut instead!
  • Streamline redundant data entry with a handy keyboard shortcut.
  • Discover techniques that automatically provide fall-back positions in the event that you need to see an earlier version of your spreadsheet.
  • See steps to take if you can't open a damaged workbook.
Who Should Attend:
Practitioners seeking to utilize Microsoft Excel more effectively

Prerequisite
None

Preparation
No advance preparation required
 
Level of Knowledge
Intermediate
 
CPE Credit
2 Hours
 
Delivery Method  
Group Internet Based
 
NASBA Field of Study
Specialized Knowledge and Applications

Author
David H. Ringstrom