Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Learn how to create PivotTables, modify their structure and formatting, use timelines, and group values. Once you’ve mastered PivotTables, you’ll discover there are a variety of ways you can use them to add value to your projects.
Explore PivotCharts and learn how to add a visual component to really help the data tell a story. PivotCharts are similar to static charts in many ways, with a plethora of layouts and styles to choose from or customize. Since a PivotChart is connected to a PivotTable, it automatically updates to reflect any changes to the PivotTable.
Understand how to use Excel’s Trace Precedents, Watch Window, and Evaluate Formulas features to aid with error detection and resolution. Learn how to use lookup and reference functions to locate specific values in a set of data. Lastly, this course will explain how to perform calculations across multiple worksheets that have identically positioned data or matching categories.
This course comes with a downloadable learner guide, quick reference guide and practice files.
Topics Include:
- PivotTables
- PivotCharts
- Troubleshoot Formulas
- Advanced Formatting
- Advanced Formulas
- Macros
Go from one course to 150+ at your finger tips.
Get this course, plus unlimited access to a curated library of on‑demand courses, with the new PD Pro Subscription. One annual purchase gives you the flexibility to learn anytime across Ethics, Tax, Accounting, Leadership, AI, and more.
Key Takeaways
By the end of the course, you will be able to:
- Harness PivotTables & PivotCharts to analyze data.
- Record macros to automate repetitive tasks.
- Build formulas with IF, SUMIF, VLOOKUP, HLOOKUP functions.
- Analyze complex data using What-If Analysis and Goal Seek.
Who Will Benefit
Business professionals with an excellent understanding of Microsoft Excel looking improve productivity and functionality when 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.