Friday Challenge Answers – The Boss Says…
I received some great responses from lots of fans. Thank you so much for all your great comments. I agree with most and my...
Advanced Excel Summation Skills – Using ARRAY Formulas to Check for Multiple Criteria
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...
Excel Super Bowl Statistics Dashboard
A great big shout out to Don who submitted the best Excel Dashboard of Super Bowl Statistics.
It has a neat design and uses picture...
How-to Make a Dynamic Hotel Ballroom Occupancy Chart
In a previous Friday’s challenge, I presented the following user request.
Here was the question again and what you would have seen in the download...
How-to Easily Add Task Information to Excel 2016 Gantt Charts
Easily Add Task Information to Excel 2016 Gantt Charts
Excel 2013 and Excel 2016 make this need so much easier. Thanks Excel! I recently posted...
How-to Make a College Basketball Tournament Bracket Chart in Excel
Well it is March and that means that it is Madness in college basketball. And with that madness comes the bracket challenges in every...
How-to Show Gaps in a Line Chart When Using the Excel NA() Function
In last Friday’s challenge, we had a Excel Analyst that needed to remove outliers from his Excel Line Chart. In essence, he wanted to...
Class Exam Grade Excel Chart Using Slicers and a Pivot Table
Here is Don’s amazing reply to the recent Friday challenge.In this example, Don has elevated his Excel Slicer Pivot Charting to a whole new...
New Take on the Excel Project Status Spectrum Chart
Leonid, a wonderful reader of our website, sent in a new take on my Excel Project Status Spectrum Chart. Here is what his looks...
Friday Challenge – Stumped on How to Display Data in an Excel Chart
I had some great responses to the last Friday Challenge, so I didn't want to stop the momentum with my answer to the last...
