This project is done using Excel pivot tables to summarize the production of Honey:
- Pivot table to find the total and average production of honey in each state.
- Pivot table to find the Stocks in each state.
- Pivot table to find the total stock production in a year, maximum stocks in that year, total production value and average production value of the year. This pivot table also shows the Grand totals of all the columns.