Challenge
How-to Easily Sum Across Excel Worksheet Tabs (Plus Friday Challenge)
Learn How you can Quickly and Easily Sum Across Excel Worksheets for the same Cells for every Excel Worksheets or Spreadsheet Tab
EXPLORE THE LIBRARY
Challenge
Array
Data Transformation – Excel Array Solution
Learn how to combine the most recent Friday Challenge solutions into an Excel Array formula to solve the Data Transformation needs.
Challenge
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 Transformation Data Transformation Now it
Challenge
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.”
Array
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 criteria. Three posts ago, you received a challenge
Challenge
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 based on that criteria in Excel. Two posts ago, we showed presented with
Challenge
Advanced Excel Summation Techniques Using Pivot Table
Facebook Twitter Pinterest WhatsApp Linkedin 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 o
Challenge
Friday Challenge – Advanced Excel Summation Skills
Facebook Twitter Pinterest WhatsApp Linkedin Excel greek summation symbol This is a fun skills challenge to make sure you are well rounded. What is the SUM of your Excel Game? You will fin
Challenge
Friday Challenge – Find Unique Class List in Excel ANSWER
On Friday, I posted this challenge: 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 you
Challenge
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 over 220 columns and over 5800 rows. All in all, there