Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Get up and running with Pivot Tables in this easy to follow course.
Pivot Tables are one of the most powerful tools in Excel and having the skill to effectively use them is a business essential. This CPA Ontario course will teach how to harness the power of Pivot Tables using simple rules and guidelines.
This course will cover a range of topics including data discipline, creating Pivot Tables and configuring them to produce useful reports. The course will explore various features and options, look at troubleshooting tips and introduce concepts that will serve as a platform to more advanced work later on. The instructor will teach using simulated real-life data, presented in a well-paced manner that is easy to follow.
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
Upon completion of this course, you 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.
- Troubleshooting tips.
Who Will Benefit
Anyone who uses Excel to summarize large volumes of data reports or to analyze data in an interactive manner.
Prerequisite(s)
Participants should have a working knowledge of Excel. Microsoft 2010 is the minimum required software for this course. Microsoft Office 365 is recommended.
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. 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.