Pivot Tables in Excel
Pivot tables are one of the most useful tool of Excel when you need to go through big table of data or numbers. This is ideal in this big Data age.
Pivot tables in Excel are quite easy to use once you understand the basic principle. It allow to regroup data that is similar, add rows with the same headers, find sum of columns easily, make relationships between one type of data and another type of data. With a Pivot Table in Excel you can "see" things that are usually hidden in this big amount of data.
Lets take the data from from a Farm Orchard collected over from 2010 to 2014.