Digging Deep with Excel Pivot Tables
Total Credits: 1 including 1 Computer Software & Applications - Non-technical
- Average Rating:
- Not yet rated
- Categories:
- ACPEN Industry Institute
- Faculty:
- Dr. Chris Harper, CPA, MBA
- Course Levels:
- Intermediate
- Duration:
- 1 Hour
- License:
- Expires 30 day(s) after program date.
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
| IMPORTANT_CPE Credit Instructions_Read Before Webcast_Updated_2_2025 (442.6 KB) | Available after Purchase | ||
| Digging Deep with Excel Pivot Tables Handout (3.3 MB) | Available after Purchase | ||
Faculty
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
|
Thu, May 22, 2025 - 8:00 AM to 9:01 AM PDT
|
|
Tue, Jun 10, 2025 - 9:00 AM to 10:01 AM PDT
|
|
Sat, Jun 21, 2025 - 10:00 AM to 11:01 AM PDT
|
|
Tue, Jun 24, 2025 - 11:00 AM to 12:01 PM PDT
|
|
Fri, Jul 11, 2025 - 12:00 PM to 1:01 PM PDT
|
|
Mon, Jul 28, 2025 - 1:00 PM to 2:01 PM PDT
|
|
Sat, Aug 02, 2025 - 7:00 AM to 8:01 AM PDT
|
|
Wed, Aug 20, 2025 - 8:00 AM to 9:01 AM PDT
|
|
Mon, Sep 08, 2025 - 9:00 AM to 10:01 AM PDT
|
|
Thu, Sep 25, 2025 - 10:00 AM to 11:01 AM PDT
|
|
Wed, Oct 01, 2025 - 11:00 AM to 12:01 PM PDT
|
|
Tue, Oct 21, 2025 - 12:00 PM to 1:01 PM PDT
|
|
Fri, Nov 14, 2025 - 1:00 PM to 2:01 PM PST
|
|
Fri, Nov 21, 2025 - 7:00 AM to 8:01 AM PST
|
|
Mon, Dec 01, 2025 - 8:00 AM to 9:01 AM PST
|
|
Thu, Dec 11, 2025 - 9:00 AM to 10:01 AM PST
|
|
Thu, Dec 18, 2025 - 4:00 PM to 5:01 PM PST
|
|
Sat, Jan 03, 2026 - 11:00 AM to 12:01 PM PST
|
|
Mon, Jan 19, 2026 - 12:00 PM to 1:01 PM PST
|
|
Wed, Feb 04, 2026 - 1:00 PM to 2:01 PM PST
|
|
Sat, Feb 21, 2026 - 7:00 AM to 8:01 AM PST
|
|
Wed, Mar 11, 2026 - 8:00 AM to 9:01 AM PDT
|
|
Wed, Mar 25, 2026 - 9:00 AM to 10:01 AM PDT
|
|
Thu, Apr 02, 2026 - 10:00 AM to 11:01 AM PDT
|
|
Mon, Apr 13, 2026 - 11:00 AM to 12:01 PM PDT
|
Additional Info
Basic Course Information
Advanced Preparation NoneCourse 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.