Quantcast

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. ...
Grouping Pivot Table Data in Excel

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...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link