Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Add powerful new Excel charts to your reports and presentations with Office 365.
With Office 365, Microsoft Excel has brought the power of specialist charting to reports and presentations. This CPA Ontario video learning course will explore Waterfall charts, Pareto charts, Treemaps, Bing Maps, Filled Maps, Histograms and more.
The course includes explanations for using popular charts for various applications. Learn how to use Waterfall charts for more than one type of reporting and how to focus on areas of importance using Pareto charts. Explore the significance of histograms and their role in understanding data.
Get tips on data, chart formatting, and learn about key charting enhancements available in Excel for use with strategic business charts like XY charts and Bubble charts. Participants will receive hands-on experience by practicing along with the course material on a downloadable data file. Easy-to-follow course presentation notes will also be provided.
PREREQUISITE KNOWLEDGE
Participants should have a working knowledge of Excel. Microsoft Office 365 software is required for this course.
KEY TAKEAWAYS
- Creating and tweaking waterfall charts
- Working with statistical charts, including Pareto and Histograms
- Hierarchy charts, including Treemaps and Sunburst charts
- How to use Map charts effectively
- Strategic chart enhancements
WHO WILL BENEFIT
CPAs and other finance professionals who work with Excel charts or anyone who is ready to transition to Office 365.
Unlock learning anytime, anywhere with the Blackboard Learn app
Seamlessly access your on demand courses, assignments, and get PD hours on the go. Learn how to download now and elevate your education experience with the convenience of mobile learning.
How to Access The Course
This is an online session. This course is available 24 hours a day, 7 days a week. Once registered, you can access the material at any time.
However, you will only have access to the course for 90 days after REGISTRATION.
New mobile learning! Download Blackboard Learn from your app store (iOS or Android). Learn more.
To access the course on your computer 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)
Paul Mascarenhas, BSc., MBA is a specialist in Strategic Analysis and Communications and is President of Avancer Learning Inc. He has developed and conducted Information Technology workshops for leading corporations, institutions and government in Canada and internationally for 15 years. Paul loves the outdoors, is an avid angler, and holds a Canadian Recreational Pilot’s permit.