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...
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...
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 – Creating an Excel Graph of Cumulative Events Over Time
Here is a Friday Challenge that a lot of Excel users may run into.
Essentially, you are given a date and incident type that occurred...
Friday Challenge – The Right Graph Style For What I Want to do
A newer Excel Chart creator had this question:
"This is a scatter with smooth line and markers graph. What I would like to have displayed,...
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...
Friday Challenge – Step Chart for an Excel Time Series
I was recently asked for assistance with this request:
Hi Steve,
I am trying to make a hypnogram with data that we collected over the course...
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...
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: What Charts Would You Make?
This Friday Challenge involves Network Data Usage. You will find over 17,000 data points representing 2 days of network data usage in the linked file.
With...
