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 →


Customize a Tab on the Ribbon

  • By Doug H
  • 12 July, 2017
  • Comments Off on Customize a Tab on the Ribbon

Are you the type that likes to be unique?  Do you like to customize your phone or desktop screen?  Are there some icons on the tab in the Excel Ribbon that you’d like to change or maybe you’d just like to add more command icons to certain tabs.  Well there … Continue Reading →