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 →


Group (Outline) Data in a Worksheet

  • By Doug H
  • 23 August, 2017
  • Comments Off on Group (Outline) Data in a Worksheet

When you have a table or record of transactions, some items just repeat don’t they? If they do, sometimes it’s easier to see them when there is some sort of categorization for “like” items. And if you are able to categorize them you may also be able to sum up … Continue Reading →


Use a Dropdown List to Switch between a Table or Chart

  • By Doug H
  • 9 August, 2017
  • Comments Off on Use a Dropdown List to Switch between a Table or Chart

Sometimes you want to see a Table and sometimes you’d want to see a Chart.  How about both?  And have the option to switch between both?  It like having a button to go between a table and chart.  This tip will step you through how to create not a button … Continue Reading →


Use a Dropdown List to Switch between a Table or Chart

  • By Doug H
  • 26 July, 2017
  • Comments Off on Use a Dropdown List to Switch between a Table or Chart

Sometimes you want to see a Table and sometimes you’d want to see a Chart.  How about both?  And have the option to switch between both?  It like having a button to go between a table and chart.  This tip will step you through how to create not a button … Continue Reading →