Comprehensive Excel certificate program

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. 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
• Formulas and functions for financial spreadsheets in Excel
• Excel formatting tools to create impactful financial reports
• Logical and lookup functions in Excel
• Math and finance functions in Excel
• Excel date and time functions
• Excel tables and tabular data
• Introduction to PivotTables in Excel
• Introduction to data preparation and modelling in Excel
• Introduction to data visualization in Excel

While there are no prerequisites, 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.

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

Note: Agenda and curriculum outline(s) coming soon.

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.

• Excel best practices
• Applying Excel formulas and functions to analyze data, model spreadsheets, conduct financial analysis and perform other common Excel activities for business, accounting and finance
• Using PivotTables to quickly summarize data
• An introduction to data preparation and modeling using Power Query, Power Pivot and Data Analysis Expressions (DAX) programming language
• Basic data visualization theory
• Producing charts and data visualizations to create simple management information dashboards

• advanced Excel users
• IT professionals
• business intelligence educators
• consultants
• financial analysts