Pivot Tables

UserVoice – What is your Idea to Improve Excel?


I just returned from the Microsoft MVP Summit where I spent a few days with the Excel team. Would you like a way to communicate your Excel improvement ideas to the people who build Excel? There is a new way.

Easy Territories in Excel Pivot Tables


You pivot table has a list of cities, but no Territory field: There is an easy way to create a virtual Territory field: 1) Select the cities in the first territory (Click on first city, Ctrl+Click on others) 2) In the Pivot Table Tools ribbon, click Group Selection. 3) By default, they call the territory(…)

Learn Excel – “Hide Excel Columns with Slicer”: Podcast #1796


Dalia tried to use the Excel Interactive View to show data on the web, but she needs to Back

Learn Excel 2013 – “Sort Pivot Table Text Dates”: Podcast #1679


Dates in Text Format in my Pivot Table! We can fix that!

A New Record – Pivot Table in 4 Clicks


Bill’s Old Pivot Table Record: 6 Clicks.

Learn Excel from MrExcel