Pivot Table – A Sample Of Easy To Use And Powerful It Is

Excel function tutorials

If you want to learn Excel, keep reading or Get 10 days of free unlimited access to Lynda.com. for professional help and Excel Tutorials

A few years ago, we had a tutorial about how to build a pivot table, which you can see here. A major advantage of using Pivot Tables is that it’s very easy to make sense of large sets of data and draw summaries.

Last week, I received an email from the Penn State Extension which is working with a database that will help growers determine what pesticides are most effective to use for specific conditions or fruits. She has a huge list populated by the farmers for Apples for example where she is able to see different sets of information, here is a preview (as always, the full file is available at the end of this post):

The first question I was asked was the best way to get the number of times each pesticide had been used. My first answer was a very simple “sumif excel function” which I often use here.

As Sladjana let me know, that would work but it would require:

-Having the list of every single pesticide being used
-Would require updating the list when new ones were being added

Not ideal indeed. A macro could have certainly worked but it seemed unnecessary. I ended up going for a pivot table. How? I simply created it by clicking on the icon seen here:

Then I selected the data (including headers of course!) and was presented with this pivot table:

Then I dragged the column: “Pesticide Trade Name” into both the bottom left section and the bottom right section, which by default gives me the “count” of times it was used, see the result here:

It becomes very easy to update when the data changes, simply right click and select “refresh”

Easy enough? And it gives a complete picture that could become much more detailed depending on what is required/useful!

Feel free to download the spreadsheet. Thanks again to Penn State Extension for providing the data.


Look Good at Work and Become Indispensable Become an Excel Pro and Impress Your Boss


4 Feedbacks on "Pivot Table – A Sample Of Easy To Use And Powerful It Is"

fast reduce weight

Hello friends, how is everything, and what you desire
to say concerning this post, in my view its actually awesome in favor of me.

my abs light is on

Hi friends, its enormous article about tutoringand completely explained,
keep it up all the time.

free jailbreak iphone 4s 6.1.3

It’s actually a cool and useful piece of information.
I am happy that you just shared this helpful information with
us. Please stay us informed like this. Thank you for sharing.

healthy hair and skin

Hi, Neat post. There is an issue with your site in internet explorer, might
check this? IE nonetheless is the market leader and
a huge section of folks will omit your great writing due to this problem.


Please Leave a Comment!

Please note: Comments may be moderated. It may take a while for them to show on the page.