In a recent Friday Challenge, you were tasked with creating a formula that would work out for a non-contiguous (not connected) range that ignored Zero and Ignored Blanks. But, what we didn
Have you had a chance to use Excel Online Yet? Well I have had a little time recently when I was working away from my office with a client. Here is the scenario: A) A User asked me how to do
In our recent Friday Challenge, Friday Challenge – Creating an Excel Graph of Cumulative Events Over Time where a user wanted the following: Creating a graph of cumulative events over time I
Here is a Friday Challenge that a lot of Excel users may run into. Essentially, you are given a date and incident type that occurred on that date. However, the user wants to take those colu
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 AverageA Excel function. So I thought I would share how I q
Welcome to another edition to Terrible Chart Tuesday. Here we see an example of what I think is a Terrible Chart that was create in Excel. What do you think? Let me know in the comments be
A reader, Matt, after reading this post: How-to Format Chart Axis for Thousands or Millions And had the following question: “How do you use this formula without the dollar sign? I am using d
With all the new affordable touch screen computers out there, you may have purchased one. However, if you are like me, you may have large fingers and trouble using your laptop’s touch capab
In our last Friday Challenge, I asked you figure out a way to calculate an average for a non-contiguous (non-adjacent) range that will exclude blanks and zeros. This came from a user questio
As an Excel dashboard engineer you will often need to create complex calculations for your charts, tables and displays. So today’s challenge is one that was sent in by a reader from another