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.
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(…)
Dalia tried to use the Excel Interactive View to show data on the web, but she needs to Back
Dates in Text Format in my Pivot Table! We can fix that!
Bill’s Old Pivot Table Record: 6 Clicks.