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 […]
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 […]
You will always find Excel either summarizing your data by adding the values together (SUM) or Counting the number of items. Nobody is stopping you from changing the type of calculation that your work demands to include averages, maximum, minimum, standard deviation and others. Change the calculation from the Value Field settings. Add a column […]
