Webinar: Excel PivotTables for Accountants - Part II

WK255  |  Partner Virtual Events  |  Advanced  |  Scheduled


This webinar is a continuation of Excel PivotTables for Accountants - Part I. It extends and builds upon the foundation of PivotTable topics covered in that course and includes in-depth coverage of using advanced data summary functions and creating calculated items and fields.


Number of Credits Type of Credits
4 Other


Excel PivotTables for Accountants - Part I or equivalent level of knowledge


Making calculations in PivotTables using calculated fields, calculated items, and field settings Enterprise-class PivotTables, including using PowerPivot to build complex PivotTables Analyzing data with PivotTables using advanced techniques PivotTable tips and tricks


Upon completing this course, you should be able to:

  • Create PivotTables and PivotCharts and add advanced elements to PivotTables, such as calculated fields and calculated items
  • Describe three methods for making calculations in PivotTables
  • Create enterprise-class PivotTables from large and complex data sets, using tools such as On Line Analytic Processing and PowerPivot
  • Utilize advanced sorting and filtering techniques, PivotCharts, and GETPIVOTDATA to analyze PivotTable data
  • Describe how to apply specific PivotTable techniques such as Show Report Filter Pages and VLOOKUPs to solve specific issues associated with PivotTables




This webinar is provided by K2 Enterprises. After registering for the course, you will receive an email from K2 with instructions for logging in to the webinar and obtaining your eMaterials.


Member (Early Bird)
Non-Member (Early Bird)
Registration for this event has closed. If you have any question or concerns please give us a call at 615-377-3825 or send us an e-mail at registrar@tscpa.com


Lawrence McClelland, MBA, JD

Mac McClelland, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas.

Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting.

He gained his practical experience in information systems with the National Aeronautics and Space Administration, and has an established practice in business and technology consulting. Mac has taught hundreds of continuing professional education seminars to accountants and business managers in the United States, New Zealand, Australia, Japan, and Southeast Asia. His presentations are highly rated, and he has won several awards for teaching excellence.

Mac has been published in leading business and practitioner journals, including Tax Ideas, Computers in Accounting, Journal of Accounting Education, Chartered Accountants Journal of New Zealand, and the top-rated Journal of Accounting Research.

Back to Facilitators