Friday Challenge – Data Transformation
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...
Advanced Excel Summation Skills – Using ARRAY Formulas to Check for Multiple Criteria
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...
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...
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 – 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...
Why Won’t My Excel SumIFs Formula Work?!
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...
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...
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...
How-to Make an Excel Single Image Goal Chart
Recently, a healthcare company employee contacted me about a chart he wanted to create. The company that he works for is trying to save...
3 Ways to Make Excel Chart Horizontal Categories Fit Better
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...
