Monthly Archives: May 2020

Microsoft Excel – showing field names as headings rather than “Row labels” in Pivot tables by default

For many versions of Microsoft Excel I found it annoying that it said Row labels and Column labels in a Pivot Table instead of the actual field headings. In Excel 365 this can now eventually be changed to show field … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , | Leave a comment

Microsoft Excel – Using Quick Analysis for % of Totals and Cumulative Totals

To calculate % of Totals in Excel, you would normally have to use absolute cell references or name the Total cell. Similarly for cumulative totals, you would have to create the relevant formula. Provided you have Excel 2013 or a … Continue reading

Posted in Excel 365, Microsoft Excel, Microsoft Excel 2013, Microsoft Excel 2016 | Tagged , , , , | Leave a comment