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: Pivot Table
Chart
How-to Create a Dynamic Excel Chart of Last 3 Months Data Without Offset
Chart of Last 3 Months If you wanted to create a dynamic Excel chart of last 3 months of your data but didn’t know how to use or didn’t want to use the Excel Offset Function, then check out
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
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
Pivot Table
How-to Convert an Existing Excel Data Set to a Pivot Table Format
In previous posts, I have espoused the virtues of the Pivot Tables in Excel and that you should always think in terms of a database programmer when you create your data layouts. If you miss
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
Chart
How-to Add a Grand Total Line on an Excel Stacked Column Pivot Chart
Today I answer a viewer question. “How do I add a cumulative grand total amount as a line above a stacked column pivot chart in Excel?” Well there are a few tips and tricks to create this t
Chart
3 Ways to Add a Target Line to an Excel Pivot Chart
Check out this post to LEARN 3 Different Ways That you Can Add a Target Line / Goal Line to Microsoft Excel Pivot Chart for you Executive Dashboard.