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.

Recent Excel articles

Excel Conditional Formatting with the TODAY function | Duplicate Rule

Excel Conditional Formatting with the TODAY function | Duplicate Rule

Excel Accounts Payable / Accounts Receivable Exercise - Watch Chris Work

Excel Accounts Payable / Accounts Receivable Exercise - Watch Chris Work

Excel Recommend PivotTables - Improved Experience

Excel Recommend PivotTables - Improved Experience

Excel PivotTable - Calculate the number of days of each week for every month of the year

Excel PivotTable - Calculate the number of days of each week for every month of the year

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 other 750 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 10 million viewers have appreciated.

Categories