Bootcamp 2022
Expand Your Excel Expertise: Pivot Tables
By Audrey Roorda
Date and Time: Thursday, August 18, 2022 at 1:30 pm Eastern
Pivot tables are one of Excel’s more powerful features. They allow you to extract data from a large data source and pull it into a compact table that can be changed dynamically. This workshop will look at the type and format of the data needed to produce a successful pivot table first and then move into creating the actual pivot tables themselves looking at various formats, filters, options, and slicers. Basic knowledge of Excel is required.
Presented by: Audrey Roorda, Financial Services Administrator at Edvance
Speaker Bio: Audrey earned a Bachelor of Arts degree with double major in accounting and business administration from Dordt College, Iowa, USA, and her Chartered Professional Accountant designation through the legacy Certified Managerial Accountants of Ontario program. Audrey is instrumental in developing Edvance’s financial services program, providing leadership on cost-per-student calculations, statistical data, and accounting procedures. Audrey has developed an expertise in charity accounting and law as it pertains to independent schools as charities and communicates regularly with Edvance affiliate schools regarding the rapidly changing rules and regulations for school charities to ensure they maintain compliance with the Canada Revenue Agency in this increasingly complex field.
Audience: Anyone who works with Excel data
Session Materials:
Slides: Expand Your Excel Expertise - Pivot Tables (PPT)
Example worksheets: