Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
This course is designed to help users extract the most analysis out of their data using Pivot Tables. It covers a few simple and some complex techniques to analyze data in various ways using multi-field techniques, Formula Fields, Grouped fields, Numeric distribution, Pivot Charts and more.
KEY TAKEAWAYS:
By the end of this course, participants will be able to:
- Use multiple data field instances to extract a variety of analysis from data
- Work with Grouped fields to streamline reports
- Understand Formula fields and how formula fields work within Pivot Tables
- Combine Analytical techniques to uncover powerful ways to analyse and visualize data Use Pivot Charts to bring a visual aspect to reports
WHO WILL BENEFIT:
Anyone who works with Pivot Tables to create analytical reports and those who are responsible for data analysis as a large component of their job.
How to Access The Course
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)
Paul Mascarenhas, BSc., MBA is a specialist in Strategic Analysis and Communications. 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.