In this course the focus is on proofing and auditing your spreadsheets. You will learn how to build spreadsheets that validate the accuracy of your calculations and ways to use the Data Validation feature to substantiate data entry. You will also learn techniques to cross-foot your data to ensure accuracy as well as how to use the various Excel Auditing Tools. Excel has 400-500 functions, depending on your version. There are 12 different function categories. In addition, you can create your own functions. This session is presented using Excel 2013. Regardless of the version you are using, ALL concepts covered in this course apply to ALL versions of Excel.
Learning Objectives:
After completing this course you will have the ability to...
- Use the Excel Auditing Tools to validate your calculations
- Use the Data Validation feature to verify data entry
- Apply various methods of ensuring the accuracy of your spreadsheets
Program Content:
The major topics that will be covered in this class include...
- Proofing methods
- Excel Auditing Tools
- Using the Data Validation feature
- Techniques to cross-foot and validate your spreadsheets
Who should attend: Anyone who wants to become an expert in using, auditing and troubleshooting Excel functions and formulas in spreadsheets
Course Name: Excel - Auditing Your Spreadsheets for Maximum Accuracy
Course Code: CXOXLS126S2
Developed By: CPA Crossings, LLC
Instructor: Bryan L. Smith, CPA.CITP, CISA
Prerequisites: None
Advanced Preparation: None
Program Level: Intermediate
Format: QAS Self-Study