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.
This certificate incorporates content from two existing certificates:
- Microsoft Excel and Data Analytics (Fundamentals)
- Microsoft Excel and Data Analytics (Advanced)
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
To access your course, visit the CPA Ontario Blackboard site and sign in using the same username and password used for the Registration Portal.
Important: Course access begins on the date of purchase and remains available for the Access Time specified for the course under Dates and Location. Please review the access time before purchasing. Note that it may take up to 15 minutes after registration for the course to appear in Blackboard.
Registration, cancellation, withdrawal, and 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.