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

Register Online

Attendee Information

Please select one of the following options to register for this webinar:

Webinar Details

Note: All session times are in the Eastern time zone.*Date & Time

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

Developed By

Your Instructor

Shopping Cart

Choose Account Type