AverageIF Across Excel Worksheet Tabs AverageIF Function Result

How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs

2
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 Across Excel Worksheets Tabs

How-to Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)

1
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...
Better Format for Excel Chart Secondary Axis Columns Overlap with 3 Series

A Better Format For Excel Chart Secondary Axis Columns Overlap with 3 Series

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

Excel Overlapping Columns on Second Axis for 3 Series

Stop Excel Overlapping Columns on Second Axis for 3 Series

8
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...
Excel Overlapping Columns Chart Secondary Axis

Why is Excel Overlapping Columns When I Move them to the Secondary Axis?

2
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...
Calculating Hours Difference of Time in Excel Spreadsheets

Calculating Hours Difference of Time in Excel Spreadsheets

6
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...
Excel Array Solution

Data Transformation – Excel Array Solution

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

How-to Highlight Specific Horizontal Axis Labels in Excel Line Charts

How-to Highlight Specific Horizontal Axis Labels in Excel Line Charts

7
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...
Data Transformation Butterfly Image

Friday Challenge – Data Transformation Solution

0
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 the data is...
Data Transformation Formulas in Excel

Friday Challenge – Data Transformation

9
This weekend starts the ModelOff competition. "ModelOff is the world’s largest professional competition for Microsoft Excel, Financial Analysis, Investment Analysis and Financial Modelling." -Modeloff Site If you haven't been to the site, you should check it...