'Pivot table' category
A pivot table allows you to examine data more efficiently, it can summarize large amounts of data very quickly and is very easy to use.
This article demonstrates how to build a calendar in Excel. The calendar is created as a Pivot Table which makes […]
Did you know that you can use a pivot table to summarize portfolio holdings at any point in time? If you trade […]
Today I am going to demonstrate how amazing pivot tables are! Take a look at this time sheet. You can […]
Table of Contents Introduction to pivot tables Create pivot table Group data Analyze data (pivot table) Compare performance, year to […]
This article demonstrates a macro that allows you to rearrange and distribute concatenated values across multiple rows in order to […]
I read this interesting article Quick Trick: Resizing column widths in pivot tables on the Microsoft Excel blog. It is […]
To be able to use a Pivot Table the source data you have must be arranged in way that a […]
Rodney Schmidt asks: I am a convenience store owner that is looking to make a spreadsheet formula. I want this […]
In this article, I am going to show you how to quickly change Pivot Table data source using a drop-down […]
Sean asks: Basically, when I do a refresh of the data in the "pivotdata" worksheet, I need it to recognise […]
ExcelBeginner asks: I have a small problem that I am not sure on how to solve. I now have a […]
In a previous post:Â How to create a dynamic pivot table and refresh automatically I demonstrated how to refresh a pivot […]
Excel 2013 allows you to count unique distinct values in a pivot table, this article explains how to count unique […]
This article shows you how to refresh a pivot table automatically using a small VBA macro. If you add or delete […]
Anura asks: I have a list of credit card transactions showing the name of the cardholder, their Branch and the […]