Courses

Surgent's Improve Spreadsheets by Building Controls in Excel

Register

Member Price: $109.00 Non-Member Price: $139.00

Developer:: SURGENT MCCOY SELF-STUDY CPE, LLC
CPE Credits:: Auditing: 2.00
Fields of Study:: Auditing
Level:: Intermediate

In today's data-driven world, spreadsheets serve as the backbone of business and personal productivity. However, creating complex and error-prone spreadsheets can lead to critical mistakes and inefficiencies. This course aims to equip you with the knowledge and tools to build robust spreadsheets, implementing a range of controls and safeguards to ensure data integrity, streamline processes, and maximize accuracy.

Objective

Apply best practices when creating spreadsheets
Determine which controls to develop for spreadsheets
Use controls to build more accurate spreadsheets

Highlights

Best practices when designing spreadsheets
Creating a proper worksheet structure
Using Excel's built-in features to find errors
Creating custom controls to prevent and find errors
Using links to quickly move to controls
Using conditional formatting to highlight errors

Designed For

Any Excel user that wants to learn how to create controls within Excel to improve accuracy

Prerequisite

A working knowledge of Excel

Advanced Preparation

None