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

Category:

Education

Tags:

• Office
• 2010
• Mike
• Gel
• Girvin
• excelisfun
• Highline
• Community
• College
• Busn
• 216
• Computer
• Applications
• Class
• Excel
• Pivot
• Tables
• PivotTables
• Data
• Analysis
• Formatting
• Slicers
• Functions
• formulas
• SUM
• AVERAGE
• MAX
• MIN
• Layout
• Multiple
• calculations
• Grouping
• Group
• Dates
• Summarize
• data
• daily
• monthly
• Sales
• Report
• Column
• Labels
• Row
• Filter

[kannonne]

I've been working with Excel but I never thought it could be fun.

Now I know better! Learned to do things so much simpler.

Thank you! From The Netherlands three cheers for ExcelisFun...

[ExcelIsFun]

@kannonne , I am glad that the videos help!!

[ContrastY]

Thanks for the tips, very helpful information.

I've subscribed.

[ExcelIsFun]

@ContrastY , I am glad that the video is useful!

[thebusyman1]

Big fan from Finland. This is incredible.

[ExcelIsFun]

@thebusyman1 , Cool, I am glad that this helps!

[nohandtyper]

Incredible video. Very helpful. Thank you so much!

[sarahliu122]

This video makes PivotTables much easier to understand and to use. I could put PivotTable on my resume now. Thanks a lot!

[vulture1017]

Thank you dude! God bless..



[ExcelIsFun]

@Yaqqob , I am glad it helped. But did you mean:

EXCELlent work?