Video Tutorial

Last week we learned how to copy a chart in Excel quickly and have it reference a new chart data range on the same...

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

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

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

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

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

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

When working with Time in Microsoft Excel you may have noticed that there is a problem when you subtract certain numbers.  Excel gives you...

In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages.  Well although...

The Problem Recently a fan contacted me and asked how she change the horizontal axis could do the as follows: "I am trying to bold 5...