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 →


Create a One Variable Data Table

  • By Doug H
  • 6 September, 2017
  • Comments Off on Create a One Variable Data Table

Ever heard of a variable table? What about a one variable table? Well if you haven’t you’ve step into the right place. A one variable table gives you the ability to put a variable input in and see how that input affects some outputs. For example let’s say you are … Continue Reading →