by contextures.com
On Saturday, it’s the 38th anniversary of Microsoft Excel, which was released on September 30th, 1985. Eight years later, sometime in 1993, Pivot Tables were added, in Excel 5.0! Happy 30th Anniversary to Excel Pivot Tables.
Continue reading “30 Years of Excel Pivot Tables-Looking Back”
You probably use a few shortcuts when you work with Excel pivot tables. But do you use this pivot table double-click trick, to see the pivot field settings dialog box? Continue reading “Excel Pivot Table Shortcut for Field Settings”
This short video shows how to build an Excel pivot table that calculates a correct count, even if there are blank cells in the source data table.
There are sample Excel files on my Contextures site, with data you can use for testing, or demos. The original sample file has sales data for a fictional office supply company. I’ve added more files recently, so see if they’ll be helpful to you too.
Continue reading “Excel Sample Data for Pivot Table Testing”
Instead of manually updating all the pivot tables in your workbook, use a macro to do the job quickly. This macro tries to refresh all the pivot caches in the active workbook. If the macro can’t refresh a pivot cache, it will show you a message with the pivot cache index number, and the error description.
Continue reading “Refresh All Pivot Caches with Excel Macro”
Click a pivot table Slicer, to quickly show and hide groups of values. This value group slicer technique saves time and space, when there are lots of numeric fields in your source data table.
Usually, it’s best to set up your Excel file with one pivot table per sheet, so you don’t have to worry about them overlapping. However, if you need to see them side by side, here’s how you can create and filter two pivot tables on an Excel sheet, based on the same source data.
Continue reading “Create and Filter Two Pivot Tables on Excel Sheet”
How many times have you heard someone say, “Pivot makes me think of Ross from Friends”? If you make lots of pivot tables in Excel, you’re probably tired of hearing that from your co-workers, right? Well, this little Easter egg might brighten your day!
Continue reading “Pivot Makes Me Think of Ross From Friends”
A new version of my Excel Pivot Power Free add-in is available. There’s one new feature, a fix, and a couple of minor changes in the background.
Continue reading “Contextures Pivot Power Free Add-in Update”
If you have several pivot charts on an Excel dashboard, and space is limited, here’s a way to change all pivot charts with a single filter cell. When you select a different date from the drop down in that cell, all the pivot charts are automatically updated. There are NO macros for this technique, just Slicers, that are stored on a different sheet.
Continue reading “Change All Pivot Charts with Single Cell Filter”
