Excel Recommend PivotTables - Improved Experience

Posted on:  05/11/2022
Excel Recommend PivotTables - Improved Experience

Recommended PivotTables in Excel is getting a great update. To use Recommended PivotTables, click the Insert Tab, and click Recommended PivotTables. The new update includes an easy method to change the data range. You also get a task pane on the right side of the screen and can add the PivotTable to the current worksheet or a new worksheet. 

YouTube Video - Recommended PivotTables

Chapters

  • 0:00 Intro
  • 0:25 Insert Recommended PivotTable
  • 1:45 PivotTable 1
  • 2:28 PivotTable 2
Recent Teams articles

Create a PivotTable using a Recommended PivotTable

Below are the steps to create a Recommended PivotTable. 

  1. Click inside your data
  2. Click the Insert Tab.
  3. Click Recommended PivotTables.
Disney Event with Chris Menard in September 2022

Recent Excel articles

Excel Status Bar - Tips Every User Should Know

Excel Status Bar - Tips Every User Should Know

How to SORT Data in Excel | 7 Tips

How to SORT Data in Excel | 7 Tips

Excel - Data from Picture - Microsoft 365 New Feature

Excel - Data from Picture - Microsoft 365 New Feature

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

Excel - using the Scenario Manager to track house payments with skyrocketing mortgage rates

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 800 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 12 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories