Pivot Table
A pivot table is an incredibly powerful tool in Excel that can be used to analyze, explore and summarize your data.
Pivot Tables are in their element with huge amounts of data and allow you to create reports from this data in seconds.
Below is a list of our best tutorials on Pivot Tables.
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
{ 11 comments… read them below or add one }
Please provide me pivot table how to edit and ennter calculation field, and also details of array formula all type, and all details of database function.
I am regular reader of this site.
Thanks
Chandrashekher
Hi Shekher,
You can find an index of Excel formulas and other tools here, including arrays, database functions and the like.
I’m not sure you’ll find a tutorial on how to enter a calculated field in a PivotTable though. I am yet to write about that, sorry.
Kind regards,
Mynda.
I have two sets of spreadsheets which at the end of the month i have to integrate, the challenge is for me to integrate the two i need a sum if formular which incorporates two variables
Hi Hamilton,
You can use either SUMIFS or SUMPRODUCT.
Kind regards,
Mynda.
I have many pivot tables and want to assign dynamic print area to all those. The print area should change automatically with the change in data. How to do it. There may be null row values in some case.
Hi Nik,
Sounds so vague to just say it.
Please send it to Help Desk and let’s see what we can do about it.
Cheers.
CarloE
Hi — I would like to get the median (instead of mean) calculated in my pivot table because I have highly skewed data. Do you know of any effective work around? Thanks.
Hi Anita,
I have tried to search for answers but the best thing to do is calculate median outside of the Pivot Table.
There may be some VBA workarounds here but it is outside the support we are providing. The good news is that
we are currently building a VBA program for our site.
Cheers.
CarloE
I find your website quite useful and I have added it to the list of my favorites at work and even on my personal laptop.
Thanks for all the tips.
Hi Funmi,
On behalf of Mynda,
You’re welcome!
Cheers,
CarloE
gud its help me lots