As I mention in my post on creating pivot charts, you can't create pivot charts in Excel for the Mac. It's, hands down, my greatest aggravation with … [Read more...]
My Biggest Pivot Table Annoyance (And How To Fix It)
If you use pivot tables in Excel a lot like I do and you've ever had to pivot data with long entries, such as URLs (like from a Screaming … [Read more...]
How To Create Pivot Tables In Excel [VIDEO]
By popular demand, I've created a video walk through of how to create and customize pivot tables. If you haven't use pivot tables, they are especially … [Read more...]
Clean Up Data Labels From The GA API
One annoying idiosyncrasy of pivot tables is that all of the headings are prepended with a label indicating how the data is summarized. The most … [Read more...]