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

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 great Steve,...

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

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 months (out of 22) listed in my X Axis. I am working with a...

In the latest Friday Challenge, you were tasked with creating a Data Transformation Formula for the data listed on this page: Friday Challenge Data Transformation Now it is a tricky challenge because...

This weekend starts the ModelOff competition. “ModelOff is the world’s largest professional competition for Microsoft Excel, Financial Analysis, Investment Analysis and Financial...

In this post, I will show you another Excel summation technique that you can use to evaluate criteria and then sum the data based on that criteria.  Three posts ago, you received a challenge of...

In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data based on that criteria in Excel.  Two posts ago, we showed presented with a...

There are many ways to Sum data in Excel.  But when you have lots and lots of data, then you will want to learn a few different techniques.  In our last post, you were presented with a challenge of...

  This is a fun skills challenge to make sure you are well rounded.  What is the SUM of your Excel Game?  You will find out today.   The Data For today’s challenge, we will see if you...