Excel Forum
Similar Content
Enable the Analysis ToolPak in Excel
Tutorial: How to enable the Analysis ToolPak in Excel. This is an add-in program that comes with Exc...
Easily Compare Duplicate Values in Excel
Tutorial: Here, I'll show you a simple technique to quickly and easily compare large lists of duplic...
Complex Structured References (Table Formulas) in Excel
Tutorial: How to use complex structured references, table formulas, in Excel. If you don't already...

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

Got a Question? Ask it Here in the Forum.