Category Archives: Excel Pivot Table

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

Pivot Table Tips on Contextures

Thank you for following my pivot table tips, here on the Excel Pivot Tables Blog. I appreciate it! There are many more tips and tutorials on my Contextures website, and I’ve just finished setting up a Pivot Table index, so … Continue reading

Posted in Excel Pivot Table | 1 Comment

PivotPower Premium Update 201407

If you’ve bought a copy of my PivotPower Premium add-in, I sent out an update email last week, so you can download the latest version. There are a few new features, that I hope you will find useful. A big … Continue reading

Posted in Excel Pivot Table | 1 Comment