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...
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...
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...
How-to Create a Dynamic Excel Pivot Table Dashboard Chart
In my last 2 posts:
I showed you how to setup your data in preparation for creating a dynamic dashboard chart
Part 1: think-like-a-database-designer-before-creating-an-excel-dashboard-chart
And then I...
Stopping Excel Pivot Chart Columns from Overlapping When Moving Data Series to the Second...
A fan of the blog asked a question about this post:
Stop Excel From Overlapping the Columns When Moving a Data Series to the Second...
Friday Challenge – Find Unique Class List in Excel ANSWER
On Friday, I posted this challenge:
https://www.exceldashboardtemplates.com/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 yourself before you...
Friday Challenge – My Answer – Chart This Data in Excel
Challenge – Chart This Data in Excel - My Answer
A few Fridays ago, I posted this challenge:
Link here: friday-challenge-chart-this-data-in-excel
Where I asked you to send...
How-to Create Modify and Delete an Excel Pivot Table Calculated Field
I am sure you have created a Pivot Table in your Excel Workbook. However, have you wanted to easily learn how to add a...
Friday Challenge – Advanced Excel Summation Skills
This is a fun skills challenge to make sure you are well rounded. What is the SUM of your Excel Game? You will find...