Getting Started With PivotTables - Live on 2-22-2023

Posted on:  01/11/2023
Getting Started With PivotTables - Live on 2-22-2023

PivotTables are one of Excel's most powerful features. PivotTables quickly analyze and summarize complex data. In this LIVE session with Chris Menard, you will learn how to create a PivotTable, use PivotTable fields, work with subtotals and grand totals, and create PivotCharts.
We will create over 6 PivotTables in this Getting Started with PivotTables session.

We will work with text, numbers, and date data types in our PivotTables.

Popular PivotTable videos

Excel has a great feature that allows you to create multiple PivotTables from one PivotTable. It is called "Show Report Filter Pages."
To use this feature, you must use the Filter area in a PivotTable. The field you want to drag to the Filter area of the PivotTable is the field you wish to create many PivotTables.

As an example, if you want each Sales Rep to have their own PivotTable report, and you have a field called Sales Rep, you would drag the Sales Rep to the filter area. You need two other fields. Most likely, one is in the row area, and the other field, usually numeric, is in the values areas. Here is a screenshot of how it would look. 

Show Report Filter Pages Video

In Excel, you can do Period-over-Period (POP) analysis and Year-over-Year (YOY) analysis. Year-over-Year analysis will compare the selected period to the same period last year. For example, comparing August of the current year to August of the previous year. YOY can be weeks, months, quarters, or years. Period-over-Period will compare the selected period to the preceding period. For example, August of the current year to July of the current year. 

Excel Year-Over-Year and Period-Over-Period Analysis with PivotTables

We frequently group by dates: Invoice date, purchase order date, hire date, and many other date fields. Excel does a great job of grouping by dates in a PivotTable. You can group by year, quarter, month, and day. Excel has a group called "Group." To activate the group, click on a date, and select either group or ungroup.

PivotTables - group dates and create a Running Total

Chris Menard's Microsoft Teams Online Training Course

Online Microsoft Teams Training with Chris Menard

50% off coupon

Just some of the topics covered

  1. Navigation Teams
  2. Using private Chat
  3. Using group Chat
  4. Teams Meetings
    1. Scheduling Meetings
    2. Meeting controls
    3. Roles in a meeting
    4. Sharing resources
    5. PowerPoint in a meeting
    6. Scheduling Team meetings from Outlook
  5. Working with Teams and Channels
    1. Conversations
    2. Files
    3. Wiki and OneNote
  6. Using Outlook and Teams
  7. Using apps in Teams
Lifetime access to Teams Course Beginner to Pro with coupon
Chris Menard

Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories