Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Pivot Tables are one of the most powerful tools in Excel and having the skill to effectively use them is a business essential. This two-course bundle will teach you how to harness the power of Pivot Tables using simple rules and guidelines. This bundle covers essential topics such as data discipline, creating and configuring pivot tables, and producing useful reports. It includes various features, options, and troubleshooting tips, with real-life data simulations for easy learning. Explore both simple and complex techniques, including multi-field techniques, formula fields, grouped fields, numeric distribution, and pivot charts.
Courses Include:
- Getting Started with Pivot Tables
- Analytical Techniques with Pivot Tables
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.
Key Takeaways
By the end of this bundle, participants will be able to:
- Identify guidelines for data discipline.
- Understand dynamic and static data.
- Create and configure pivot tables of various levels and complexity.
- Work with pivot tables for meaningful reports.
- 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 analyze 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 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)
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.