Main Profile

At A Glance

Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. PivotTables are easy: Just envision the table in advance 2. Field list has fields and areas that you can drag fields to 3. Column Labels -- Column Headers 4. Row Labels -- Row Headers 5. Value Area -- this is where the calculation goes 6. Cross tabulation (row label and column label) 7. Double Click to create new sheet with data 8. Filter area -- filters whole report 9. Slicers 10. Value Field Settings Dialog box 11. Number Format For Value Field in Value Field Settings Dialog box 12. SUM function 13. Change Function in Value Field Settings Dialog box 14. Average Function 15. Format PivotTable 16. Layout For PivotTable 17. Multiple calculations: just drop field into value area multiple times and change function 18. Change Field Names in Value Field Settings Dialog box 19. Frequency Table to Count 20. Group By Dates
Length: 24:09

Contact

Questions about Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)

Want more info about Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question