Error-Proofing Excel Spreadsheets ON DEMAND
Available Until
Your Desk
5.0 Credits
Member Price $145.00
Non-Member Price $167.00
Overview
It is far too easy to create an Excel spreadsheet that is laced with errors, resulting in inaccurate outputs that can ruin your reputation. This course is designed to help you build more accurate, reliable, and user-friendly Excel workbooks. This course will guide you in minimizing data entry mistakes, formula errors, and structural issues. Whether you are a beginner or an experienced Excel user, this course will teach you how to safeguard your spreadsheets against common pitfalls and enhance their long-term usability.
Highlights
Error-proofing excel spreadsheets. Data entry error-proofing. Formula and function accuracy. Auditing and error checking. Spreadsheet organization. Formatting for readability. Reviewing and testing. Use a peer review. Security and permissions.
Prerequisites
None.
Designed For
CPAs, CFPs, financial advisers, and other accounting professionals.
Objectives
Recognize the benefits of using data validation in Excel. Recall the best ways to format a spreadsheet, and which methods to avoid. Recognize the situations in which absolute and relative cell references should be used. Specify the tools available for checking logical and formulaic issues in Excel. Recall the tools that can be used to clean data. Recognize the reasons for not storing numbers as text. Recall the Excel features that allow you to monitor selected cells. Recognize the situations in which named ranges should be used. Specify how conditional formatting can be used to improve a spreadsheet, and more.
Preparation
None.
Notice
None.
Leader(s):
Leader Bios
Steven Bragg, Western CPE
Steven M. Bragg, CPA, is a full-time book and course author who has written more than 70 business books. He provides Western CPE with self-study courses in the areas of accounting and finance, with an emphasis on the practical application of accounting standards and management techniques. A sampling of his courses include the The New Controller Guidebook, The GAAP Guidebook, Accountants’ Guidebook, and Closing the Books: An Accountant’s Guide. He also manages the Accounting Best Practices podcast.
Steven has been the CFO or controller of both public and private companies and has been a consulting manager with Ernst & Young and an auditor with Deloitte & Touche. He holds an MBA from Babson College, a Master of Finance from Bentley College, and a BA from the University of Maine (summa cum laude).
Non-Member Price $167.00
Member Price $145.00