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...
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...
Excel greek summation symbol

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