Quantcast
Home Tags Challenge

Tag: Challenge

Learn SumProduct and SumIF Excel Functions

Advanced Excel Summation Skills Using SUMIFS and SUMPRODUCT

In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data...
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...
Excel greek summation symbol

Friday Challenge – Advanced Excel Summation Skills

  This is a fun skills challenge to make sure you are well rounded.  What is the SUM of your Excel Game?  You will find...
Friday Challenge - Find Unique Class List in Excel ANSWER

Friday Challenge – Find Unique Class List in Excel ANSWER

On Friday, I posted this challenge: https://www.exceldashboardtemplates.com/friday-challenge-find-unique-list-in-excel/ You can download the sample data set here:  Challenge Sample Data Check out the post and download / try it yourself before you...
Find a Unique Class List-in Excel

Friday Challenge – Find Unique List in Excel

It is time for another Friday Challenge.  This is based on actual scenario from a recent project. A user had a large list of values in...
Clustered Stacked Column Chart by Month Year

Friday Challenge Answers: Year over Year Chart Comparisons

Thanks for the submissions for the Friday Challenge. You can get the sample data and chart request here:  friday-challenge-help-new-to-excel-yoy-comparisons   Here are some other submissions: A) In the...
Excel Chart Challenge

Friday Challenge: Help! New to Excel! YOY Comparisons

Luckily I was able to help this user, but I think that we can even do more.  Here was the original request: "Help Please! I’m...
Network Data Usage Excel Chart

How-to Visualize 17000 Data Points of Upload and Download Times

In the last Friday Challenge, I presented you with 17,000+ data points representing 2 days of network data usage. With so many data points, it...
Excel Dashboard Friday Chart Challenge

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

Excel Stacked Area Time Chart – Friday Challenge Answer

In our recent Friday Challenge, a user asked this: "This is a scatter with smooth line and markers graph. What I would like to have...
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