Remove Duplicate Records in Excel

  • By Doug H
  • 29 April, 2017
  • Comments Off on Remove Duplicate Records in Excel

More is better…right?  Maybe not all the time. Especially if you have some records that show a cost.  If you have two records that are duplicates and it’s a dollar amount, you’ve just doubled your cost!  And if you have three records…that triple!  With four records….I think you get my … Continue Reading →


Use the Goal Seek Feature

  • By Doug H
  • 15 April, 2017
  • Comments Off on Use the Goal Seek Feature

Excel wants to know if you have goals. No, it’s not gong to be your new guidance counselor or your surrogate parent.  BUT it will be your new data analysis best friend!  Lets say you have some formulas put together on how much you can afford for a new car … Continue Reading →


Customize the Quick Access Toolbar

  • By Doug H
  • 1 April, 2017
  • Comments Off on Customize the Quick Access Toolbar

Do you know QAT? No, it’s not a duck call! It’s the Quick Access Toolbar! It’s the tiny sliver of real estate on the very top of Excel.  Usually it has small icons like a floppy drive or a folder.  If you are the type of person that likes to … Continue Reading →


Create a Linked Picture in Excel

  • By Doug H
  • 18 March, 2017
  • Comments Off on Create a Linked Picture in Excel

Did you know you could make your Excel charts into a picture? Wait…isn’t a chart sort of a picture?? Why would I want to make an chart a picture?  Lets say that you want to share your worksheet but didn’t want to easily give someone the ability to fiddle with the … Continue Reading →


Create a Dynamic Named Range

  • By Doug H
  • 4 March, 2017
  • Comments Off on Create a Dynamic Named Range

Do you have a table that has data added/removed on a recurring basis and it’s an input to other tables?  When you add or remove records, you may have needed to change the references from the other tables. You can offset these work by creating a dynamic named range or … Continue Reading →