Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Microsoft Excel is a powerful spreadsheet application that provides quick and accurate numerical calculations and helps make data look sharp and professional.
Learn how to create, edit, and format professional-looking charts so you can present complex data in a way that is meaningful to your audience. Understand the options that are most important when printing or electronically distributing data from Excel. The formulas covered in this course will help you simplify tedious or complex tasks. Learn how to merge text from multiple cells into one using the CONCATENATE function or calculate monthly payments for a large purchase using the PMT function. Dates and times can also be used in formulas to make calculations dealing with time a breeze.
This course comes with a downloadable learner guide, quick reference guide and practice files.
Topics Include:
- Charts
- How to Print and Distribute
- Intermediate Formulas
- How to Manage Data
- Tables
- Intermediate Formatting
- Collaboration
Key Takeaways
By the end of the course, you will be able to:
- Create Bar, Column, Pie and Line Charts.
- Build formulas with absolute & relative cell references.
- Share & protect workbooks to collaborate with others.
- Use conditional formatting for specific data.
Who Will Benefit
Business professionals with a working knowledge of Microsoft Excel who are responsible for managing and working with data.
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. You can also access your course through the Blackboard Learn app (iOS or Android).
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)
This online, interactive training course is presented by CustomGuide, North America’s trusted provider of simulation-based learning for Microsoft products.