Menu

Surgent's Excel: Mastering PivotTables

Overview

PivotTable is a fancy term for an Excel report that summarizes data. If you have not yet had the good fortune of exploring PivotTables, it is about time. In this session, we'll dig into PivotTables, understand the report layout options, and examine PivotTable formulas.

Prerequisites

Basic knowledge of Excel for Windows

Objectives

  • Obtain a basic comfort level using PivotTables
  • Understand the fact that external data sources can feed a PivotTable
  • Use Excel's web browser to retrieve web data

Highlights

  • Explore PivotTable capabilities and functionality
  • Retrieve data from a database and feed it into the PivotTable
  • Pull web tables from web pages into Excel

Register Now

Materials are generally available 3 days in advance of an event. Once you have downloaded the manual, we are unable to cancel your registration.

Event Code:

SU1621

2 CPE Credits
Computer Software & Applications: 2 Credits

Registration

Member Price:
$99
Non-member Price:
$129

Registration is open through 04/24.

Thursday, April 24th

10:00am to 12:00pm

Add to Calendar

Instructor

Jeff Lenning

Related Courses

Microsoft 365 Deployment Best Practices

April 21, 2025

2 Credits
Details
Surgent's Excel Lookups: Moving Beyond VLOOKUP Limitations

April 21, 2025

2 Credits
Details
Surgent's Use the Data Model to Build More Powerful PivotTables

April 21, 2025

2 Credits
Details
© 2025 Kentucky Society of Certified Public Accountants. All Rights Reserved. Contact Us