Show Menu

Help  |  Pay an Invoice  |  My Account  |  CPE Log  |  Log in

Webinar

Surgent's Excel: Mastering PivotTables

Thursday, April 23, 2026
9-11 a.m. Central
2 CPE (2 non-technical)

Course code: 26WS-0083
View pricing

Register Me     Register Multiple

Firm administrators: Please log in before starting the employee registration process.


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.

Major subjects

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

Learning 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

Who should take this program?

  • Accounting professionals using Excel for Windows

Pricing

Standard Member Fee $99.00
checkmark Standard Nonmember Fee $99.00
Our records indicate you are a nonmember. If you register, you will be charged $99.00 (Standard Nonmember Fee). Members: Please log in to receive member fee.
Register Me     Register Multiple

Firm administrators: Please log in before starting the employee registration process.

More program information

Instructor Jeff Lenning, CPA, CITP
Location Online
Area
of study
Information technology
Field(s)
of study
Computer Software & Applications - Non-Technical (2.0)
Level Basic
Format Group Internet Based
Sponsor Surgent
NASBA ID#: 103212
Prerequisites Prereq. Basic knowledge of Excel for Windows
Advance
prep
None
Cancellation
policy
Receive a full refund if you cancel at least four business days before the event start date.
Learn more

Related programs

April 21, 2026 | Improve Spreadsheets by Building Controls in Excel | Webinar

April 21, 2026 | Excelling at Excel: The Magic of Power Query | Webinar

April 21, 2026 | K2's Supercharging Your Spreadsheet Collaboration | Webinar

April 21, 2026 | K2's Excel Tips, Tricks and Techniques for Accountants | Webinar

April 21, 2026 | K2's Excel Charting and Visualizations | Webinar


Related products

Advanced Excel for Staff: Build Reports and Analyze Data | Self-Study (On-Demand)

Complete Guide to Analyze Data With Excel PivotTables | Self-Study (On-Demand)

Finding Errors in Excel Spreadsheets | Self-Study (On-Demand)

Mastering the Excel Lookup Functions | Self-Study (On-Demand)

Shortcuts That Excel Users Love | Self-Study (On-Demand)


Search CPE catalog