|
|
| Accelerate Excel: Internal Control | (160825_N) |
Course CPE: 2 hours
Fields of Study: Personal Development–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: 16PPM0825
Shipping Weight: 0lbs. 0oz. |
| Price:
$147.00 |
|
|
|
|
Recording Date: August 8, 2016
Presenter: David Ringstrom
Program Description:
In this comprehensive webcast, Excel expert David Ringstrom, CPA, shows you how to implement internal control features within your Excel spreadsheets. He uses a simple invoice form as a teaching aid to demonstrate various ways to control users’ actions within an Excel spreadsheet and to protect worksheets and workbooks from unauthorized changes.
David covers such topics as the IFNA, IFERROR, and ISERROR functions; the Data Validation feature; the VLOOKUP function; the hide and protect features; the SUMIF function; and Conditional Formatting. David teaches from the version of Excel in use by the majority of attendees, but he explains any differences in Excel 2007, 2010, 2013, and 2016. His webcasts are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants’ questions, so come ready to pick his brain. David’s detailed handouts serve as reference tools you can fall back on after participating in one of his webcasts. He also provides an Excel workbook that includes a majority of the examples he uses during each session.
Topics Typically Covered:
- Compare and contrast IFNA, IFERROR, and ISERROR functions and learn which versions of Excel support these worksheet functions.
- Create an in-cell list by way of Excel’s Data Validation feature.
- Go behind the scenes in a workbook to check for worksheets that can’t be viewed or hidden from Excel’s primary user interface.
- Improve the integrity of spreadsheets with Excel’s VLOOKUP function.
- Make it harder for a user to circumvent data validation and easy for you to identify when someone has attempted to do so.
- Preserve key formulas using the hide and protect features.
- Toggle the Locked status of a worksheet cell on or off by way of a custom shortcut.
- Use Conditional Formatting to color code your data, identify duplicates, and apply icons.
After completing this course, you will be able to:
- Recognize lookup formulas to find and access data automatically from lists
- Identify Excel’s Table feature to future-proof elements of your spreadsheet
- Identify how to use Excel’s Data Validation feature to restrict data entry to a list of permissible choices
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.
|
|
|
