Back to Search
AI, Technology & Innovation
Improve Spreadsheets by Building Controls in Excel (Live Webinar)
DELIVERY FORMAT
Online Virtual
SEMINAR TYPE
PD Seminar
Overview
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.
Applicable for
Any Excel user that wants to learn how to create controls within Excel to improve accuracy
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
Content
- 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
Course Dates & Registration
Aug 6, 2026
9:00AM - 11:00AM
Online Virtual
Bryan Smith
.webp?language=en-CA)
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
Available
Feb 25, 2026
9:00AM - 11:00AM
Online Virtual
Bryan Smith
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
Past
Oct 29, 2025
9:00AM - 11:00AM
Online Virtual
Bryan Smith
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
Past
Jul 8, 2025
9:00AM - 11:00AM
Online Virtual
Bryan Smith
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
Past
Dec 16, 2024
8:30AM - 10:30AM
Online Virtual
Bryan Smith
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
Past
Improving Your Virtual Learning Experience
Live webinars have varying levels of expected interaction, with some requiring microphone and camera capabilities to support a proper learning experience – please email pdreg@bccpa.ca if you have concerns.
In general, we encourage participants to have their cameras turned on to enhance their virtual learning experience. This practice promotes a stronger connection with the instructor and fellow participants, and fosters improved communication and collaboration.
Live Webinar FAQs can be found here.
Registration terms and conditions, including the cancellation policy can be found here. If you require further assistance, please contact the PD Department.
Course Details
Cost
$120
Members
$130
Non-Members
Eligible Hours
- 2
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
Passport
- 3
- Credits
Interested in similar content?
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.
AI, Technology & Innovation
Improve Spreadsheets by Building Controls in Excel (Live Webinar)
DELIVERY FORMAT
Online Virtual
SEMINAR TYPE
PD Seminar
Course Details
Cost
$120
Members
$130
Non-Members
Eligible Hours
- 2
- CPD Hours
- 0
- Ethics Hours
- 0
- AML Hours
Passport
- 3
- Credits
Overview
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.
Applicable for
Any Excel user that wants to learn how to create controls within Excel to improve accuracy
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
Content
- 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
Course Dates & Registration
Aug 6, 2026
9:00AM - 11:00AM
Online Virtual
Bryan Smith
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
Available
Feb 25, 2026
9:00AM - 11:00AM
Online Virtual
Bryan Smith
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
Past
Oct 29, 2025
9:00AM - 11:00AM
Online Virtual
Bryan Smith
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
Past
Jul 8, 2025
9:00AM - 11:00AM
Online Virtual
Bryan Smith
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
Past
Dec 16, 2024
8:30AM - 10:30AM
Online Virtual
Bryan Smith
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
BRYAN SMITH, CISA has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), he has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and has worked with multiple organizations to train and coach staff on proper data analysis techniques.
Past
Improving Your Virtual Learning Experience
Live webinars have varying levels of expected interaction, with some requiring microphone and camera capabilities to support a proper learning experience – please email pdreg@bccpa.ca if you have concerns.
In general, we encourage participants to have their cameras turned on to enhance their virtual learning experience. This practice promotes a stronger connection with the instructor and fellow participants, and fosters improved communication and collaboration.
Live Webinar FAQs can be found here.
Registration terms and conditions, including the cancellation policy can be found here. If you require further assistance, please contact the PD Department.
Interested in similar content?
Starting April 1, 2026, a 2.1% fee will be applied to all credit card transactions. Learn more about this fee and how it relates to PD registrations.