|
|
| Accelerate Excel: Minimizing Errors(151102_N) |
Course CPE: 2 hours
Field(s) of Study: Computer Software & Applications–2 hrs
Program Level: Intermediate
Prerequisites: Previous training or research on subject matter being taught. Such persons are often at a mid-level within the organization, with operational and/or supervisory responsibilities.
Advanced Preparation: None
Delivery Method: Self-Study |
Item
Number: 15PPM1102
Shipping Weight: 0lbs. 0oz. |
| Price:
$147.00 |
|
|
|
|
Recording Date: November 2, 2015
Presenter: David H. Ringstrom
Program Description:
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
- Recognize the advantage of using range names to minimize errors, save time in Excel, serve as navigation aids, and can store information in a hidden location
- Select techniques that minimize errors
- Recognize how to minimize errors by arranging worksheets or workbooks side by side while you build formulas
- Recognize how to incorporate check figures and alarms into your work
- Identify master look-up functions, which can lower the risk of referring to an incorrect cell
- Recognize how to restrict how others use your spreadsheet, including using the Scroll Area and Very Hidden properties to protect sensitive worksheets
- Identify how to 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
- Recognize techniques that automatically provide fall-back positions in the event that you need to see an earlier version of your spreadsheet.
For more information regarding refund or concerns, please contact our offices at (800) 677-2009.
The Consultants’ Training Institute (CTI) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org. |
|
|
