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 – Hotel Ballroom Occupancy Chart
Hi All,
Here is today’s challenge. There is a spreadsheet attached. Give it your best shot and I will post my solution and spreadsheet on...
Create a Excel Gantt Chart to Display a Music Festival Band Schedule
Here is Pete's answer to the recent Music Festival Schedule Challenge.
In this video, see how he used Index/Match functions as well as a helper...
Analyzing Attendance Records with Charts and Trend Line with Sparklines
A big shout out to Don who sent in this solution to last week’s Friday Challenge: Analyzing Attendance Records with Charts and Trend Line. ...
Advanced Excel Summation Techniques Using Pivot Table
There are many ways to Sum data in Excel. But when you have lots and lots of data, then you will want to learn...
Friday Challenge – Create a Chart to Display a Music Festival Schedule
Here is an interesting question that I saw and I thought I would present it as the next in the series of Friday Challenges.
This...
Friday Challenge: Excel Step Chart Automation
Yesterday, I posted the a demonstration on how to make a Step Chart in Excel.
You can check out that post here:
How-to Easily Create a...
Show Only Selected Data Points in an Excel Chart
So last week I posted this question in the challenge:
Here the user story on what we are trying to do:
‘As an Excel user I...
Friday Challenge – Which Chart is suitable?
I am so glad it is Friday, aren’t you? There is no right answer to today’s challenge. So make sure you leave me a...
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...