Home Challenge

# Challenge

### How-to Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)

1
Sum Excel Worksheets Technique Why haven't I known about this simple Excel technique before now? Maybe you were aware how you can easily Sum Excel Worksheets...

### Data Transformation – Excel Array Solution

0
In a recent Friday Challenge, I asked our readers to transform an varying text string into dates and values to determine averages.  Well although...

### Friday Challenge – Data Transformation Solution

0
In the latest Friday Challenge, you were tasked with creating a Data Transformation Formula for the data listed on this page: Friday Challenge Data...

### Friday Challenge – Data Transformation

9
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

0
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

0
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

0
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

6
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

0
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

6
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...
Want to Receive the Next Post?