| Accelerate Excel: Minimizing Errors
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
Shipping Weight: 0lbs. 0oz.
David H. Ringstrom, CPA will present numerous techniques that he relies on to improve the integrity of spreadsheets that he builds for himself and others. This session will empower your team with simple ways to avoid introducing errors into their own workbooks. David will focus primarily on Excel 2007 and 2010, but will answer questions specific to other versions, such as Excel 2003 and Excel 2013. Alternate instructions for Excel 2003 and earlier are included in the handout where applicable.
After completing this webinar, attendees will be able to:
- Improve the integrity of your spreadsheets
- Utilize range names to minimize errors, save time in Excel, serve as navigation aids, and can store information in a hidden location
- Utilize design techniques that minimize errors
- Minimize errors by arranging worksheets or workbooks side by side while you build formulas
- Incorporate check figures and alarms into your work
- Master look-up functions, which can lower the risk of referring to an incorrect cell
- Restrict how others use your spreadsheet, including using the Scroll Area and Very Hidden properties to protect sensitive worksheets
- Toggle a single worksheet between a detailed view and a summary view by using the Custom Views feature—instead of creating separate summary and detail worksheets
- Discover techniques that automatically provide fall-back positions in the event that you need to see an earlier version of your spreadsheet.
Who Should Attend
Anyone interested in improving their Excel knowledge
David H. Ringstrom, CPA
Mr. David H. Ringstrom is the owner of Accounting Advisors, Inc., an Atlanta-based spreadsheet consulting firm that he started in 1991. Throughout his career Mr. Ringstrom has spoken at conferences on Microsoft Excel, and written dozens of freelance articles about spreadsheets. He offers Excel and Access training and consulting services nationwide.