Menu

Streamlined Excel Reporting Series Session 2: Working with PivotTables

Overview

Unlock the full potential of your data with PivotTables

PivotTables are a versatile and transformative tool for organizing and analyzing data. Whether you're a beginner or an experienced user, this course will provide you with the knowledge and skills to make the most of PivotTables so that you can:

  • Customize PivotTable options
  • Execute advanced calculations
  • Create insightful reports

    Moving beyond formula-based reports

    By delving into more advanced techniques for using PivotTables, you'll learn how to replace formula-based reports by:
  • Incorporating multiple fields into the Values area
  • Performing custom calculations using calculated fields and items
  • Setting up PivotTable options to create sophisticated reports

    *Session 2 is one of four individual sessions. Each session builds on the previous one, so consider watching [Streamlined Excel Reporting Series Session 3: PivotTable Displays and Alternatives](Need new URL due to Title change) to tackle real-world issues and create powerful workbooks.*

    Prerequisites

    Familiarity with Excel tables and formula-based reporting concepts

    Objectives

    • Use PivotTable to organize reports with options, layout, and design formats.
    • Identify options of PivotTable multiple value fields.
    • Distinguish optimal use of calculated fields and calculated items.

    Highlights

  • Report type comparison
  • Customizing PivotTable options
  • Format and design options
  • Calculated fields and items
  • Multiple value fields

    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:

    4902839

    2 CPE Credits
    Computer Software & Applications: 2 Credits

    Registration

    Member Price:
    $125
    Non-member Price:
    $149

    Registration is open through 02/20.

    Friday, February 20th

    11:00am to 1:00pm

    Add to Calendar

    Instructor

    Liam Bastick

    Related Courses

    Advanced Excel: Hidden Secrets and Gems

    February 17, 2026

    2 Credits
    Details
    Data & Predictive Analytics & Business Intelligence for Controllers/CFOs

    February 17, 2026

    4 Credits
    Details
    K2'S Artificial Intelligence For Accounting And Financial Professionals

    February 17, 2026

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