Please choose between the following three options for navigation.
Gain the fundamental information and tools needed to master making spreadsheets in Excel.
Boost your ability to create functional and dynamic spreadsheets with our Excel certificate program, a practical and relevant online education program covering essential Excel knowledge related to business and finance. This ten-course program features in-depth information on Excel formulas and functions for conducting data analysis, spreadsheet modelling, financial analysis and more.
The program offers extensive resources, ebooks and practical examples that are all yours to keep. Upon completion of this program, you will be a strong intermediate Excel user with the pre-requisite knowledge necessary to pursue further specialization. You will also be better positioned in your accounting practice to optimally serve your clients or organization.
The entire Excel certificate program, including the final assessment, is worth 29 CPD hours. To receive the Certificate of Completion, participants must complete the following courses:
While there are no pre-requisites, we do suggest taking the courses in the above order. All participants must complete the final assessment in order to receive their Certificate of Completion.
Additional options and pricing may be available. See pricing and registration for more details.
Discover the main techniques and best practices for creating dynamic spreadsheet models that better serve your organization or clients.
Enhance your accounting practice by learning the strategies and tools within Excel for creating more functional and reliable spreadsheet templates.
Deepen your understanding of Excel’s built-in date and time functions so you can more effectively perform complex calculations.
Learn how to create effective tabular data sets in Excel so that you can better organize and analyze financial information.
Learn how to use Excel to create interesting and impactful financial reports.
Discover a wide range of powerful tools within Excel to maximize the functionality and impact of your financial spreadsheets.
Discover how to make professional and visually appealing data visualizations in Excel that effectively tell a story and capture your readers’ attention.
Discover the essential tools needed to further develop your learning in Excel and become proficient at creating spreadsheets.
Improve your ability to create and work with PivotTables so that you can more effectively summarize, analyze and present financial data.
Learn how to use key functions in Excel that will help you effectively evaluate financial data and make better business decisions.
Learn the most valuable text and information functions in Excel so you can create more complete financial models.
Learn the purpose of logic and reference functions, and how to use them. Take a deep dive into lookup functions, including VLOOKUP(), and become a master of Excel functions.
CPA Canada Professional Learning and Development Customer Service
Chartered Professional Accountants of Canada (CPA Canada) annually offers its views on priorities for the federal budget. Review past submissions of pre-budget briefs and consultations, and post-budget release opinions and commentary.
Our Firm Directory allows you to search for Canadian CPA firms using our interactive map as well as other criteria.
September 18, 2017
Jointly presented by CPA Canada and CPA Ontario, The ONE is the must-attend, multi-track event of the year, designed for all CPAs who want to be at the top of their game.