Skip to main content
Live Webcast Replay

Digging Deep with Excel Pivot Tables


Total Credits: 1 including 1 Computer Software & Applications - Non-technical

Average Rating:
   9
Categories:
ACPEN Industry Institute
Faculty:
Dr. Chris Harper, CPA, MBA
Course Levels:
Intermediate
Duration:
1 Hour
License:
Expires 30 day(s) after program date.

Dates
Please Note: Programs with a ☾ insignia begin after 5pm or air on the weekend.


Description

This session focuses on the power of pivot tables within Microsoft Excel. We initially discuss the creation of pivot tables and various ways to summarize information. Then we explore ways to utilize summarized pivot table data. The course uses several practical examples that should inspire participants to find their own creative uses for pivot tables.

Basic Course Information

Learning Objectives
  • Create a pivot table in Excel
  • Customize a pivot table
  • Utilize output from a pivot table

Major Subjects
  • Data preparation and cleansing
  • Pivot table creation
  • Pivot table customization
  • Navigating Excel’s PivotTable Analyze tab

Course Materials

Faculty

Dr. Chris Harper, CPA, MBA's Profile

Dr. Chris Harper, CPA, MBA Related Seminars and Products


Chris has been serving the tax and accounting needs of individuals and closely-held businesses since 1998. As a frequent speaker, he has taught a variety of continuing education courses for several state CPA societies. Chris is frequently interviewed by media outlets on a variety of financial, tax, and accounting topics.


Dates

Sat, Feb 21, 2026 - 10:00 AM to 11:01 AM EST
Wed, Mar 11, 2026 - 11:00 AM to 12:01 PM EDT
Wed, Mar 25, 2026 - 12:00 PM to 1:01 PM EDT
Thu, Apr 02, 2026 - 1:00 PM to 2:01 PM EDT
Mon, Apr 13, 2026 - 2:00 PM to 3:01 PM EDT
Tue, May 12, 2026 - 2:00 PM to 3:01 PM EDT
Wed, Jun 10, 2026 - 10:00 AM to 11:01 AM EDT
Wed, Jul 01, 2026 - 2:00 PM to 3:01 PM EDT
Tue, Jul 28, 2026 - 12:00 PM to 1:01 PM EDT
Mon, Aug 03, 2026 - 10:00 AM to 11:01 AM EDT
Fri, Aug 21, 2026 - 4:00 PM to 5:01 PM EDT
Fri, Sep 04, 2026 - 12:00 PM to 1:01 PM EDT
Fri, Sep 18, 2026 - 2:00 PM to 3:01 PM EDT
Tue, Oct 06, 2026 - 4:00 PM to 5:01 PM EDT
Thu, Oct 29, 2026 - 10:00 AM to 11:01 AM EDT
Thu, Nov 12, 2026 - 12:00 PM to 1:01 PM EST
Fri, Nov 20, 2026 - 2:00 PM to 3:01 PM EST
Fri, Dec 11, 2026 - 4:00 PM to 5:01 PM EST
Tue, Dec 29, 2026 - 10:00 AM to 11:01 AM EST
Wed, Jan 06, 2027 - 12:00 PM to 1:01 PM EST
Mon, Jan 18, 2027 - 2:00 PM to 3:01 PM EST
Wed, Feb 03, 2027 - 4:00 PM to 5:01 PM EST
Mon, Feb 15, 2027 - 10:00 AM to 11:01 AM EST
Thu, Mar 11, 2027 - 12:00 PM to 1:01 PM EST
Tue, Mar 30, 2027 - 2:00 PM to 3:01 PM EDT
Tue, Apr 06, 2027 - 4:00 PM to 5:01 PM EDT
Thu, Apr 15, 2027 - 10:00 AM to 11:01 AM EDT
Sat, May 15, 2027 - 12:00 PM to 1:01 PM EDT

Additional Info

Basic Course Information

Advanced Preparation None
Course Developer

Harp DOC, LLC


Designed For Excel users at all levels who want to enhance efficiency when analyzing and reporting data
Yellow Book No
Original Recording Date 04/2025
Prerequisites A basic understanding of Microsoft Excel
Date Added to Catalog 03/2025

Additional Information

Complaint Resolution Policy Please contact Anne Taylor for any complaints.  anne.taylor@acpen.com, (972-377-8199).
Course Registration Requirements Online Registration
Instructional Delivery Method Group Internet Based
Official Registry Statement Business Professionals' Network, Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org
Refund/Cancellation Policy Please contact the ACPEN help desk 1-877-602-9877 or help@acpen.com if you wish to cancel your attendance for a previously purchased webcast and are requesting a refund or transfer.

Reviews

5
4
3
2
1

Overall:      4.8

Total Reviews: 9