Show Menu

Help  |  Pay an Invoice  |  My Account  |  CPE Log  |  Log in

Webinar

Improve Spreadsheets by Building Controls in Excel

Wednesday, Jan. 27, 2027
1-3 p.m. Central
2 CPE (2 technical)

Course code: 26WX-6711
View pricing

Register Me     Register Multiple

Firm administrators: Please log in before starting the employee registration process.

Alternate dates & more options


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
checkmark 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.
Register Me     Register Multiple

Firm administrators: Please log in before starting the employee registration process.

More program information

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 CPA Crossings, LLC
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

Related programs

Nov. 16, 2026 | K2's Eight Awesome PivotTable Features | Webinar

Nov. 16, 2026 | Microsoft Excel: Moving Beyond the Basics | Webinar

Nov. 16, 2026 | K2's Excel's Best New Features | Webinar

Nov. 17, 2026 | Using ChatGPT With Excel | Webinar

Nov. 17, 2026 | Shortcuts That Excel Users Love | Webinar


Related products

Advanced Excel for Staff: Build Reports and Analyze Data | Self-Study (On-Demand)

Complete Guide to Analyze Data With Excel PivotTables | Self-Study (On-Demand)

Finding Errors in Excel Spreadsheets | Self-Study (On-Demand)

Mastering the Excel Lookup Functions | Self-Study (On-Demand)

Shortcuts That Excel Users Love | Self-Study (On-Demand)


Search CPE catalog