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 Insert Slicers into an Excel Pivot Table

In my last post, Think-like-a-database-designer-before-creating-an-excel-dashboard-chart we described the best way to configure your data to easily create your next dashboard. In this post, we explore the...

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 - Find Unique Class List in Excel ANSWER

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...
Final Pivot Table Data Format

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...

Class Exam Grade Excel Chart Using Slicers and a Pivot Table

Here is Don’s amazing reply to the recent Friday challenge.In this example, Don has elevated his Excel Slicer Pivot Charting to a whole new...
Grouping Pivot Table Data in Excel

Advanced Excel Summation Techniques Using Pivot Table

There are many ways to Sum data in Excel.  But when you have lots and lots of data, then you will want to learn...

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...

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...