Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
As an accountant, familiarity with Excel is essential, but while the fundamental functions are important, going beyond the basics to learn in-depth applications and analytics can save you time and stress. While most Microsoft Excel courses are geared toward general business use, we offer Excel courses specifically for CPAs and conveniently bundled together, so you can hone your knowledge and gain new skills all under the instruction of a true expert!
You'll gain credit for each course, and after completing the program, you'll receive a certificate to boost your resume and prove you've put in the work to enhance your skills.
Pre-Live Sale: Act fast and save $150 off this on demand certificate until April 30, 2025.
This certificate incorporates content from two existing certificates:
- Microsoft Excel and Data Analytics (Fundamentals)
- Microsoft Excel and Data Analytics (Advanced)
Note: This certificate will be available to view on-demand starting April 30, 2025.
Topics Include:
- Introduction to Formulas
- Filtering, Sorting and Removing Duplicates
- Basic Charts
- Range Names and the Auditing Tool
- VLOOKUP, HLOOKUP, CHOOSE, MATCH and INDEX Functions
- Tables
- IF Statements
- Text Functions
- Date, Time Functions and Circular References
- Conditional Counts, Sums and Averages
- Conditional Formatting
- Pivot Tables
- Advanced Charts and Controls
- Descriptive Statistics
Key Takeaways
This certificate will provide you with:
- A thorough overview of all aspects of Excel, including practical ways to perform job functions.
- Excel templates to follow along with the course and to keep as a useful reference.
- Relevant examples designed for finance and accounting professionals.
- A resume-boosting Excel certificate upon completion of all the included courses.
- 14 on-demand Excel courses so you can complete them when it’s convenient.
Earn a Digital Badge
Our new collection of digital badges can be earned through the completion of any of our certificate programs offered in our professional development catalogue. Collect these digital badges to add to your website, social profiles, email signature and more. These badges are an easy way to visually communicate your skills and accomplishments to your peers and network. Digital badges will be awarded based on course completion requirements.
Who Will Benefit
CPAs and finance professionals wishing to increase their proficiency in Microsoft Excel.
Disclaimer
Most of CPA Ontario's 450+ on-demand courses are compatible with the mobile app. Unfortunately, this on demand course is not compatible. For the best learning experience, we suggest you use your computer.
How to Access the Course
We're pleased to invite you to register for our Certificate courses. Whether or not you're a CPA, you're more than welcome to join us on this learning journey. To get started, you'll need to create an account. Don't worry if you don't have a CPA Ontario ID yet; you can easily set up your account right here. Let's begin your learning adventure together.
To access the course please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.
Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Dr. Wayne Winston is a Professor Emeritus of Decision Sciences at the Kelley School of Business at Indiana University. He holds a B.S. in Mathematics from M.I.T. and a PhD in operations research from Yale. He won more than 40 teaching awards at Indiana University. He has written more than a dozen books including "Marketing Analytics", "Data Analysis and Decision Making", "Operations Research", "Practical Management Science", "Excel 2019 Data Analysis and Business Modeling", and "Mathletics." Dr. Winston has taught classes and consulted for many leading global organizations. He is also a two-time Jeopardy! champion and has consulted for the NBA’s Dallas Mavericks and New York Knicks.