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 →


Sort Columns or Rows

  • By Doug H
  • 28 June, 2017
  • Comments Off on Sort Columns or Rows

Sorting things is just one of those basic tasks that you’ll find yourself doing quite often in Excel. And you’ll find Excel an excellent tool to sort by ascending or descending order in a column or by rows.  You can even do multiple sorting in a table like sorting by … Continue Reading →


Prevent a Chart from Changing Size

  • By Doug H
  • 14 June, 2017
  • Comments Off on Prevent a Chart from Changing Size

You’ve create a nice looking chart with the right size and shape of your columns, lines or pictures.  It’s a masterpiece, but a little too big so you’ve decided to resize some columns or rows to show more of the chart and when you do, it messes everything up.  Argggh!! … Continue Reading →


Create a Stock Chart

  • By Doug H
  • 31 May, 2017
  • Comments Off on Create a Stock Chart

Are you tracking a stock investment and wanted to see how it’s trending over a period of time?  But not just happy looking at numbers in a table?  Well create a chart….more specifically create a stock chart! This type of chart will let you look at the trend of high/low/open/close … Continue Reading →


Use the Find and Replace Feature

  • By Doug H
  • 17 May, 2017
  • Comments Off on Use the Find and Replace Feature

You’ve got a table with thousands of records for inventory and there are about fifty to a hundred different product SKUs or PID (Stock Keeping Units or Product IDentification).  One day someone decides to change the SKU or PID; not change the actual product, but just the name!  Now you … Continue Reading →