Tips and Tricks

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

Lots of users use Excel for lists or you may receive reports from other people or systems and sometimes those files contain Wild Cards...

In a past article, I posted 2 different ways to make a chart that appeared in the New York Times.  Here is the chart...

Several years ago, I created an Excel workbook and I "Protected" a worksheet, but, I forgot the passcode the next day.  Try and try,...

Stacked and Unstacked Column Chart in Excel Excel is awesome because, even when a certain chart type is not a standard option, there may be...

In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a...

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...

So all the US news agencies keep talking about the Fiscal Cliff.  This reminded me of a problem that many people have when making...

Many users in Excel spend time creating an awesome chart on a specific data set, then they want to use that chart on another...

In my last 2 posts: I showed you how to setup your data in preparation for creating a dynamic dashboard chart Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart And then I...