Back to Search

Excel PivotTables for Accountants

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

Where
Hilton Garden Inn - Pbg/Southpointe
Canonsburg - Map it

CPE Credits
4-A&A; 4-Other

Details

 Pricing

PICPA Member: $285 | Nonmember: $385

CLE Credit Add-On: $50


 More Information

Course No.
722301
Level
Advanced
Prerequisites
Fundamental knowledge of Microsoft Excel - 2007 or newer 

Description

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.

Highlights

  • 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


Speaker(s)

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. ...