1 / 18

Tutorial 5 - Session 5.3

Tutorial 5 - Session 5.3. Working with Excel Lists. Session 5.3 Objectives. Learn to summarize data using the PivotTable Wizard. Pivot Table. Enables you to: Group Summarize Categories available: COUNT SUM AVERAGE MAX and MIN. Pivot Table Elements. Column fields Row fields

dobry
Download Presentation

Tutorial 5 - Session 5.3

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. Tutorial 5 - Session 5.3 Working with Excel Lists Intro to Excel - Session 5.3

  2. Session 5.3 Objectives • Learn to summarize data using the PivotTable Wizard Intro to Excel - Session 5.3

  3. Pivot Table • Enables you to: • Group • Summarize • Categories available: • COUNT • SUM • AVERAGE • MAX and MIN Intro to Excel - Session 5.3

  4. Pivot Table Elements • Column fields • Row fields • Page fields • Data fields Intro to Excel - Session 5.3

  5. Advantages of Pivot Tables • Easily rearrange, hide and display data • Display “different” tables containing “different” data Intro to Excel - Session 5.3

  6. Intro to Excel - Session 5.3

  7. Figure 5-31, page 5.35 Intro to Excel - Session 5.3

  8. Creating a Pivot Table • Identify the source of data & kind of report • Identify the location of the data • Specify the location of the table • Specify the layout of the pivot table Intro to Excel - Session 5.3

  9. Step 1: Identifying Data Source Intro to Excel - Session 5.3

  10. Step 2: Identifying Data Location Intro to Excel - Session 5.3

  11. Step 3: Specifying Table Location Intro to Excel - Session 5.3

  12. Pivot Table Framework Intro to Excel - Session 5.3

  13. Pivot Table Toolbar Intro to Excel - Session 5.3

  14. Laying Out the Pivot Table • Drag row fields to Drop Rows Fields Here • Drag column fields to Drop Column Fields Here • Drag fields containing summary data to Drop Data Items Here Intro to Excel - Session 5.3

  15. Changing a Pivot Table’s Layout • Format numbers and labels • Reposition fields • Sort Intro to Excel - Session 5.3

  16. Adding a Field to a Pivot Table • Select any cell in the pivot table • Select the field in the Pivot Table toolbar to the appropriate section Intro to Excel - Session 5.3

  17. Removing a Field to a Pivot Table • Drag the field button outside the pivot table. Intro to Excel - Session 5.3

  18. Refreshing a Pivot Table • Select any cell in the pivot table • Select the Refresh Data button Intro to Excel - Session 5.3

More Related