Home Tags Challenge

Tag: Challenge

Friday Challenge – My Answer – Chart This Data in Excel

Challenge – Chart This Data in Excel - My Answer A few Fridays ago, I posted this challenge: Link here: friday-challenge-chart-this-data-in-excel Where I asked you to send...
Excel Dashboard Friday Chart Challenge

Friday Challenge – Chart This Data in Excel

Chart This Data in Excel Today's challenge is a simple one but has many answers.  You will be presented with a small set of data and I...

Friday Challenge Answer – Find Unique Values from CSV List

Here is how you can quickly solve the most recent Friday Challenge: Find Unique Values from CSV List Before we begin, I am going to show...
Find Unique Countries Visited List

Friday Challenge – Find Unique Values from CSV List

Welcome back to another Friday Challenge at Excel Dashboard Templates! Today's challenge is pretty straight forward and can be done manually (although it will take...
AverageIF Across Excel Worksheet Tabs AverageIF Function Result

How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs

I didn't receive any sample formulas from Friday's post that included a Friday Challenge, so maybe I stumped everyone when asking you to create...
Sum Across Excel Worksheets Tabs

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

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...
Excel Array Solution

Data Transformation – Excel Array Solution

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

Friday Challenge – Data Transformation Solution

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

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...
Excel Array Formulas SumIF

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...
Want to Receive the Next Post?
Join My Newsletter
Give it a try, you can unsubscribe anytime.
Privacy Policy
Subscribe Now!   (Privacy Policy)

Stay Connected!

Get the latest post emailed straight to your inbox!