Category Archives: Excel Pivot Table

Create Pivot Table from Existing Cache

When you create a pivot table in Excel, a pivot cache is automatically created. The pivot cache is a special memory area where the pivot table records are saved. If there are multiple pivot tables in a workbook, they might … Continue reading

Posted in Excel Pivot Table | 2 Comments

Pivot Table Compares Weekdays in Fiscal Year

If you’re tracking retail sales year over year, it’s not too helpful to compare sales by calendar date. The dates will fall on different weekdays each year, so slow weekdays will be compared to busy days. To get a better … Continue reading

Posted in Excel Pivot Table | Leave a comment

Quickly Change Pivot Table Layout

Pivot tables are a quick way to summarize your data, and they have another advantage too. After you build the pivot table, it’s easy to change pivot table layout, to get a different type of summary. Watch the video below, … Continue reading

Posted in Excel Pivot Table | Leave a comment

Unpivot Excel Data With a Macro

If you plan to build a pivot table, check the source data first, to make sure you have it set up correctly. If there is a heading for each month’s sales, instead of just one column where all the amounts … Continue reading

Posted in Excel Pivot Table | Leave a comment

Pivot Table From Data on Multiple Sheets

A frequent question about pivot tables is how to create one from data on different worksheets, or even in different file. Last week, I updated my page on this topic, which shows several ways you can accomplish this goal. Multiple … Continue reading

Posted in Excel Pivot Table | 1 Comment

Pivot Table Training Giveaway Winners

Thanks to everyone who entered the Pivot Table Training giveaway, for a chance to win an amazing online course from John Michaloudis, at My Excel Online Training. You shared your biggest pivot table fears, and you can see the voting … Continue reading

Posted in Excel Pivot Table | 14 Comments

Scary Pivot Table Giveaway Week 2

We’re having a pivot table training giveaway, and there are only a few days left to enter – the deadline is Sunday, November 9th, 2014, at 11:59 PM (Eastern Time) If you enter, you could win one of the 3 … Continue reading

Posted in Excel Pivot Table | Leave a comment

Scary Pivot Table Training Giveaway

Halloween is a couple of days away, and you’ll see many frightening things that night. Keep an eye out for vampires, witches, ghosts and monsters! Something else that scares some people is a pivot table. Even though it’s a beautiful … Continue reading

Posted in Excel Pivot Table | 5 Comments

Pivot Table Intro and Resources

Many years, and thousands of pivot tables ago, I wrote a couple of articles for Jon Peltier’s Excel charting website. Jon has been updating his website, and asked me to write new versions of those articles. He has just published … Continue reading

Posted in Excel Pivot Table | 1 Comment

5 Annoying Pivot Table Problems

As much as I love Excel pivot tables, there are a few annoying problems that you’ll run into, while working with them. I made a list of my top 5 annoyances, and you might have other problems to add to … Continue reading

Posted in Excel Pivot Table | 13 Comments