Everything you need to know about Pivots: Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples Download workbook: people.highline.edu/mgirvin/AllClasses/214_2013/214/Busn214_2013.htm This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel. Topics in this video: 1. 3 Reports with Formulas (00:01:20 min) 2. What is a PivotTable do? (00:01:43 min) a. Summarize data b. "Calculation with criteria" c. Create Reports that contain calculations with conditions/criteria 3. Proper Data Set (00:02:57 min) 4. Visualize (00:03:16 min) 5. Create from Insert Tab (00:04:34 min) 6. Excel 2013 Create PivotTable dialog box keyboard: Alt, N, V (00:04:51 min) 7. Drag and drop from Field List (00:06:16 min) 8. Format to Show Field Names: Design, Report Layout, Show in Tabular Form (Format Tip #1) (00:08:37 min) 9. Number Formatting must be done on Field, not with Format Cells dialog Box (Format Tip #2) (00:09:30 min) 10. Create PivotTable Style (Format Tip #3) (00:10:32 min) a. Limited Formatting 11. Set PivotTable Style as Default (00:12:34 min) 12. Why Called Pivot? Pivot the report (00:13:16 min) 13. Pivot Data is stored in a cache (00:14:56 min) 14. Change Source Data (00:14:56 min) a. Formulas Update Automatically b. PivotTables update after "Refreshing" (00:15:54 min) i. Analyze PivotTableTools Tab ii. Alt + F5 (00:16:17 min) iii. Ctrl + Alt + F5 15. Copy A PivotTable Report (00:17:02 min) 16. Change Function (00:17:30 min) 17. Filter a Field (00:17:58 min) 18. Only 11 functions (00:19:33 min and 00:23:11 min) a. See list b. Formulas in cells can make many more calculations 19. One Stop Shopping for Calculations: Value Field Settings (00:18:57 min) 20. Text Data defaults to Count (00:21:18 min) 21. Number Data defaults to SUM (00:21:18 min) 22. Counting counts criteria: Counting records, Numbers or Text (00:22:06 min) 23. Mixed Data Defaults to Count (00:23:50 min) 24. Review: 5 steps to creating PivotTable (00:25:50 min) 25. Report we saw back in Subtotal video (00:25:40 min) 26. Report with three calculations (00:26:50 min) 27. Formulas vs PivotTables (00:28:42 min) PivotTables: 1) Fast and easy to create calculations with criteria. 2) Requires "Refresh" when Source Data Changes. 3) You can Pivot a report and add and remove whole categories of criteria and calculations update. 4) Change the function easily. 5) Formatting is limited. Formulas: 1) Usually more complicated to create calculations with criteria. 2) Automatically updates when Source Data Changes. 3) It is extremely difficult if not impossible to Pivot a report and add and remove whole categories of criteria. 4) Changing a function is more difficult with formulas. 5) Formatting is less limited. 28. Collapse and Expand criteria in Row Labels (00:29:48 min) 29. Extracting data to new sheet with Double Click (00:30:15 min) 30. PivotChart (00:31:03 min) 31. Group Dates: Right-click Date in Pivot and point to Group. (00:32:17 min) 32. Group Times: Right-click Time in Pivot and point to Group. (00:34:44 min) 33. Old Excel 2003 dialog box to group or ungroup a field in a second way: (00:36:07 min) a. Keyboard: Alt, D, P. b. This creates a separate cache of data. 34. Grouping can't be done with Data Mismatch (00:38:47 min) 35. Group Numbers: Decimal create ambiguous categories (00:40:34 min) (Integers: Lower and Upper Limits are included in Category. Decimals: Lower Limit is included and Upper Limits is not included in Category). Integer creates unambiguous categories 36. Recommended Chart: Amazing because it summarizes (00:43:11 min) 37. Recommended PivotTable (00:45:06 min) 38. Report Filter: Adds new criteria to report (00:46:01 min) 39. Show Report Filter (00:47:45 min): PivotTableTools Analyze Ribbon Tab, PivotTable group, Options, "Show Report Filter Pages". 40. Slicers (00:49:14 min): Fancy Filters: PivotTableTools Analyze Ribbon Tab, Filter group 41. Use Filter and Slicer together to extract data (00:50:14 min) 42. Timelines (00:53:13 min): PivotTableTools Analyze Ribbon Tab, Filter group Show Values As: % of Column 43. Show Values As: % of Grand Total (00:56:11 min) 44. Show Values As: % of Column (00:59:19 min) 45. Show Values As: % of Row (01:00:24 min) 46. Connect One Slicer to many PivotTables (01:01:34 min) 47. Show Values As: Running Total (01:03:21 min) 48. Show Values As: Difference From (01:05:02 min) 49. Show Values As: % Difference From (01:05:50 min) 50. Show Values As: % of Parent (01:07:15 min) 51. Modify PivotTable Style (01:08:47 min) 52. Show Values As: % of Parent Row Total (01:09:36 min) 53. Show Values As: % of Parent Column Total (01:09:36 min) 54. Show Values As: Rank (01:10:16 min) 55. Sort based on a Value Field (01:11:39 min) 56. Create Formula in PivotTable: Sales - Expense (01:12:01 min) 57. Data Model: to get new PivotTable function: Distinct Count. (01:13:53 min) 58. Use Data Model and Relationships to replace VLOOKUP (01:16:46 min) Pivot Tables
I have a pivot table test for a job the job is measuring call center input/output efficiency with pivot tables and vlookups..the pivot table example they gave has dates on the left column (6/7/2014-6/20/2014) and has subtotals (i.e. "1-3 days total", "4-7 days total", "8-10 days total", and finally "11-14 days total". can't figure out how to install subtotals in 3-4 day increments on pivot table? help.
This is absolutely the best class for Excel pivots on the internet - free or paid! Everything you need to know presented with great examples in just the right order and pace. Best hour I've ever spent in a training class.. Kudos to Michael Girvin and thanks to Highline for making it available on line!
I cannot express my gratitude to you for uploading the video. Thanks to your Pivot table guides and Lookup function guides, I've managed to land my first job in one of the worlds largest Pharmaceutical companies in the UK. Thank You so much Mike!
Nobody comes even close to you in EXCELLENCE for teaching Excel. You actually helped my career. I have both of your books and your CD Roms. Thank you for taking the time to benefit our lives.
You are welcome - I have been trying to make the world a better place - one Excel Video at a time for over 10 years : ) Thanks for your support with your Comments, Thumbs Ups, and buying the books !!!! Thanks, Rickey!!!!
As someone who has used pivot tables extensively in the past 3 years (and frankly has led me into the position I am in today), it's great to see simple things like tabular layout to rename columns in a pivot table. Before I was F2-ing into the cell to change the name, but now I know a better shortcut. Thanks for the video!
You know Mike, I've started referring to you as MG, more out of a feeling of endearment towards you...all because of the way you conduct your sessions. "Brrrp....look at that...how amazing...!". I can F-E-E-L the emotion myself when you say that...! Over the last few years, your channel has been my go to source for anything in Excel. When I face some issue while working on Excel data, the first thought that crosses my mind is "Let's look this up in MG's channel...!". And I can't recall a single occasion when I returned without an answer. Thanks for everything MG...!
I do not know how else to thank you for deeply explaining these topics. I have been looking for something like this for quite sometime. MAY GOOD KARMA FOLLOW YOU FOR THE REST OF YOUR LIFE.
The best excel videos I have ever seen. Everything in one channel. Tons of examples. And your way of telling things is just amazing. Keep up the great work.
Thanks for this, Michael. I was able to apply it to a new data set with only a couple of hours of watching and exploration. Your video demonstrates exactly what makes you an exceptional instructor at Highline - organization, thoroughness, patience, and enthusiasm.
Erik!?!?!? So cool to see you here at UA-cam, Fellow Awesome Instructor! Yes, this video is THE most complete I have ever done about the PivotTable. Good choice. And, thanks for your support with your comment and thumbs up : )
Thank you so much! This is absolutely the best class for Excel pivots on the internet. English is my second language but I can understand your explanation clearly. The way you explain is very clear and fun.
My God!! You are an amazing man!! I'm brasilian and I love watching your videos, they help me so much!! Thank you very much for you want to help all people to get rid of the difficulties of learning Excel!!!
You are my master. I like your way to explain functions. Especially when you want to focus in an important movement or action, you will use a fun tone which makes me smile and I talk with myself "Who is this guy!?". Indeed you make Excel fun. Thank you so much.
This is one incredible explanation of Pivot Table. I wasn't familiar with most of the functions you can do in PT. This is definitely the ultimate crash course of PT. Thank you so much for sharing your knowledge!
Excellent Pivot Table explanation with live examples. Systematic explanation keep it up. This information delivered in 1:21 hours is going to save my thousands of hours in my data analysis. Thank you ........ so............ much.
Thanks you bro. Thanks a lot. 1 week before when i last commented i watched this video for first time. And after one week, it may sound like an exaggeration but i have got my dream job in mis reporting... U r going help a family earn it's bread and butter. God bless you brother.
That is why I post - to help make the world a better place! Congratulations on the new job. Now it is your turn to help me with a Sub, and Thumbs Up and Comments on each video that you watch : )
Hello! Thanks a lot for your videos! So far I have see the ones related to PivotTables! But i will surely watch some more. I love the way you approach the problems and the fact that your way of explaining, and your speaking, allows me to watch the video at 1.5x and understand everything perfectly! Thanks a lot :) Greetings from Portugal
Started practising on real data as I am learning. This is really good and makes me wonder how I didn't use this tool in the first place. Keep up the good work.
Super stuff once again. I was amazed to see that double-clicking a value in a PT extracts all the relevant records for that criteria on a newly created sheet. I discovered that Undo will actually delete those new sheets...no need to right-click-delete to get rid of them.
Thank you for this super comprehensive tutorial on Excel pivot tables. I am a seasoned pivot table user and I still learned a lot that I was not aware of in Excel 2013/2016.
I wish I was using Excel 2013. I can't do examples 56 and 57 with Excel 2010. But that's OK, 55 examples had changed my life already. Thanks a lot dude.
Hey there. Great tutorials! I just want to share my appreciation for your time and effort into bringing these videos out. Awesome job. Keep it up. Although I'm an advanced excel user, I still find myself learning some really cool features that makes my job a whole lot easier. Thanks again.
Amazingly, awesome video. I love that you repeat steps/info since it helps me remember. For example - Right click for value field settings which is one stop shopping!
Thank you so much for this video. I'm learning pivot tables through career classes and am having trouble understanding pivot tables. Where I live it's a skill that is very much in demand.
Thank you ! The perfect class for Excel pivots. Your explanation are clearly. I can understand perfect everything, the fact that you repeat and emphasize is perfect for a easier way of remembering. Looking forward to watch the financial videos :) Thank you!
Hi Michael, Cool Video About Pivot tables. Not only Pivot Tables but also all the videos are cool. Worth Watching. Everyone will become A Master Like you by Watching this videos. Thanks Again to post such Videos
Thank you for your kind words!! I work hard to provide fun, effective and free Excel lessons to the World! You can help me by Subscribing and commenting and clicking Thumbs Up on each video that you watch. Maybe that will help even more people get to these free lessons : )
ExcelIsFun Sir I've already subscribed your channel and it's my fortune to learn from you and I will always like your videos whenever I will watch but I would like to tell you that I dally watch your videos and actually my you tube account is full with your offline videos...
did you hear about QlikView? it is a software that works this way: if you click a field name it highlights all the relevant records based on a formula or criteria you specify, this software has an ever powerful ability to summarize and analyze data in no time, here in Excel 2013, it was able to perform the same analysis in no time and effort, I think that gives excel one plus point over Qlikview, is that it accumulates data too, not just analyze them
Hi Michael really enjoyed this Video. I only have Excel 2007 and have been using Spreadsheets for over 10 years starting with Lotus123 which i thought was better than Excel 2003. It now looks like Spreadsheets are getting even closer to Database which is great as Spreadsheets are more flexible and Databases(Access) are more structured meaning it takes a lot more time to get a end report, therefore Spreadsheet are faster :) Many Thanks :)
At 54:38 inserting a Timeline, although the data source as no data of 2015, it creates the timeline with the year 2015, why this occures?! Thanks for this great video, and for the download workbook (which is rare ). You not only knows a lot, but amazingly you have a passion to transmit it and some appointments of humor. Thanks
Amazing Video I will have to watch few times to remember, But I can understand things at first go. I was little scared of pivot tables earlier but feeling very confident now.......Thank you Dost (Friend)
This is best video on pivot table and even a powerful use of excel...thank you do much for sharing. If you provide any paid trainings online please let me know...
I do not change money for this free Excel Class. It is all free at UA-cam. The payment from viewers like you is with the comments, Thumbs Ups, sub and telling all your friends : ) Here is the link to the full free training class: Excel 2013: ua-cam.com/play/PLrRPvpgDmw0nh4BBxqjcsnbB4ME4JjzfJ.html Excel 2016: ua-cam.com/play/PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw.html I also have many, many other free training courses. Do you know how to fine them? When you go to the excelisfun channel, the introduction to the channel video shows a lot about the channel: ua-cam.com/video/vKSAgdIKboY/v-deo.html
Thank you ExcelisFun.., Every lesson is very valuable however the biggest take away for me on this video was the tip on creating cache for 2013 excel and older. Alt, D, P. Also how to use the "Show Value As" function. Thank you
A holy angel, an incarnation of the supreme god.He is just another name of humanity and kindness.I really cant imagine how i would have been learning excel without this divine.
Mike, this is another great video for Excel users. At minute mark 0:52:26 you show how to hide slicer items with no data by checking a box in slicer settings, is there a similar setting in Excel 2010? Thanks for your help!!!
Everything you need to know about Pivots:
Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples
Download workbook: people.highline.edu/mgirvin/AllClasses/214_2013/214/Busn214_2013.htm
This is the Highline Community College Class, Spreadsheet Construction taught by Michael Girvin: Basic To Advanced Excel.
Topics in this video:
1. 3 Reports with Formulas (00:01:20 min)
2. What is a PivotTable do? (00:01:43 min)
a. Summarize data
b. "Calculation with criteria"
c. Create Reports that contain calculations with conditions/criteria
3. Proper Data Set (00:02:57 min)
4. Visualize (00:03:16 min)
5. Create from Insert Tab (00:04:34 min)
6. Excel 2013 Create PivotTable dialog box keyboard: Alt, N, V (00:04:51 min)
7. Drag and drop from Field List (00:06:16 min)
8. Format to Show Field Names: Design, Report Layout, Show in Tabular Form (Format Tip #1) (00:08:37 min)
9. Number Formatting must be done on Field, not with Format Cells dialog Box (Format Tip #2) (00:09:30 min)
10. Create PivotTable Style (Format Tip #3) (00:10:32 min)
a. Limited Formatting
11. Set PivotTable Style as Default (00:12:34 min)
12. Why Called Pivot? Pivot the report (00:13:16 min)
13. Pivot Data is stored in a cache (00:14:56 min)
14. Change Source Data (00:14:56 min)
a. Formulas Update Automatically
b. PivotTables update after "Refreshing" (00:15:54 min)
i. Analyze PivotTableTools Tab
ii. Alt + F5 (00:16:17 min)
iii. Ctrl + Alt + F5
15. Copy A PivotTable Report (00:17:02 min)
16. Change Function (00:17:30 min)
17. Filter a Field (00:17:58 min)
18. Only 11 functions (00:19:33 min and 00:23:11 min)
a. See list
b. Formulas in cells can make many more calculations
19. One Stop Shopping for Calculations: Value Field Settings (00:18:57 min)
20. Text Data defaults to Count (00:21:18 min)
21. Number Data defaults to SUM (00:21:18 min)
22. Counting counts criteria: Counting records, Numbers or Text (00:22:06 min)
23. Mixed Data Defaults to Count (00:23:50 min)
24. Review: 5 steps to creating PivotTable (00:25:50 min)
25. Report we saw back in Subtotal video (00:25:40 min)
26. Report with three calculations (00:26:50 min)
27. Formulas vs PivotTables (00:28:42 min)
PivotTables: 1) Fast and easy to create calculations with criteria. 2) Requires "Refresh" when Source Data Changes. 3) You can Pivot a report and add and remove whole categories of criteria and calculations update. 4) Change the function easily. 5) Formatting is limited.
Formulas: 1) Usually more complicated to create calculations with criteria. 2) Automatically updates when Source Data Changes. 3) It is extremely difficult if not impossible to Pivot a report and add and remove whole categories of criteria. 4) Changing a function is more difficult with formulas. 5) Formatting is less limited.
28. Collapse and Expand criteria in Row Labels (00:29:48 min)
29. Extracting data to new sheet with Double Click (00:30:15 min)
30. PivotChart (00:31:03 min)
31. Group Dates: Right-click Date in Pivot and point to Group. (00:32:17 min)
32. Group Times: Right-click Time in Pivot and point to Group. (00:34:44 min)
33. Old Excel 2003 dialog box to group or ungroup a field in a second way: (00:36:07 min)
a. Keyboard: Alt, D, P.
b. This creates a separate cache of data.
34. Grouping can't be done with Data Mismatch (00:38:47 min)
35. Group Numbers: Decimal create ambiguous categories (00:40:34 min) (Integers: Lower and Upper Limits are included in Category. Decimals: Lower Limit is included and Upper Limits is not included in Category). Integer creates unambiguous categories
36. Recommended Chart: Amazing because it summarizes (00:43:11 min)
37. Recommended PivotTable (00:45:06 min)
38. Report Filter: Adds new criteria to report (00:46:01 min)
39. Show Report Filter (00:47:45 min): PivotTableTools Analyze Ribbon Tab, PivotTable group, Options, "Show Report Filter Pages".
40. Slicers (00:49:14 min): Fancy Filters: PivotTableTools Analyze Ribbon Tab, Filter group
41. Use Filter and Slicer together to extract data (00:50:14 min)
42. Timelines (00:53:13 min): PivotTableTools Analyze Ribbon Tab, Filter group Show Values As: % of Column
43. Show Values As: % of Grand Total (00:56:11 min)
44. Show Values As: % of Column (00:59:19 min)
45. Show Values As: % of Row (01:00:24 min)
46. Connect One Slicer to many PivotTables (01:01:34 min)
47. Show Values As: Running Total (01:03:21 min)
48. Show Values As: Difference From (01:05:02 min)
49. Show Values As: % Difference From (01:05:50 min)
50. Show Values As: % of Parent (01:07:15 min)
51. Modify PivotTable Style (01:08:47 min)
52. Show Values As: % of Parent Row Total (01:09:36 min)
53. Show Values As: % of Parent Column Total (01:09:36 min)
54. Show Values As: Rank (01:10:16 min)
55. Sort based on a Value Field (01:11:39 min)
56. Create Formula in PivotTable: Sales - Expense (01:12:01 min)
57. Data Model: to get new PivotTable function: Distinct Count. (01:13:53 min)
58. Use Data Model and Relationships to replace VLOOKUP (01:16:46 min)
Pivot Tables
I have a pivot table test for a job the job is measuring call center input/output efficiency with pivot tables and vlookups..the pivot table example they gave has dates on the left column (6/7/2014-6/20/2014) and has subtotals (i.e. "1-3 days total", "4-7 days total", "8-10 days total", and finally "11-14 days total". can't figure out how to install subtotals in 3-4 day increments on pivot table? help.
Mmmn
Respond to your question you can find in this video on 40:25.
This is absolutely the best class for Excel pivots on the internet - free or paid! Everything you need to know presented with great examples in just the right order and pace. Best hour I've ever spent in a training class.. Kudos to Michael Girvin and thanks to Highline for making it available on line!
INDEED !
I cannot express my gratitude to you for uploading the video.
Thanks to your Pivot table guides and Lookup function guides, I've managed to land my first job in one of the worlds largest Pharmaceutical companies in the UK.
Thank You so much Mike!
You are welcome!
Nobody comes even close to you in EXCELLENCE for teaching Excel. You actually helped my career. I have both of your books and your CD Roms. Thank you for taking the time to benefit our lives.
You are welcome - I have been trying to make the world a better place - one Excel Video at a time for over 10 years : ) Thanks for your support with your Comments, Thumbs Ups, and buying the books !!!! Thanks, Rickey!!!!
As someone who has used pivot tables extensively in the past 3 years (and frankly has led me into the position I am in today), it's great to see simple things like tabular layout to rename columns in a pivot table. Before I was F2-ing into the cell to change the name, but now I know a better shortcut. Thanks for the video!
You are welcome!
You know Mike, I've started referring to you as MG, more out of a feeling of endearment towards you...all because of the way you conduct your sessions.
"Brrrp....look at that...how amazing...!". I can F-E-E-L the emotion myself when you say that...!
Over the last few years, your channel has been my go to source for anything in Excel.
When I face some issue while working on Excel data, the first thought that crosses my mind is "Let's look this up in MG's channel...!". And I can't recall a single occasion when I returned without an answer.
Thanks for everything MG...!
You are welcome for everything, Sriram! -- MG
You can help me too. For each video that your learn from, click that thumbs up and leave a comment - it really helps : )
@@excelisfun Consider it done MG...! Keep up the good work :)
I do not know how else to thank you for deeply explaining these topics. I have been looking for something like this for quite sometime. MAY GOOD KARMA FOLLOW YOU FOR THE REST OF YOUR LIFE.
You are welcome!!
The best excel videos I have ever seen. Everything in one channel. Tons of examples. And your way of telling things is just amazing. Keep up the great work.
OK I will try to keep posting fun and informative videos! Thanks for your support, Satyam, with your kind comment, Thumbs Up and Sub : )
You are really a blessing ....many guys earn their bread and butter using excel here...you r amazing
Thanks for this, Michael. I was able to apply it to a new data set with only a couple of hours of watching and exploration. Your video demonstrates exactly what makes you an exceptional instructor at Highline - organization, thoroughness, patience, and enthusiasm.
Erik!?!?!? So cool to see you here at UA-cam, Fellow Awesome Instructor! Yes, this video is THE most complete I have ever done about the PivotTable. Good choice. And, thanks for your support with your comment and thumbs up : )
Thank you so much! This is absolutely the best class for Excel pivots on the internet. English is my second language but I can understand your explanation clearly. The way you explain is very clear and fun.
INDEED
the way of teaching without any ambiguity is fantastic.thank u so much great job
You are welcome! Thanks for the Sub and Thumbs Up : )
Words can't describe how thankful I am for these beautifully presented lessons.
You are welcome, word!!!
+ExcelIsFun
If that was a correction I'm thankful for it :-)
My God!! You are an amazing man!! I'm brasilian and I love watching your videos, they help me so much!! Thank you very much for you want to help all people to get rid of the difficulties of learning Excel!!!
You are welcome! By posting these videos, now we can all have fun with Excel ; ) Thanks for the Thumbs Up and Sub!!
Just had Office 360 installed today and, coming from 2007, you just saved me a significant amount of reading time, Thanks!
You are my master. I like your way to explain functions. Especially when you want to focus in an important movement or action, you will use a fun tone which makes me smile and I talk with myself "Who is this guy!?". Indeed you make Excel fun. Thank you so much.
You are so much welcome! Thanks for the support with your comment, Thumbs Up and Sub : )
This is one incredible explanation of Pivot Table. I wasn't familiar with most of the functions you can do in PT. This is definitely the ultimate crash course of PT. Thank you so much for sharing your knowledge!
You are so much welcome! Thanks for the support with your comment, Thumbs Up and Sub : )
Excellent Pivot Table explanation with live examples. Systematic explanation keep it up. This information delivered in 1:21 hours is going to save my thousands of hours in my data analysis. Thank you ........ so............ much.
You are welcome! I am glad that the videos help!
Thanks you bro. Thanks a lot. 1 week before when i last commented i watched this video for first time. And after one week, it may sound like an exaggeration but i have got my dream job in mis reporting...
U r going help a family earn it's bread and butter.
God bless you brother.
That is why I post - to help make the world a better place! Congratulations on the new job. Now it is your turn to help me with a Sub, and Thumbs Up and Comments on each video that you watch : )
Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples
the way you narrated the video made it x9999 more bearable to watch
Excel is really fantastic, but the enthusiasm that you put in your explaination makes it really amazing! Thank you so much!!
Hello! Thanks a lot for your videos!
So far I have see the ones related to PivotTables! But i will surely watch some more.
I love the way you approach the problems and the fact that your way of explaining, and your speaking, allows me to watch the video at 1.5x and understand everything perfectly!
Thanks a lot :)
Greetings from Portugal
Glad you like it at 1.5!!!! Thanks for the support with your comment, Thumbs Up and Sub : )
some ppl still exist in this world who can change lots of things... thanks a lot
Started practising on real data as I am learning. This is really good and makes me wonder how I didn't use this tool in the first place. Keep up the good work.
Thank you! Thanks for the support with your comment, Thumbs Up and Sub : )
Watched this twice and its awesome. I still don't get how you manage to stay in character throughout the whole video but it is amazingly helpful!
+Manuel Montes The reason is because it is not "character", it is just me: A guy having fun with Excel!!!
Super stuff once again. I was amazed to see that double-clicking a value in a PT extracts all the relevant records for that criteria on a newly created sheet. I discovered that Undo will actually delete those new sheets...no need to right-click-delete to get rid of them.
Thank you for this super comprehensive tutorial on Excel pivot tables. I am a seasoned pivot table user and I still learned a lot that I was not aware of in Excel 2013/2016.
Glad you like it! Thanks for the Thumbs Up & Sub! : )
I wish I was using Excel 2013. I can't do examples 56 and 57 with Excel 2010.
But that's OK, 55 examples had changed my life already. Thanks a lot dude.
You are welcome!
Your videos are amazing Michael, they've helped so much with my job and career progression. Please keep up the good work.
Hey there. Great tutorials! I just want to share my appreciation for your time and effort into bringing these videos out. Awesome job. Keep it up. Although I'm an advanced excel user, I still find myself learning some really cool features that makes my job a whole lot easier. Thanks again.
Glad the videos help!
Keep 'em coming!
I will!!!
Amazingly, awesome video. I love that you repeat steps/info since it helps me remember. For example - Right click for value field settings which is one stop shopping!
Yes!!!! Glad you like the one-stop shopping : ) Thanks for supporting with your cool comments, thumbs ups and of course your Sub : )
Genius!! No one can teach excel better even after charging hefty fees.
S Kool Glad you like the videos! And they are for free! :)
I use lot of free education resoursces in more areas but to be honest your creation is by far the best in many attributes. big thanks
Big Welcome!!!
Thank you so much for this video. I'm learning pivot tables through career classes and am having trouble understanding pivot tables. Where I live it's a skill that is very much in demand.
Glad this helps. PivotTables are the #1 reporting tool in the world.
Only 14 minutes in, and this is unbelievably wonderful! I'm in awe! Thanks for sharing :)
Glad you like it!
Thank you ! The perfect class for Excel pivots. Your explanation are clearly. I can understand perfect everything, the fact that you repeat and emphasize is perfect for a easier way of remembering. Looking forward to watch the financial videos :) Thank you!
+ad_na_ You are welcome!
Wow, it's amazing! Your video really helps me a lot, thank you so much! The BEST excel tutorial on UA-cam!
Glad it helps! Thank you for your support with comment, Thumbs Up and Sub : )
Woooowww!!! men this is the first video I watched of your channel, thanks a lot this is really good, cant wait to see more. Greetings
Top quality video clips for Excel lesson in details by a fantastic speaker with a very clear and attractive voice
Glad the video helps! Thanks for your support with your comment and Thumbs up!!!
Hi Michael, Cool Video About Pivot tables. Not only Pivot Tables but also all the videos are cool. Worth Watching. Everyone will become A Master Like you by Watching this videos.
Thanks Again to post such Videos
You are welcome!
You are a hero, thank you so much. What a fantastic resource your channel is.
I realy appreciate the hard work you do all these time, i learn every day i lot of tricks from you ;) keep going u r the best in Excel
You did the great job for the community. I admire. Looking forward to seeing your powerpivot in soonest. Much thanks.
Glad you like the video!
you are the best teacher in the world
Thank you for your kind words : ) Thanks for the support with your comment, Thumbs Up and Sub : )
Amazingly Awesome.. One stop to learn everything about pivot table... Very nicely explained.. Thanks a lot.. I appreciate.
You are welcome! One Stop Shopping is good!
Sir you are really so great we always learn many things from you you.....I would like to thanks you for all your Hardwork for us.
Thank you for your kind words!! I work hard to provide fun, effective and free Excel lessons to the World! You can help me by Subscribing and commenting and clicking Thumbs Up on each video that you watch. Maybe that will help even more people get to these free lessons : )
ExcelIsFun Sir I've already subscribed your channel and it's my fortune to learn from you and I will always like your videos whenever I will watch but I would like to tell you that I dally watch your videos and actually my you tube account is full with your offline videos...
Awesome! I am very happy that the video I post help you : )
Amazing!! the combination of slicers and pivot tables works the same as QlikView principle. I can't believe Excel has this power!!!
Yes,I love slicers too! Excel has great power!
This one video is just about the most epic video that I have ever made!
did you hear about QlikView? it is a software that works this way: if you click a field name it highlights all the relevant records based on a formula or criteria you specify, this software has an ever powerful ability to summarize and analyze data in no time, here in Excel 2013, it was able to perform the same analysis in no time and effort, I think that gives excel one plus point over Qlikview, is that it accumulates data too, not just analyze them
Mohammad Taha Excel In Excel I have not heard to QilkView. But as you say, Excel has the advantage.
I applaud your pacing, clarity, and organization. Very useful for those wanting to grow their Excel skills. This will be helpful to me.
Glad that the video helps!
I wish I could like this video a couple of thousand times!
Thank you for the very kind compliment!
Hi Michael really enjoyed this Video. I only have Excel 2007 and have been using Spreadsheets for over 10 years starting with Lotus123 which i thought was better than Excel 2003. It now looks like Spreadsheets are getting even closer to Database which is great as Spreadsheets are more flexible and Databases(Access) are more structured meaning it takes a lot more time to get a end report, therefore Spreadsheet are faster :)
Many Thanks :)
You are welcome!
Thanks for hitting LIKE!
Mike, this is a huge work! Thanks a lot!
Timed TOC is supercool - I could watch only the things I wanted!
Cool! Glad you like it, pmsocho!!!
Data Model to get distinct count, and to create relationships is just so coool ! Thanks Mike:)
For this short time to know advanced Pivots is amazing. Thank you for your video!
Best excel trainer on youtube
Thank you for your kind words : ) Thanks for the support with your comment, Thumbs Up and Sub : )
Your videos and the energy you give is awesome!
Glad you like it!
Oh wow... this is so awesome!!! I really don't know how to thank you for sharing this information... you made it for me!!!!
You are welcome!
Thank you very much for the video. Salute and respect for the hard work and dedication put in behind this work.....
You are welcome! Thank you for your comment, Thumbs Up and Sub : )
Excellent tutorial. I know quite a bit on pivot tables, but this showed me things I was not aware of and the new functions available.
I am glad that the video helps!
Super helpful! I really appreciate the work you put into these videos.
You are welcome, Riley!
I think you did Great Great efforts and you always deserve all appreciations. Bless you.
At 54:38 inserting a Timeline, although the data source as no data of 2015, it creates the timeline with the year 2015, why this occures?! Thanks for this great video, and for the download workbook (which is rare ). You not only knows a lot, but amazingly you have a passion to transmit it and some appointments of humor. Thanks
Your videos are the best ones! Thank you so much!
You are so welcome, Cecilia : )
Great Videos !!! Amazing Teacher ! and so helpful !
Glad they help you, S. K. !!!!!!
Amazing Video I will have to watch few times to remember, But I can understand things at first go. I was little scared of pivot tables earlier but feeling very confident now.......Thank you Dost (Friend)
You are welcome!
awesome, great, amazing, the best video to know all about Pivot Table.
Many thanks
You are welcome!
Best Excel tutorial ever!! Really a Nice job!
Glad you like it!
Thanks so much for all your videos, I have learned so much from your work!
You are welcome!
I really appreciate it man, and I thought I knew about excel. You really make it easy !!! Much appreciate it
You are welcome!
Pivot A to z .... Great video 👍❤️
Without a doubt THE best PivotTable video that I have ever made. Glad you like this one, shubham : )
best excel videos ever!!
Really helpful and easily adopted to work, cheers
Glad you find it helpful!
Thank you so much! Your videos are always awesome!
This is best video on pivot table and even a powerful use of excel...thank you do much for sharing. If you provide any paid trainings online please let me know...
I do not change money for this free Excel Class. It is all free at UA-cam. The payment from viewers like you is with the comments, Thumbs Ups, sub and telling all your friends : ) Here is the link to the full free training class: Excel 2013: ua-cam.com/play/PLrRPvpgDmw0nh4BBxqjcsnbB4ME4JjzfJ.html
Excel 2016: ua-cam.com/play/PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw.html
I also have many, many other free training courses. Do you know how to fine them? When you go to the excelisfun channel, the introduction to the channel video shows a lot about the channel: ua-cam.com/video/vKSAgdIKboY/v-deo.html
Creating PivotTables is fun????? You betcha when Mike Girvin is teaching the class!!!!!
Yes they are fun : )
Thank you for all your wonderful videos! They are great!
When You Learn Excel From Mike Girvin Excel is Really Fun. Geo(Long Live) Mike Geo............
Sohel Ahmed , I am glad that the videos help, and are fun!
Sir I build Some formula("text to Column, Mod 10) inspiring from Your "Ctrl+Shift+Enter" . Plz Give Me Your email I wanna send it you for check back.
Congratulations for this video and efforts put into it. Great job and God bless...
always Great Mr. Girvin
Thanks l learned a lot of new things from your videos, thanks again you are awesome
+Abdullah Al-Oraimi I am glad that the video helps!
Thank you ExcelisFun.., Every lesson is very valuable however the biggest take away for me on this video was the tip on creating cache for 2013 excel and older. Alt, D, P. Also how to use the "Show Value As" function. Thank you
WHAT ARE YOU? AN ANGEL SENT BY GOD OR SOMETHING!?? YOU'RE A WINNER! THANKS A LOT!
Not, an angel, just a guy having fun with Excel!! Glad you like the video!!
00kizuna00 my thought exactly!!
The best tutorial out there. You are the best!!! wow THANK YOU!!
A holy angel, an incarnation of the supreme god.He is just another name of humanity and kindness.I really cant imagine how i would have been learning excel without this divine.
Amazing examples. Thanks. I've learned so much.
You are welcome!
Excellent videos. Thanx a lot for sharing!
You are welcome!
This is really great. Excellent work!!
Glad you like it! Thanks for the Sub and Thumbs Up : )
Boom! Another fantastic vid!
Boom!
The best ever video!
Congratulations.
Another set of great stuff...Thank you
You are welcome!
Thank you so much for helpful sharing. Wonderful.
You are welcome, Quyen! Thank you for your support with your comment, Thumbs Up and Sub : )
Wow! this is a great video and clearly explained.
Glad you like it!
This video saves lifessssssss! Definitely saved mine!
I am enjoying this...God bless you
Glad you like it!! Thanks for the support with your comment, Thumbs Up and Sub : )
This is really awesome. Thank you very much for this nice presentation.
You are welcome!
Great fun on sunday morning. :) :)
That is a good way to spend Sunday : )
Thank you so much for your amazing video. It's really helpful!
You are welcome, Yingxin!!
You are absolutely positively crazy! :) This tutorial is really good!
Glad you like it! Thanks for the Thumbs Up & Sub! : )
what a great vid really it helped me a lot to understand pivot table much better :)
Glad it is helped, Aiman!!!! Thank you for the support with your comment, Thumbs Up and Sub : )
Mike, this is another great video for Excel users. At minute mark 0:52:26 you show how to hide slicer items with no data by checking a box in slicer settings, is there a similar setting in Excel 2010? Thanks for your help!!!
Excellent video, thanks Mike
You are welcome!
amazing....increased my pivot table knowledge,thank you mike....wants to know about macro with pivot...can you suggest any of your video
I am sorry but I do not have a video on that.
amazon lesson! thanks man. you made it fun to learn.
Thank you for this amazing video !!!
You are welcome! Thanks for the Thumbs Up!!