Thanks for the Friday Chart Challenge Submissions – Vote in the Poll!

0
I had some AMAZING submissions for the last Friday Excel Chart Challenge. Check out the post and file downloads here: Friday-excel-challenge-submissionswhich-chart-solution-one-do-you-like-best/ And don’t forget to vote...
Data Transformation Formulas in Excel

Friday Challenge – Data Transformation

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

Friday Challenge – How Would You Chart It?

Today the ExcelDashboardTemplate.com Friday Challenge is up to you and your wildest imagination. An Excel chart newbie posted this data set and wasn’t sure the...

Friday Challenge – Eliminating outliers in and Excel Chart

4
Okay, apologies again .  I have been so swamped with my Go-Live project this week that I have been too tired to finish the...

How-to Make a Pass Fail Chart in Excel

Last week, I posed a Friday Challenge that was posted in a Q&A for Excel.  Here it is: ***************************************************************** Plotting a line graph to track build...

Friday Challenge Answer – Using Excel Slicers to Create Dynamic Charts

A big thanks to Don for submitting the first response to last week’s Friday Challenge.   You can check out the challenge here: Friday Challenge – Excel...

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

Petes Stumped Chart Challenge Answer – Pivot Chart with Slicers

In the last Friday Challenge, we were going to see if we could help a user create a chart from this data set.  They...

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

Friday Challenge – Allocation Formulas

  Today I have 2 formula challenges that you may find interesting.  They are both different types of allocation formulas.   Challenge 1: Problem: You have 9 tasks...