Surgent's Improve Spreadsheets by Building Controls in Excel
Valid for one year from purchase date
Self-study - On-Demand
2 CPE (2 technical)
Course code: 25SS-0257
View pricing
If your organization is exempt
from sales tax, call us at 952-831-2707 to complete your purchase.
Add to cart
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.
Major subjects
-
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
Learning objectives
-
Apply best practices when creating spreadsheets
-
Determine which controls to develop for spreadsheets
-
Use controls to build more accurate spreadsheets
Who should take this program?
- Any Excel user that wants to learn how to create controls within Excel to improve accuracy
Pricing
|
Standard Member Fee |
$109.00
|
 Standard Nonmember Fee |
$109.00
|
Our records indicate
you are a
nonmember.
If you register, you will be charged
$109.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
If your organization is exempt
from sales tax, call us at 952-831-2707 to complete your purchase.
Add to cart
Area
of study
Information technology
Field(s)
of study
Auditing - Technical (2.0)
Level
Intermediate
Format
Self-study - On-Demand
Sponsor
NASBA ID#: 103212
Prerequisites
Prereq.
A working knowledge of Excel
Advance
prep
None
Search CPE catalog
