1 / 7

AGB 260: Agribusiness Information Technology

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.

Download Presentation

AGB 260: Agribusiness Information Technology

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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

More Related