Menu

Improve Spreadsheets by Building Controls in Excel

Overview

This course will be available for 90 days from your date of purchase. 

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.

Prerequisites

A good knowledge of using Excel

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

Highlights

  • 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

Register Now

Materials are generally available 3 days in advance of an event. Once you have downloaded the manual, we are unable to cancel your registration.

Event Code:

RCPE783

2 CPE Credits
Auditing: 2 Credits

Registration

Member Price:
$99
Non-member Price:
$129

Instructor

Bryan Smith