Friday Challenge – Find Unique Values from CSV List
Welcome back to another Friday Challenge at Excel Dashboard Templates!
Today's challenge is pretty straight forward and can be done manually (although it will take...
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...
Excel Geek Out with MrExcel
How fun a night I had! Did you ever think that you would meet a couple of Excel gurus and other Excel fans and...
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...
What to Do When Formulas Don’t Work from an Exported Salesforce.com Report or CSV...
Recently during a Project that was using Salesforce.com,
I created a custom report and then exported the results to Excel. This report looked and...
Friday Challenge – AverageIf NOT Blank or NOT Zero with Negative Values for Non-Contiguous...
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...
Top Movies – Excel Dashboard – Brian’s Friday Challenge Entry
This was our final entry in the most recent Friday Challenge for the Internet Movie Database Top 250.
Below you can download an awesome Excel...
Friday Challenge – Close the Distance Between a Clustered Stacked column Chart
For this week’s challenge, we are going to modify a previous post for a user request.
If you are not familiar with it, you should...
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...
Fastest Way to Open a New Workbook in Excel
I saw in a recent post on Contextures.com, that Excel 2013 has added new option that you can choose to not display the start...
