70 likes | 268 Views
AGB 260: Agribusiness Information Technology. Pivot Tables and Pivot Charts. Useful Chapters in the Textbook Regarding this Lecture. Chapter 43. Pivot Tables. A pivot table is a tool in Excel that can allow you to dynamically examine aspects of the data very quickly.
E N D
AGB 260: Agribusiness Information Technology Pivot Tables and Pivot Charts
Useful Chapters in the Textbook Regarding this Lecture • Chapter 43
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.
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.
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.
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.
In-Class Activity • Explore AGB 260 Lecture 7 Data.xlsx using a pivot table • Explore Lecture7Data using a pivot table