Excel Dashboard Templates

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 you haven't been to the site, you should check it...

In this post, I will show you another Excel summation technique that you can use to evaluate criteria and then sum the data based on that criteria.  Three posts ago, you received a challenge of summing 150,000...

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

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 our last post, you were...

  This is a fun skills challenge to make sure you are well rounded.  What is the SUM of your Excel Game?  You will find out today.   The Data For today's challenge, we will see if you...

Part of my time this week was spent working on a project for a client and I was sooo frustrated.  I just couldn't get my SUMIFS formula to work. Have you ever had that issue with...

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 read this post.   Challenge Data Creation Well, good news is that I...

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

Recently, a healthcare company employee contacted me about a chart he wanted to create.  The company that he works for is trying to save trees by reducing their usage of paper in copiers and...

Have you ever had a chart where your Horizontal Category Labels overlap each other and they are unreadable? Check out this chart to see what I mean:   If you run into this problem, there are a...