On-Demand

2 CPE

Surgent's Improve Spreadsheets by Building Controls in Excel

On-Demand
2 CPE

This course is delivered as a recorded video. After completing all sessions, you must pass the final exam with a minimum score of 70% to receive credit.

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.

Learning Objectives

  • Apply best practices when creating spreadsheets
  • Determine which controls to develop for spreadsheets
  • Use controls to build more accurate spreadsheets

Major Topics

  • 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

CPE Credits Available

2 CPE
2
Auditing

Things to Know About This Course

Course Level

  • Intermediate

Professional Area of Focus

  • Accounting & Auditing
  • Peer Review

Prerequisites

A working knowledge of Excel

Advanced Preparation

None

Intended Audience

Any Excel user that wants to learn how to create controls within Excel to improve accuracy

Provider

Surgent CPE

Purchase This Course

  • COCPA Member

    $ 109 109
    Join

  • COCPA Non-Member

    $ 142 142
    Your Price

Please login to register.