Our Partners






























NASBA Sponsor

Improve Spreadsheets by Building Controls in Excel
Course Code:
DPBSISB2
Program Level:
Intermediate
Description:
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.
Program Content:
The major topics that will be covered in this class include:
- 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:
After attending this presentation you will be able to …
- 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 attend:
Any Excel user that wants to learn how to create controls within Excel to improve accuracy
Developed By:
DataSmithPro
Instructor:
Bryan L. Smith, CPA.CITP, CISA
CPE Credit:
2
Field of Study:
Auditing (2.0 CPE)
Prerequisites:
A good knowledge of using Excel
Advanced Preparation:
None
Format:
Group-Internet-Based
OR
Register By Phone: Call 877.370.2220 and press “1” for the webinar hotline to register
Price
Single Registration
$89.00
Upcoming Dates
- 5/23/2025 @ 2:00 PM
- 6/5/2025 @ 9:30 AM
- 6/21/2025 @ 10:00 AM
- 7/8/2025 @ 4:00 PM
- 7/26/2025 @ 10:00 AM
- 8/5/2025 @ 10:00 AM
- 8/22/2025 @ 11:30 AM
- 9/12/2025 @ 10:00 AM
- 9/27/2025 @ 10:30 AM
- 10/7/2025 @ 3:30 PM
- 10/22/2025 @ 10:00 AM
- 11/6/2025 @ 3:00 PM
- 11/18/2025 @ 2:00 PM
- 12/10/2025 @ 9:30 AM
- 12/27/2025 @ 12:00 PM
- 1/5/2026 @ 10:30 AM
- 1/21/2026 @ 9:30 AM
- 2/6/2026 @ 2:30 PM
- 2/17/2026 @ 10:00 AM
- 3/19/2026 @ 2:00 PM
- 3/31/2026 @ 3:00 PM
- 4/9/2026 @ 9:30 AM
- 4/21/2026 @ 9:30 AM
All times are Eastern Time Zone