AGB 260: Agribusiness Information Technology

1. AGB 260: Agribusiness Information Technology Pivot Tables and Pivot Charts

2. Useful Chapters in the Textbook Regarding this Lecture • Chapter 43

3. Pivot Tables • A pivot table is a tool in Excel that can allow you to dynamically examine aspects of the data very quickly. • It is meant to take many rows and columns and make meaning out of them through its quick reporting capability. • Pivot tables are very valuable because they allow you to quickly interact with your data. • It allows you to look at the data in many different ways. • A drawback of a pivot table is that it does not automatically update when the data has changed.

4. Using Pivot Tables • To use a pivot table, you want to highlight the data of interest in your worksheet. • Once the data is highlighted, you can go to the Insert ribbon and click on the Pivot Table button. • This will bring up a dialogue box that will confirm the data you want to work with and query you where you want to put the pivot table.

5. Main Components of a Pivot Table • The fields (i.e., the columns from your data) • The Rows • You would drag your fields that you would like for your rows of the report here. • The Columns • You would drag your fields that you would like for your columns of the report here. • The Values • You would drag your fields that you would like summarized for your report here. • The Filters • You would drag your fields that you would like to use as a filter here.

6. Pivot Table Specific Ribbons • There are two ribbons that become available once you make a pivot table: • Analyze • Analyze gives you the ability to work with the data to see different aspects of it. • Design • Gives you the ability to format the data and how it is presented.

7. In-Class Activity • Explore AGB 260 Lecture 7 Data.xlsx using a pivot table • Explore Lecture7Data using a pivot table