Build a foundation of knowledge in blockchain technology and crypto-assets with this all-new, seven-module program. You’ll learn about practical application, trends, tech controls, best practices, risk management and more..

*Special Member Pricing will be displayed for CPA Canada members upon login

CPA Canada partners with external virtual platform providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

Boost your ability to create functional and dynamic spreadsheets with our redeveloped Comprehensive Excel certificate program, a practical and relevant online education program covering essential Excel knowledge related to business and finance using Microsoft 365. This ten-course program features in-depth information on Excel formulas and functions for conducting data analysis, spreadsheet modeling, financial analysis and more.

The program offers extensive resources, eBooks and practical examples that are all yours to keep as you progress through 10 online courses that are video led. Upon completion of this program, you will be a strong intermediate Excel for Microsoft 365 user. You will also be better positioned in your role to optimally serve your clients or organization.

Courses will be available on demand as follows:

• Introduction to Excel: Essential tools for creating spreadsheets (Available now)
• Formulas and functions for financial spreadsheets in Excel (Available now)
• Excel formatting tools to create impactful financial reports (Available now)
• Logical and lookup functions in Excel (Available now)
• Math and finance functions in Excel (Available now)
• Excel date and time functions (Available now)
• Excel tables and tabular data (Available now)
• Introduction to PivotTables in Excel (Available now)
• Introduction to data preparation and modelling in Excel (Spring / Summer 2023)
• Introduction to data visualization in Excel (Available now)

Note: Each on-demand course can also be taken on an individual basis outside of the program if desired.

*Special Member Pricing will be displayed for CPA Canada members upon login*

Taken the previous excel certificate program?

This program has been updated using Excel for Microsoft 365. While many of the core concepts of the previous program have been incorporated, this program features brand new content which includes a course on Data Preparation and Modelling.

Want to know more about how this program differs from our previous Excel certificate program? Please get in touch with our team.

CPA Canada partners with external providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access in-person and virtually. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

Updated as of September 2019 the CPA Canada Guide SOC 1® Reporting on Controls at a Service Organization Relevant to User Entities' Internal Control Over Financial Reporting is a practical resource for practitioners engaged to report on a service organization’s controls, It will assist practitioners performing engagements under the Canadian Standard on Assurance Engagements (CSAE) 3416, Reporting on Controls at a Service Organization Relevant to User Entities’ Internal Control Over Financial Reporting.

Take your guides with you on your eReader, laptop, smartphone or tablet. SOC Guides are available in convenient and searchable eBook format!

Special Member Pricing will be displayed for CPA Canada members upon login

Learn about the new reasonable assurance engagement practitioners can perform on an entity’s cybersecurity risk management program using System and Organization Controls (SOC) for cybersecurity assurance engagement.

For most organizations, it’s impossible to avoid navigating substantial amounts of data. Learn how to cleanse that data, create value-added models and build effective dashboards.

Take it individually or as part of the Data Management Foundations Certificate

*Special Member Pricing will be displayed for CPA Canada members upon login

CPA Canada partners with external virtual platform providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

Microsoft Power BI is an excellent tool for building effective dashboards. Discover the key concepts you need to create data visualizations that communicate meaningful strategic information with your audience.

Take it individually or as part of the Data Management Foundations Certificate

*Special Member Pricing will be displayed for CPA Canada members upon login

CPA Canada partners with external virtual platform providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

Take your performance to the next level by mastering the date and time functions of Excel. This online course explores how these functions work and provides instructions for using them in different contexts.

You will gain the knowledge and skills to use these Excel functions more effectively when managing payroll, holiday hours and large production schedules.

This online video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.

Note: This course can be taken individually or as part of the Comprehensive Excel certificate program.

*Special Member Pricing will be displayed for CPA Canada members upon login*

CPA Canada partners with external providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access in-person and virtually. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

When you invest time and effort into creating a financial report, you want to make sure it gets read. By using Excel’s formatting tools, you will be able to develop vibrant and professional-looking reports. Discover key tools for making appealing and easy-to-understand diagrams, charts, equations and more. This course provides techniques to help you better engage stakeholders so you can do more than just present numbers — you can deliver the message.

This online video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.

Note: This course can be taken individually or as part of the Comprehensive Excel certificate program.

*Special Member Pricing will be displayed for CPA Canada members upon login*

CPA Canada partners with external providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access in-person and virtually. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

Being effective and efficient in your daily accounting and finance work centres on your ability to create data tables. This course covers the key features of effective tabular data sets and structured references in Excel.

This online, video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.

Note: This course can be taken individually or as part of the Comprehensive Excel certificate program.

*Special Member Pricing will be displayed for CPA Canada members upon login*

CPA Canada partners with external providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access in-person and virtually. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

The more you know about Excel formulas and functions, the better equipped you will be to present financial information in meaningful ways. This course provides the basic formulas and functions to transform your Excel sheets into dynamic calculators. You will learn how to apply formulas, build out an income forecasting system and cash flow and balance sheets, and analyze inventory data.

This online video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.

Note: This course can be taken individually or as part of the Comprehensive Excel certificate program.

*Special Member Pricing will be displayed for CPA Canada members upon login*

CPA Canada partners with external providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access in-person and virtually. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

Data privacy is an issue of vital importance to Canadians and organizations. Learn the basics on the legal and regulatory frameworks and what to consider in your organizational planning.

*Special Member Pricing will be displayed for CPA Canada members upon login

CPA Canada partners with external virtual platform providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

The right data visualizations can transform financial statements from distracting to brilliant. This online course reveals the techniques you need to create dynamic charts that suit a wide range of financial information. By learning to present financial data in more comprehensible ways, you will help others make better business decisions.

This online, video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.

Note: This course can be taken individually or as part of the Comprehensive Excel certificate program.

*Special Member Pricing will be displayed for CPA Canada members upon login*

CPA Canada partners with external providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access in-person and virtually. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

Uncover key Excel features to build spreadsheets that will strengthen your expertise in this essential accounting software. This online course provides an overview of Excel’s user interface and explains areas you should understand before you start working with formulas, tables and other advanced features. The resulting knowledge will enhance your accounting knowledge and get you one step closer to Excel mastery.

This online video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.

Note: This course can be taken individually or as part of the Comprehensive Excel certificate program.

*Special Member Pricing will be displayed for CPA Canada members upon login*

CPA Canada partners with external providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access in-person and virtually. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

Take Excel from a tool that simply reports historical results and configure it to respond dynamically to changes in scenarios and turn your spreadsheets into business intelligence tools.

This course begins with looking at logical functions, from the ISBLANK() function through a variety of others which can be leveraged at key times. Explore reference functions that allow you to pull information from different worksheet cells as required.

This online video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.

Note: This course can be taken individually or as part of the Comprehensive Excel certificate program.

*Special Member Pricing will be displayed for CPA Canada members upon login*

CPA Canada partners with external providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access in-person and virtually. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

Your ability as a financial professional to add value to your organization depends on how well you can make sound business decisions.

Strengthening that skill is the focus of this online course, which explores the mathematical, statistical and financial functions within Excel that apply to accounting and financial management. You will learn how to calculate basic statistics and how to forecast and generate a net present value schedule.

This online, video-led course is performed using Excel for Microsoft 365 and includes an eBook and practical examples that are yours to keep.

Note: This course can be taken individually or as part of the Comprehensive Excel certificate program.

*Special Member Pricing will be displayed for CPA Canada members upon login*

CPA Canada partners with external providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access in-person and virtually. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

RPA technology can help your organization achieve higher productivity levels and cost savings. In this online course, learn how to harness the benefits of robotic process automation for work in accounts payable and receivable.

*Special Member Pricing will be displayed for CPA Canada members upon login

CPA Canada partners with external virtual platform providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.

This certificate focuses on robotic process automation benefits and how the use of software robots can enable your business or clients to become more competitive and agile.

*Special Member Pricing will be displayed for CPA Canada members upon login

CPA Canada partners with external virtual platform providers to deliver this program. By registering for this program, you acknowledge your understanding that CPA Canada will share your personal information with those parties who require it to ensure your access. Personal information may include your name, company, email address and Store account number. Also note that you may be asked to create a profile on the external platform that we use to deliver the program, and your information may be visible to other registered attendees on that platform. To learn more about how CPA Canada collects, uses and discloses personal information, please refer to our privacy policy.