Improve Spreadsheets by Building Controls in Excel
Wednesday, April 23, 2025
1:30-3:30 p.m. Central
2 CPE (2 technical)
Course code: 25WX-0287
View pricing
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. This event may be a rebroadcast of a live event and the instructor will be available to answer your questions during the event.
Major subjects
-
Learn best practices when designing your spreadsheets
-
How to create a proper worksheet structure
-
Learn to use Excel's built in features to find errors
-
How to create your 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 your spreadsheets
-
Determine which controls you need to develop for your 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 |
$89.00
|
 Standard Nonmember Fee |
$89.00
|
Our records indicate
you are a
nonmember.
If you register, you will be charged
$89.00
(Standard Nonmember Fee).
Members: Please
log in
to receive member fee.
Instructor
Bryan Smith, CPA, CITP, CISA
Location
Online
Area
of study
Information technology
Field(s)
of study
Auditing - Technical (2.0)
Level
Intermediate
Format
Group Internet Based
Sponsor
NASBA ID#: 108744
Prerequisites
Prereq.
A good knowledge of using Excel
Advance
prep
None
Cancellation
policy
Receive a full refund if you cancel at least four business
days before the event start date.
Learn more
Search CPE catalog
