Tips and Tricks

In this recent post: Friday Challenge Answers – Cumulative Events Over Time I created a formula that referenced a table.  As I created my video I...

In a recent post, I was exploring Excel AverageIF and other Average functions and I realized that I don’t know that much about the...

Have you ever created a lot of charts in an Excel Worksheet and drove yourself crazy trying to line the charts up? Notice how the...

In are recent post, I showed you how to create a Bullet Chart in Excel.  Pete, then sent me another way to create a...

I am so happy to help my fans, and I saw a recent comment on an older posting of mine and I thought I...

Here is the first and easiest answer to the challenge on posted on Friday. In case you missed it, you can check it out and...

So that everyone can use my Excel Charts and Dashboard Templates, I typically save my files in an Excel 97-2003 format.  There are other...

Fake an Excel Chart Data Table Yesterday, I showed you how you can use the Horizontal Axis option of “Multi-level Category Labels” to create a...

Yesterday, I showed you how you can use the new label options in Excel 2013 to help Kevin with his engineering chart.  But we...

Many users like to create a chart that Excel doesn’t have as a chart type.  It is a combination of a clustered column and...