|
|
Featured Tutorial
Featured Macro
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
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