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...
Friday Challenge – Pipeline Usage Chart
I recently got a request from a subscriber that asked if I could help them create a cylinder chart. However the sample that was...
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...
How-To Create an Excel Step Chart Formula Using the Small Function
In our last Friday Challenge, we were investigating Step Charts. In case you missed it, you can check it out and download the sample...
Leonid’s Friday Challenge Answer – Pipeline Usage Stacked Bar Chart
Here is a late entry :) Thanks Leonid. This is an Awesome response!
Leonid was responding to this recent challenge: Friday Challenge – Pipeline Usage...
How-to Unprotect an Excel Worksheet If You Forgot the Passcode
Several years ago, I created an Excel workbook and I "Protected" a worksheet, but, I forgot the passcode the next day. Try and try,...
IMDB Top 250 Movies of All Time – Excel Dashboard Tutorial
In our last Friday Challenge, we presented a data set of the Top 250 Movies from IMDB and asked you to create a dashboard...
Friday Challenge – Data Transformation Solution
In the latest Friday Challenge, you were tasked with creating a Data Transformation Formula for the data listed on this page: Friday Challenge Data...
Excel Dashboard of the Top 250 Movies – Don’s Friday Challenge Entry
Here is our next submission from the last Friday Challenge for the Internet Movie Database Top 250.
Below you can download an awesome Excel Dashboard...
How-to Make a Thermometer Goal Chart in Excel
How-to Make a Thermometer Goal Chart in Excel
A friend and co-worker asked me if I had a tutorial on a building a Thermometer Goal...