Back to Search

Excel PivotTables for Accountants

Aug. 11
8:00 a.m. - 4:00 p.m.

Hilton Garden Inn - Pbg/Southpointe
Canonsburg - Map it

CPE Credits
4-A&A; 4-Other



PICPA Member: $285 | Nonmember: $385

CLE Credit Add-On: $50

 More Information

Course No.
Fundamental knowledge of Microsoft Excel - 2007 or newer 


Consolidate data from multiple sources and analyze large data sets in a fraction of the time. Design multiple PivotTables from a single data source while grouping data into fiscal reporting periods.


  • Features associated with PivotTables, including slicers, Power Query, and Power Pivot
  • Techniques to solve problems in formatting
  • Six elements of a PivotTable report and how they can be used


Brian F. Tankersley, CPA, CITP, has made presentations for 46 state CPA societies, as well as similar organizations across Canada. He writes extensively on technology issues for professional journals, and serves as a columnist and technology eEditor for The CPA Practice Advisor. He has over 20 years of professional experience in accounting, technology, and education.


You May Also Like

Advanced Excel
Oct. 30 | Malvern
Learn Excel skills in six key areas: collaborate with other users and secure workbooks; use tables to analyze and report data; integrate and manipulate data from external sources; create and ...
Technology for CPAs: Don’t Get Left Behind
Aug. 10 | Cranberry
Identify key hardware and software enhancements and updates to operating systems, desktop productivity suites, accounting software, document management systems, and more. Boost the overall performance of your IT investment. ...
Budgeting and Forecasting Tools and Techniques 
Nov. 6 | Cranberry
Discover how to obtain budget data and collaborate with team members using Excel’s Audit Trail as well as shared and merged workbooks. Master Office Data Connections and Open Database Connectivity. ...