Challenge
Friday Challenge – My Answer – Chart This Data in Excel
Check out How I Used Different Graphing Techniquest to Chart This Data in Excel, including Pivot Tables, Slicers and Multi-Level Labels.
EXPLORE THE LIBRARY
Tag: Challenge
Challenge
Friday Challenge – Chart This Data in Excel
Try your hand at this Friday Challenge to see how you would chart this data in Excel. What is the best ways to set up your chart data and format.
Challenge
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 you how to do this with some standard Excel features
Challenge
Friday Challenge – Find Unique Values from CSV List
See if you can Find Unique Values from CSV List in Excel. This is a tough challenge, but will show you how you to work with CSV files and Pivot Tables.
Averageif
How-to AverageIF Excluding Zeros Across Excel Worksheet Tabs
A quick tutorial that teaches how to create an AverageIF Formula that will exclude Zero (0) and blank values when averaging across many Excel Worksheet Tabs
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
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