Create a Calculated Item in a PivotTable

Creating a Calculated Item in a PivotTable is one of those things you’d might not think of doing, but it has some uses.  For example, say you have some data with geographic categories like: Asia, Europe, North America and South America.  You create your PivotTable and it should summarized sales … Continue Reading →


Create a Calculated Field in a PivotTable

  • By Doug H
  • 1 November, 2017
  • Comments Off on Create a Calculated Field in a PivotTable

Calculated Fields in PivotTables are just an extra way to create different calculations for your data without messing with the source data. Say you had sales data and wanted to get the profit margin. Instead of adding an extra column in your source data for the PivotTable, you can can … Continue Reading →


Use Slicers to Filter PivotTables

  • By Doug H
  • 8 October, 2017
  • Comments Off on Use Slicers to Filter PivotTables

Have you given people you Excel file with the neat and dandy Pivot Table all ready for analysis and they still find it hard to navigate around? or do you find it hard to work with your own Pivots?  Why don’t you try slicer ? ( I think Microsoft wanted … Continue Reading →


Use Conditional Formatting

  • By Doug H
  • 4 October, 2017
  • Comments Off on Use Conditional Formatting

Conditional formatting is one of those wonderful features that let you call attention to data in your cells whether it is above or below a target, matches some text string or shows an errors. There are many different ways your cells can be highlighted from cell/font colors to using icons … Continue Reading →


Create a Two Variable Data Table

  • By Doug H
  • 20 September, 2017
  • Comments Off on Create a Two Variable Data Table

In a previous post I showed you how to create a one variable data table. You should know by now how Excel just wants you to be able to do more! So much more that there is a two variable data table feature. The use case for this is if … Continue Reading →