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