Excel allows you to sort a PivotTable in alphabetical order or from largest to smallest values. They are similar to the standard Excel sorting options but worth looking at separately because there are automatic sorts, custom sortings and a manual sorting option. Quick PivotTable Sort Sort the PivotTable by right-click on any cell in a […]
Next Wednesday, Australia gets the results of their Same Sex Marriage survey with the details available to everyone with Excel. Here’s how to get the survey results, prepare for the announcement and when it’ll happen. We know most people won’t be interested in this singular Aussie exercise in democracy (don’t get us started …) It’s […]
There are interface changes coming to Outlook for Windows and Mac which Microsoft quietly previewed recently. As usual, interface changes are accompanied by the same vague promises and jargon. Long standing Office users will find a lot of what follows to be tiresomely familiar. We’re told this change will ‘increase new and existing user satisfaction’ […]
By default, PivotTable provides custom name such as “Sum of Amounts” or Count of Numbers” etc when you add a field to the table. You may not be always happy to use these default custom names for your PivotTable, so feel free to modify the headings to something you like. Click on the column heading […]
Moving or swapping fields around in a PivotTable is both amusing and addictive at the same time. You cannot stop yourself from rearranging your data in different ways. Each time you move a field, the Pivot Table will restructure to the new field configuration and you see the same data in a different alignment. May […]
