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.
EXPLORE THE LIBRARY
File Download category
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
Chart
A Better Format For Excel Chart Secondary Axis Columns Overlap with 3 Series
Facebook Twitter Pinterest WhatsApp Linkedin Learn a better charting format when your Excel Chart Secondary Axis Columns Overlap with 3 data series. The Problem I didn’t love the last chart
Chart
Stop Excel Overlapping Columns on Second Axis for 3 Series
If you have 3 series in an Excel Column Chart and move one to the Secondary Axis, learn the trick on how to Stop Excel Overlapping Columns on Secondary Axis
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
Chart
How-to Make an Excel Single Image Goal Chart
Recently, a healthcare company employee contacted me about a chart he wanted to create. The company that he works for is trying to save trees by reducing their usage of paper in copiers and
Calculated Item
How-to Make an Excel Stacked Column Pivot Chart with a Secondary Axis
In this previous post: Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second Axis I had a fan question – How can you do this same type of Pivot Chart but