WPCCA Excel PivotTables Course

Unlock the full potential of your data with this comprehensive course on PivotTables in Excel, led by Microsoft Certified Master Instructor, Rob Mendell. Designed for those who want to efficiently summarize, analyze, and visualize data, this course will guide you step-by-step through the fundamentals and features of PivotTables. This course teaches you how to create and customize PivotTables in Excel, manage data, apply filters and slicers, and perform advanced calculations. You’ll also explore building dashboards and combining data from multiple sources for enhanced analysis.

Date: Tuesday, May 13, 2025
Time: 11:00am – 12:30pm
Location: via Zoom

Program Outline:

  • What is a PivotTable (demo)
  • Is your Data Ready
  • Create a PivotTable from Data
    • Recommended PivotTables
    • Insert PivotTable
    • Move a PivotTable
  • Bring in New Data
    • Refresh
    • Change Data Source
  • Filter and Slice
    • Filter
    • Slicer
    • Timeline
    • Double-click a total to pull out its details
  • Options
    • Group / Ungroup
    • Display options
    • Total options
    • Formatting, etc.
      • Banded columns
      • Banded rows
  • In-Class Exercises
  • Calculations
    • Calculated Field
    • Calculated Item
  • PivotChart
    • If time allows and/or participants want to switch up the topics…
  • Intro to Dashboards
    • What is a Dashboard
    • How to put multiple PivotTable objects on one tab
      • Create
      • Move
    • How to put multiple PivotChart objects on one tab
  • Report Filter Pages
  • Using the Data Model to Combine Data Sources
    • Is your data ready
    • Define Relationships
    • Use the data in a PivotTable

About Rob Mendell:

Microsoft Office Trainer and Consultant Rob MendellRob Mendell is an Independent Contractor and a Microsoft Certified Master Instructor for Microsoft Office, providing training and support for end-users. Rob also designs and develops bespoke software solutions inside Microsoft Office by programming in VBA (Visual Basic for Applications): macros, automation templates, and fully customized dialog boxes. Since 1993, He has trained and supported individuals and groups of all sizes, and developed a myriad of robust solutions in the world’s most ubiquitous business software: Microsoft Office. Rob has worked with NECA (National Electrical Contractors Association) and WC&C (Association of Wall-Ceiling & Carpentry Industries), government agencies, healthcare facilities, over 100 law firms, companies in a wide variety of businesses, and individuals.

 

Click Here to Download the Event Flyer.

RSVP Required. To RSVP, please email Rowanne Khafagy at rkhafagy@thewpcca.com.

Free for WPCCA Members*
$35 for Non-Members*

Recent Posts

What Employers Need to Know About No Tax on Overtime

On July 3, 2025, the U.S. House of Representatives narrowly passed H.R.1, the so-called “One Big Beautiful Bill Act,” ending a dramatic journey through Congress that dominated headlines in recent weeks. The Act includes several provisions related to campaign promises…

July 23, 2025

WPCCA Lumber AI Live Demo

Discover how to streamline every aspect of your operations with AI and automation. Join us for a live demonstration of Lumber, the AI powered all-in-one construction workforce management platform built for modern contractors. From hiring and onboarding to payroll, time…

July 22, 2025

WPCCA Microsoft Word Course: Beyond the Basics

Take your Word skills to the next level in this hands-on training session, presented by Microsoft Master Instructor JoLynn Rihn. Designed for users with basic experience, this course covers advanced formatting and style management, multi-section page numbering, and tools like…

July 2, 2025

WPCCA Buzzbid Live Demo

Join us for a live demo of BuzzBID™, presented by CEO and electronic takeoff pioneer Leonard Buzz. Recently named Construction Tech Review’s Top Takeoff Tool of 2025, BuzzBID delivers takeoffs up to 500% faster using ClickONCE™ Computer Vision Technology. Discover…

June 11, 2025

WPCCA Workyard Field Scheduling Software Demo

Looking for a better way to schedule field crews and streamline operations? Join us for a live demo event featuring Workyard. Workyard provides workforce management software built for the field. Trusted by over 50,000 tradespeople, Workyard helps construction companies save…

May 15, 2025
MORE STORIES