Highline Excel Class 20: Pivot Tables 20 Examples

See these 20 PivotTable Pivot Table examples:
1 Proper Format
2 Understanding Pivot Tables
3 Drag & Drop in 2003
4 Change 2003 to 2007
5 Pivot Table
6 right-click in 2007
7 Group Dates: Months
8 Group Dates: Year
9 Pivot w 4 fields
10 Drill Down
11 Value Field Settings: Function
12 Value Field Settings: Number Format
13 Styles
14 Pivot Chart: Product Year
15 Formula: Year, GP %
16 Product, Month, Jan-Apr, Diff From
17 Product, Month, Jan-Apr, % Diff From
18 Report Filter, 2006, products, Region, Show Report Filter Pages
19 More

This is a beginning to advanced Excel class taught at Highline Community College by Mike Gel excelisfun Girvin Busn 214 BTech 109

Category:

Science & Technology

Tags:

• Excel
• 2007
• 2003
• PivotTables
• Pivot
• Table
• Group
• Dates
• Formulas
• excelisfun
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[barbdwyre]

Excellent!

[ExcelIsFun]

@barbdwyre , I am glad that you liked it, but did you mean:

EXCELlent?

[vnklinger2003]

Mr Exxcel.. is it wise to utilize the same date for multiple pivots within the same workbook? Thankjs

[ExcelIsFun]

@vnklinger2003 , it is fine to have multiple Pivots.

[sirchang000]

Thank you for uploading this.. it was also very helpful and thoughtful of you to upload the worksheets!! Keep up the wonderful work!!

[ExcelIsFun]

@sirchang000 , link:

people.highline.edu/mgirvin/ex­celisfun.htm

[aareeeya]

thank you so much for the video.. Its totally worth it!

[ExcelIsFun]

@cajnewt , you are welcome!

[cajnewt]

Thanks for the video.

[ExcelIsFun]

You are welcome!

[gaotianyun]

Great video. Thank you!