Tips and Tricks

I love trying to create an Excel chart that was originally drawn with an Infographic software package.  Back in 2011 I saw a New York...

When is a picture worth a thousand words?  Definitely when you use custom markers in your Excel Charts. This will make your Excel Dashboard Charts...

As Excel users, we may create a spreadsheet with many many many worksheets (tabs at the bottom) within the workbook.  However, if you create...

Chart of Last 3 Months If you wanted to create a dynamic Excel chart of last 3 months of your data but didn't know how to...

In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data...

Here is a real quick tip that you may want to learn when using Excel.  This tutorial will help you apply this technique to...

Time for some beer and Excel.  Last month I saw that a User was wondering how to make Beer Mug Goal Chart for their...

We should have some fun as it is the start of a long weekend and the end of summer. So what better way to have...

Find And Replace from a List of Multiple Emails in Excel without VBA I had a recent request from a friend who needed to Find...

Create a Stacked Clustered Column Chart in Excel There is one type of chart that is always requested, however, Excel doesn’t offer this type of...