Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
This course is designed to teach participants the importance of the PivotTable tool. This course demonstrates how to create pivot tables to make data analysis an easy task for all accountants. Participants will learn, step-by-step, the process for creating pivot tables and pivot charts for reporting. Set-up options will also be covered.
This session is presented using Excel 2019/Office 365. Regardless of the version you are using, most concepts covered in this course apply to all versions of Excel.
Key Topics:
- Pivot tables for data analysis
- Pivot table creation
- Pivot charts
This course is part of the Microsoft Power BI Bundle.
Please note, this course contains an assessment component. Learners are permitted multiple attempts to complete the course assessment with a passing grade.
Key Takeaways
By the end of this course, you will be able to:
- Determine the advantages of using PivotTables to analyze data from multiple dimensions.
- Apply the step-by-step process to create PivotTables.
- Choose the PivotTable options that best fit your needs.
- Use Pivot Charts to present your data graphically for the most effective analysis.
Who Will Benefit
Finance Professionals looking to enhance their knowledge of the PivotTable tool
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
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.
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)
Bryan Smith, CPA, CITP, CISA, serves as a trusted adviser to CPAs in public accounting, as well as business and industry, on all aspects of information technology. Bryan’s expertise includes in-depth knowledge of paperless work flow solutions, the impact of technology on internal controls, strategic IT infrastructure design and information security best practices. As a nationally recognized author and presenter on information technology issues impacting CPAs, Bryan is passionate about the opportunities for CPAs to benefit from safe and secure computing.