Quantcast

Friday Challenge – Splitting Up Email Address Text with Excel Formulas

0
Alright, this challenge was posted by a fan in on my Youtube Channel.  It was posted for this video: “Splitting Cell Text and Numbers...
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...

Friday Challenge – Analyzing Attendance Records with Six Sigma Charts

The following is a guest post from Pete on his answer to the most recent Friday Challenge. Pete applied his knowledge of Six Sigma to...

How-to Create a Time Data Series Step Chart in Excel

In our recent Friday challenge, we were asked by Anna how can we make our popular Excel Step Chart work for data that is...

How-to Make a Pass Fail Chart in Excel

Last week, I posed a Friday Challenge that was posted in a Q&A for Excel.  Here it is: ***************************************************************** Plotting a line graph to track build...
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...

Friday Challenge: Excel Step Chart Automation

Yesterday, I posted the a demonstration on how to make a Step Chart in Excel. You can check out that post here: How-to Easily Create a...

Friday Challenge: What is your answer vs. Excel?

There is a Facebook post going around and I thought it would be a fun Friday Challenge edition.   What is your answer to this this...

How-to Make a Dynamic Hotel Ballroom Occupancy Chart

In a previous Friday’s challenge, I presented the following user request. Here was the question again and what you would have seen in the download...
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...
Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy
Close
Subscribe Now!   (Privacy Policy)
SUBSCRIBE

Stay Connected!

Get the latest post emailed straight to your inbox!
SUBSCRIBE
close-link