Online Directory | NACVA Site Search:

Accelerate Excel: Tips & Tricks

Practice Management

 Accelerate Excel: Tips & Tricks
CPE Credit

Program Type: Recorded Webinar (Audio, PPT Presentation)
Program Level: Intermediate
Prerequisites: Previous training or research on subject matter being taught.
Advanced Preparation: None
Delivery Method: Group Internet-Based
CPE Credits: Two (2) Hours
Fields of Study: Computer Software & Applications
Item Number: 14PPM1006D
Shipping Weight: 0lbs. 0oz.
Price: $110.00
Program Description

In this webinar Excel expert David Ringstrom, CPA shares many of his favorite tips and tricks. David is fond of stating "Either you work Excel, or it works you!" His courses are designed to help you become immediately more effective in Excel. David will teach from Excel 2010, but his materials include tips and techniques specific to Excel 2013, Excel 2010, Excel 2007, and Excel 2003.

Learning Objectives

After completing this webinar, attendees will be able to:

- Discover techniques that automatically provide fall-back positions in the event that you need to see an earlier version of your spreadsheet
- Establish steps to take if you can't open a damaged workbook
- Rate the right and wrong ways to make Excel appear on two or more monitors
- Convert Excel 97-2003 files to modern workbook formats with ease
- Utilize Compatibility Checker to save time when saving workbooks as .XLS files
- Utilize a keyboard shortcut to simultaneously paste data and column widths
- Create your own shortcuts via Excel's Quick Access toolbar
- Discover how to disable worksheet animation in Excel 2013
- Discover the Flash Fill feature in Excel 2013, as well as alternatives to use in earlier versions of Excel
- Edit PDF documents in Word 2013--useful for unlocking data you wish to edit in Excel
- Verify the most efficient way to link Word documents and Excel spreadsheets
- 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
- Embed frequently used lists, such as employees, departments, or key customers into Excel's interface for use with any spreadsheet
- Avoid starting spreadsheets from scratch: use prebuilt templates, or create your own
- Utilize mouse clicks and keyboard shortcuts that transform how you work in Excel
- Span Excel across two or more monitors in the most efficient fashion
- Convert PDF-based documents into Excel spreadsheets by way of Word 2013

Who Should Attend

Practitioners who may benefit from using Excel more effectively


David H. Ringstrom, CPA
Mr. David Ringstrom is President and Founder of Accounting Advisors, Inc. He started the firm in 1991 and provides consulting and training services nationwide. He is a nationally recognized Microsoft® Excel expert, and regularly teaches live webinars on spreadsheets and other topics. David has written freelance articles on Microsoft® Excel and accounting software for over 15 years, and he has served as the technical editor for over 25 accounting software reference books.