In the 54th session of Chandoo.org podcast, let’s make you awesome in Pivot Tables.
What is in this session?
In this podcast,
- Quick updates
- Top 10 pivot table tricks
- Adding same value field twice
- Tabular layouts
- GETPIVOTDATA & 2 bonus tricks
- Relationships & data model
- One slicer to rule them all
- Show only top x values
- Relative performance
- Show unique count
- Spruce up with conditional formats
- Not so ugly pivot charts
- Resources & Show notes for you
Listen to this session
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Click here to download the MP3 file.
Resources for this podcast
Comprehensive guides on,
- Excel Pivot Tables intro – Podcast
- Excel Pivot Tables an introduction
- Excel Slicers what are they, how to use and advanced tips
- GETPIVOTDATA examples & usage
- Relationships & Data model example & downloadable workbook
- Power Pivot introduction and overview
Pivot Table Tips & Tricks
- Use report filters with VBA
- Structured references for Pivot Tables
- Group data in Pivot Tables
- Matching transactions using Pivot Tables
- Highlight quarters / weekends using styles in Pivot Reports
What are your favorite Pivot Table tricks?
Now its your turn. Go ahead and share your favorite pivot table tricks in the comments box.
3 Responses to “How-to create an elegant, fun & useful Excel Tracker – Step by Step Tutorial”
Hi Chandoo,
I am responsible for tracking when church reports are submitted on time or not and the variations from the due date for submission.
Here is the Scenario;
The due date for the submission of monthly reports is on the 5th of each month. and I would like to know how many reports have been submitted on time (i.e, those that have been submitted on or before the due date) I would also want to track those reports that have been submitted after the due date has passed.
How can I create such a tracker?
Hi Chandoo,
I am a member of your excel school.
I was trying to create SOP Tracker I follow all your steps but I keep this error below.
The list source must be a delimited list, or a reference to a single row or cell.
I try looking on YouTube for answer but no luck.
can you help on this?
thanks
Carl.
Dear Mr. Chando,
Rakesh, I'm working in a private company in the UAE. Recently, I'm struggling to get more details about the staff sick, annual, unpaid, and leaves. I would like to get a tracker in excel. Could you please help me in this situation?
I also watching your videos in YouTube. i hope you can help me on this situation.