Excel Dashboard Templates

Here is how you can quickly solve the most recent Friday Challenge: Find Unique Values from CSV List Before we begin, I am going to show you how to do this with some standard Excel features...

Welcome back to another Friday Challenge at Excel Dashboard Templates! Today's challenge is pretty straight forward and can be done manually (although it will take a while).  Can you do it quickly and with little...

Many users in Excel spend time creating an awesome chart on a specific data set, then they want to use that chart on another data set.  Perhaps it was for the month of April...

I didn't receive any sample formulas from Friday's post that included a Friday Challenge, so maybe I stumped everyone when asking you to create an AverageIF Formula Excluding Zeros Across Worksheet Tabs. Here is the...

Sum Excel Worksheets Technique Why haven't I known about this simple Excel technique before now? Maybe you were aware how you can easily Sum Excel Worksheets but I never seen this in all my years of...

Learn a better charting format when your Excel Chart Secondary Axis Columns Overlap with 3 data series. The Problem I didn’t love the last chart we created that solved the problem that Whitney was having, however,...

We have learned how to Stop Excel Overlapping Columns in a few posts on the site.  A reader had a follow-up question that I thought I would answer here.  Here is the question: “This is...

Why is Excel Overlapping Columns in this chart? Why EXCEL, WHY are you doing this???  I don’t understand. Have you ever asked yourself this question when Excel overlaps the columns you just moved a...

When working with Time in Microsoft Excel you may have noticed that there is a problem when you subtract certain numbers.  Excel gives you an error, but it doesn't look like an error.  Excel...

In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages.  Well although I was able to compete the challenge, that wasn't good...