Applying Internal Control Techniques to Excel Spreadsheets

Live Webinars   |   On-Demand   |   All-Access Plan Manage Preferences    |    View in Browser Applying Internal Control Techniques to Excel Spreadsheets July   6 1 pm - 2:40 pm ET Presenter: David Ringstrom, Owner and Founder of Accounting Advisors, Inc. Credits: CPE (Credit Details) Can't attend live? By registering, you will be able to view the course live, view a recording at any time for 6 months, or both. Viewing Options: View on your computer, tablet, or smartphone Course Reviews: View Testimonials Can't wait? View previously recorded version now Learn More Register Today Course Description   In this practical webinar, you'll learn how to apply internal control techniques to your Excel spreadsheets, improving the integrity of your spreadsheets and minimizing spreadsheet maintenance. Upon successful completion of this course, you'll be able to: Describe how to look up data automatically from lists Utilize Excel's Table feature to future-proof elements of your spreadsheet and minimize ongoing spreadsheet maintenance Explain how to use Excel's Data Validation feature to restrict data entry to a list of permissible choices Compare and contrast the IFNA, IFERROR, and ISERROR functions List which versions of Excel support the IFNA, IFERROR, and ISERROR functions Create an in-cell list using Excel's Data Validation feature Identify worksheets that can't be viewed or hidden from Excel's primary user interface Recognize how to: Use Excel's VLOOKUP function to improve the integrity of spreadsheets Prevent users from circumventing data validation Preserve key formulas using the Hide and Protect features Explain how to restrict users to entering dates within a given range or before/after a given date Identify a range of whole numbers that a user can enter in a worksheet cell Toggle the Locked status of a worksheet cell on or off Utilize the SUMIF function to summarize data based on a single criterion Course Reviews from Past Attendees 100% of attendees said they would recommend this course to others. "Neat Excel tricks." "Materials support the instruction provided, enabling use of this new information." "The steps were shown on a slide first, then demonstrated in Excel and sometimes repeated a second time. This helped make it easy to follow on screen and work alongside in Excel." "Slides were easy-to-follow; excellent examples and tips/tricks provided." "Enjoyed the back-and-forth between slides and examples to explain excel formulas and functions." Learn More Register Today About The Presenter   David H. Ringstrom, CPA, is the owner and founder of Accounting Advisors, Inc., a spreadsheet consulting firm. Mr. Ringstrom provides Microsoft Excel training and consulting services nationwide. He frequently publishes and presents on Microsoft Excel. Mr. Ringstrom is a graduate of Georgia State University. Learn More Register Today All-Access Membership   ● Earn continuing education credit for no additional fee ● Access courses on your computer, tablet, or smartphone ● More than 75 live webinars each month ● More than 750 on-demand courses Learn More Upcoming Webinars Internet Security Tools for Accountants July 5 at 1 pm ET Learn More Detecting & Preventing Payroll Fraud July 7 at 1 pm ET Learn More Excel Spreadsheets: Practical Tips July 11 at 1 pm ET Learn More Questions? Please call us at 703-372-0550 Our Mailing Address: Clear Law Institute | 933 N. Kenmore St, Ste 320 | Arlington | VA | 22201 Remove me from future emails. Manage email preferences.