In this post, I will show you 2 other techniques that you can use to evaluate criteria and then create a sum of data based on that criteria in Excel. Two posts ago, we showed presented with
Facebook Twitter Pinterest WhatsApp Linkedin There are many ways to Sum data in Excel. But when you have lots and lots of data, then you will want to learn a few different techniques. In o
Facebook Twitter Pinterest WhatsApp Linkedin Excel greek summation symbol This is a fun skills challenge to make sure you are well rounded. What is the SUM of your Excel Game? You will fin
On Friday, I posted this challenge: 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 you
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 over 220 columns and over 5800 rows. All in all, there
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
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 new to Excel charts and I need to chart these two tables in a ba
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 may be best to visualize the data to see what i
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 so many data points, it may be be
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 displayed, is everything above the blue line one colour, b