Jon, I taught for thirteen years before pivoting to data analysis and I must say that your delivery is better than so many teachers I worked with. There is a harmful belief that students are not learning because teachers are not animated (read: not enough of an entertainer) ...thank you for being a testament that good teaching is direct, thorough, and well-paced. Cheers!
Hi Jon! I just wanted to let you know that your videos really helped me get a my most desired position for a new role in an international company. I'm very very grateful and you should continue sharing your knowledge. By doing this, you really make a difference in people`s lives. Thank you again!
Thank you Winnie! I really appreciate that. I'm also happy to hear you keep coming back. Practice and repetition is so important for learning, and something I stress inside our training courses. It's great that you are using this as a resource and implementing what you are learning. Awesome! 🙌
I used to use Excel all the time and was considered a guru because I used pivot tables. I've been in another career for 10 years and was worried I'd forgotten everything (upcoming job interview has me scurrying). Your video is undoubtedly the best - and now I've subscribed to your channel. If I knew 1/10th of what you know, I'd be a real guru, but I'm going to watch all over your videos over and over until I get it. Thank you for being so clear, concise and thorough!
Can anyone tell me how to match two data lists together in excel so the dates sit in the same rows? eg. would need to excel to match dates and leave gaps on days there are no matches. 11/11/18 . 11/12/18 11/10/18 . 11/11/18 11/08/18 . 11/09/18
Great video content! Forgive me for the intrusion, I am interested in your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (Sure I saw it on Google)? It is a good exclusive product for getting 7000 plus project management and business templates without the hard work. Ive heard some awesome things about it and my close friend Aubrey after many years got great results with it.
I was about to hire someone to teach me Ms Excel. But, I changed my mind. I already found a brilliant teacher like you for free. WOW! YOU are doing a fantastic job Jon. May God bless you more wisdom to share to us. Thank you so very much! Keep it up!
Dude....literally the first 5 minutes of this video has saved me countless hours of work.....can't believe I've been doing things the dumb way for so long.
Please allow me to just say, i am so grateful to have you here being so patient and teaching at a level that makes perfect sense. I am forever a subscriber.
THANK YOU SO MUCH. I HAD GOT AN JOB ASSIGNMENT YESTERDAY , HAD TO MAKE a dashboard , i never used this , you explained so simply. finally i made it. thank you.
Hi Jon, I start a new Job this week and will need to use Pivot tables and other various excel functions. You have eased my mind and helped me gain more confidence in my capability to deliver my work with flair. I look forward to learning more and becoming super efficient and fast with excel! Thank you Champ!
I recently started to learn the different functions in using a pivot table and adding charts for work. My boss is letting me take charge in creating analysis around different areas for our department. This was most helpful
I have struggled with excel till I bumped into your RUclips Channel. Excel has never been more fun to learn. What an amazing job you are doing! I have set aside some time every day to learn. Thank you very much.
Hello, I want to inform you that the video was really helpful to me. I was practising it along with you and enjoyed the process. I missed a job opportunity because I could not generate the pivot Table as directed. This is a wao!!!! moment for me now
Hi John, Leon Kotze from Namibia, joined your campus lately, and really blessed to have been guided here, gain a lot from your sessions, also going to work through macros next, Greetings
I've been searching for a good tutorial on Pivot Tables for some time. Finally I've found a tutor who knows how to present the subject, has the skills to convey understanding, and a manner that makes listening and learning a pleasure. Thank you so mu8ch.
Yup, It's me again. Finished Parts 2 and 3 - and finally did your Dashboard Tutorial that I've wanted for ages!!! You make it so easy it's almost a sin. Even an old coot like me just sails along with your instructions. Thank you, Jon
This is , in my opinion, actually the best channel that I’ve found to learn this new functionality. I’ve watched other videos before I spontaneously fell on this one. Without mentioning names and I’m not saying that these people weren’t explaining well, but they just offer an Excel-folder that’s already completed with the stuff they show in their video and I obviously can’t work/learn with that while watching. Too bad. But this is a well-made video that explains everything in the necessary details and you get an Excel-Folder that YOU have to complete while watching. And this for free. Great job! 👍
This video is literally saving my life right now lol! I have worked in AR and considered myself to be an expert at Excel until I started my new job! My new job is very Excel-heavy. I am familiar with Pivot Tables, but I didn't realize how much I did not know until I started this job. I didn't understand the sum column in the Pivot Table until I saw your tutorial. Now it all makes sense! I'm not even done watching this yet, but I had to come here and comment while I was having my lightbulb moment. Thanks!
Thank you very much for this instructional video. I will be starting to work as analyst and pivot table is a must. Before, I was really overly concern because I thought pivot table is really difficult. You made it so easy and I am thankful to God for people like you. More power, Sir!
I did a lot of findings on pivot tables, charts and dashboard but i couldn't get an explicit understanding about it. But i can tell you this, this is by far the most easiest mothed ever. Cheers Jon
I've been wanting to get additional training on Excel for years & never thought it would be this easy. Thank you so much for your clear & concise training! Absolutely love this.
Great video. I received a promotion at my job and I'm using your videos to help me with my trainings. I will be working on several reports and metrics, so I appreciate this video. I took an excel training that involved pivot tables and charts, and I must say, if you don't use it, you'll lose it. Your video will be saved.
Unlike other videos I have tried on pivot tables, this one is more detailed and it tells you why/how in a step-by-step process, and the visual and audio are really good. It is the best so far I have come across. Thanks Jon
Yesterday I did the same kind of task using python and its different libraries and today I'm watching this video and I burned, How easy it is in excel. Also, you explain it very precisely, Thanks for creating this video.
I am migrating to your free course here from edX. The problem with most online Excel courses and lessons (paid or otherwise) is that they go very slow throughout the videos and rightly so because we are beginners. Then halfway through those videoes as they introduce something new, they suddenly go fast without explaining what it is or how it works. I was 60% done with my edX course and I was infuriated when the coordinator failed to provide a proper explanation on how he customized the syntax of a function, and also, not giving us a model answer or solutions to the exercises so that we can work backward and maybe figure it out. I have clicked and watched through a handful of your videoes and I must say you presented the information very well, in a way that new learners can understand. I was so thankful and appreciative of your work that I was looking for a donations tab on your website. Then I stumbled upon your "Elevate Excel Training Program" which is premium. If you end up replying to this, may I ask what is the benefit of signing up? Are there lessons in there which are not available on RUclips?? I would love to sign up however as I am currently unemployed I am being more prudent with my resources. Regardless. Thank you so much for your classes again.
Hello Renzokuken, thank you for your interest in our Elevate course. 😀 The lessons we have in our Elevate course are not available here on RUclips, they are only exclusive to all active members. The step-by-step Elevate Excel tutorials will help you advance your Excel competency, so you can build upon your existing skills. Training includes video lessons (screencast videos), handouts, cheat sheets, and other resources. More information here www.excelcampus.com/join-elevate/
Thanks so much for this simplified explanation. One of my goals during the 2020 stay home order is to enhance my limited knowledge of Excel. This really helps!
Having the ability to create dashboards in excel will certainly bring you a great professional prominence within the company you work for. A well-designed dashboard is capable of impressing from the janitor to the CEO.
Hi Jon, you are made adding tabs very easy for me. I have downloaded your free e-workbook. I am taking data analytic classes and when I reference adding tabs its much easier for me to do it now. You are a great instructor. I will now look at your video for Pivot tables and reference back to your free e-workbook. Please keep adding videos on excel. I will be very good at this in no time.
These tutorials give me in-depth learning about how excel can create a lot of things we use. Thank you for sharing with us and hope for more lessons and tips that you can teach.
Correct me if I'm wrong: Although there are many new functions in micro 365, the methods of building basic Pivot Tables is pretty much the same in 2024 after a big change brought by Office 2010. Isn't that true?
Thank you so much. I am looking for new jobs and, after utterly failing an Excel test, got a good lesson to learn more skills. Coming from someone who's struggled in school, thank you.
I really enjoy watching your videos. I've checked a few out and yours are by far more superior to others I've watched. Others can have a patronising instructor but you come across friendly and professional. The pace is good and I can keep up. I had to do some learning prior to an interview on things I've never done before which helped me greatly. Got the job now to perfect my skills ready to start!!!
Excel is indeed a powerful tool and knowing how to use it is a great differentiator and can bring you a huge professional prominence. Knowing different functions, graphics and knowing how to apply them to your problems, will certainly bring you an absurd differential.
Great first Pivot Table video. Very clear instructions on your tasks. I wanted to get into the functions, data changes, and filters right away and didn't think I needed the chart stuff so early but I'm glad to see that Video 2 will cover that stuff. Thank you!
I have always been intimidated by PVs; avoided them at all costs and did the calculations the LONG WAY (obviously creating more work for myself). Your video clearly explains the "why" and "how" more effectively than the Excel course I took in college! The textbook was utterly useless and only covered three lessons. I have subscribed - I'm a sponge for knowledge!
This is the one of the best Excel Tutorial (Pivot Table) at RUclips, lecture is to the point and appropriate wording & example was used. Moreover, i would like to request to discuss Measures, Calculated Column & DAX Formula, please. Thanks a lot.
Thank you so much for producing these videos. I used to be incredibly intimidated by pivot tables, but your tutorials explain them in a very easy-to-understand manner! This has been unbelievably helpful!!!
Hi Jon, can you tell me what software I would require to create those toon characters? I need to do a project for college and this would be great for my presentation.
Hi Jon. I've taken many tutorials on Excel and Pivot tables, but your tutorial and exercises along with the worksheets are the best . Though I had a little trouble downloading the worksheet for this video, I was able to grab another data set from another one of your tutorials and practice along. I feel so much more comfortable in doing V lookups and pivot tables. Just what I needed as a refresher course. This was great!
Thanks so much for your kind words and nice feedback. I really appreciate it. I'm sorry to hear you had trouble with the download. We'll take a look at what might be causing that. Thanks again and have a nice weekend! 🙂
Hi Jon, simply outstanding presentation of the tutorials. I have seen multiple tutorials of yours, at the end of it, for learners like me, it provides a sense of satisfaction and confidence. Thank you!
Thank you! I just went to a job interview and the hiring manager is looking for someone with pivot table, charting and vlookup experience. Your tutorial was very helpful. I have subscribed to you channel, gave you thumbs up on video and hit the notification bell. Again thank you sharing your knowledge I will be watching your videos.
Hi there, thank you so much for this wonderful video, I've studies pivot tables in my academic level. But, now I'm graduated and applying for jobs. That was a much needed videos to polish and review my excel skills. Thanks a lot :)
Hi Jon, thank you for your really helpfull videos! I start a new job next week and I feel like this series truely helped me to prepare for it. Everything was super clear and entertaining to watch! I hope you have a wonderful day and wish you all the best!
Thank you, Jon, for your professional and easy-to-follow instruction. Really appreciate your making the practice data available and Mynda's link as well. So glad I found you!
Awesome teaching and quite simple, explaining in layman's terms. I have never used pivot tables before but think that I will be able to do so now confidently. Thank you.
Excellent video. One of the best lessons on Pivot Table I've seen. I was hoping that there was a Pivot Pal for the Mac, but I don't think so. Jon, you are a very good instructor. You make everything seems so easy.
Fantastic educational video! Clear, concise information that flowed smoothly. You integrated supporting tidbits of how's and why's very effectively. As an out-of-practice Industrial Engineering student, I especially appreciate the color coded boxing. I'm actually excited to see what else I learn from you guys.
Thank you for this amazing tutorial ! You made it look so simple and is funny how I had a question in my mind and you almost instantly answered it every time! Thanks and keep the great work!
So I was turned down from a job because I was not familiar with pivot tables 😒, however I am very proficient in excel and turns out I’m more than capable of doing this! Just wasn’t aware of the proper name for all this!!! Thank you for showing us!!!
Very nicely explained. Just to the point and easy to follow. I wish there was a file to download and work with just to practice the features of pivot tables. Got it!. :-). Thank you for sharing your knowledge.
Thanks. Actually, if you go to ExelCampus' website provided in the links below the video, Jon allows you to download all 3 sample files. He is a good teacher too.
Awesome video! Very well presented. So easy to follow along. I was clueless on how to create a simple pivot table and this tremendously helped me . Thanks sooooooo much!
Jon this was awesome, very helpful. I recently accepted a new role and want to work with data better and I believe that your videos will give me the assistance I need! Thank you!
Thank you so much! I am a small business owner in retail, and thanks to the video I now have created a spreadsheet from my POS export that shows everything I need for a better buy plan!!! Amazing!
Hey Jon. Thank you so much for sharing. You are an excellent teacher, you explain very well. Your course is easy to follow and pretty useful to learn how to visualise in a clear manner lots of business data. I am starting a new role soon and the pivot tables are going to be super necessary! Thank you again for your effort and for being so helpful with your videos.
This was a tremendous tutorial. I choose to decline a job offer because my lack of knowledge however, I have studied and practised. I have made excellent process and will continue to practice and reapply for another role with confidence. Thank you!
Hi Jon, I found your 3 part videos on Pivot tables very informative and helpful. I have a question on the detail tab tho. What are the drop-down arrows next to the titles of each column? And how to create them while entering data? Is it one of the features of Excel?
Hi Hong, Great question! Those are the Data Filters. You can turn them on/off from the Data menu in the ribbon. Here is an article I have on keyboard shortcuts for the Filter Drop-down Menus. www.excelcampus.com/keyboard-shortcuts/filter-dropdown-menu-shortcuts/
Jon, I taught for thirteen years before pivoting to data analysis and I must say that your delivery is better than so many teachers I worked with. There is a harmful belief that students are not learning because teachers are not animated (read: not enough of an entertainer) ...thank you for being a testament that good teaching is direct, thorough, and well-paced. Cheers!
Hello nichole
Hi Jon! I just wanted to let you know that your videos really helped me get a my most desired position for a new role in an international company. I'm very very grateful and you should continue sharing your knowledge. By doing this, you really make a difference in people`s lives. Thank you again!
Glad to hear it, Ronald! 😀
I keep coming back to this tutorial. I have NEVER seen anything so lucid and easy to follow. It is my holy grail.
Thank you Winnie! I really appreciate that. I'm also happy to hear you keep coming back. Practice and repetition is so important for learning, and something I stress inside our training courses. It's great that you are using this as a resource and implementing what you are learning. Awesome! 🙌
I can see why. Great help.
0000
I used to use Excel all the time and was considered a guru because I used pivot tables. I've been in another career for 10 years and was worried I'd forgotten everything (upcoming job interview has me scurrying). Your video is undoubtedly the best - and now I've subscribed to your channel. If I knew 1/10th of what you know, I'd be a real guru, but I'm going to watch all over your videos over and over until I get it. Thank you for being so clear, concise and thorough!
Indeed he has given us the keys to the kingdom with this video!
Can anyone tell me how to match two data lists together in excel so the dates sit in the same rows?
eg. would need to excel to match dates and leave gaps on days there are no matches.
11/11/18 . 11/12/18
11/10/18 . 11/11/18
11/08/18 . 11/09/18
I have a similar story - only 20 years out.
Great video content! Forgive me for the intrusion, I am interested in your initial thoughts. Have you ever tried - Weydaniel Organized Dominator (Sure I saw it on Google)? It is a good exclusive product for getting 7000 plus project management and business templates without the hard work. Ive heard some awesome things about it and my close friend Aubrey after many years got great results with it.
Same here. It's funny how fast we forget things lol.
I was about to hire someone to teach me Ms Excel. But, I changed my mind. I already found a brilliant teacher like you for free. WOW! YOU are doing a fantastic job Jon. May God bless you more wisdom to share to us. Thank you so very much! Keep it up!
Good explaining
I have a business and always working with Excel. Your video has been very instrumental. Thank you
Dude....literally the first 5 minutes of this video has saved me countless hours of work.....can't believe I've been doing things the dumb way for so long.
Simply perfect: perfect timing, perfect volume control, organized and efficient. Thank you from a 70 year old geezer in Gainesville FL.
I'm from India, but a proud Gator.... I graduated from UF with Masters in Transportation Engineering!
Cheers!
@@050138 did we ask
@@semirasuleman1989 didnt tell ya!
Please allow me to just say, i am so grateful to have you here being so patient and teaching at a level that makes perfect sense. I am forever a subscriber.
You're so welcome and thank you for subscribing! 😀
THANK YOU SO MUCH. I HAD GOT AN JOB ASSIGNMENT YESTERDAY , HAD TO MAKE a dashboard , i never used this , you explained so simply. finally i made it. thank you.
Glad it helped! 😀
Hi Jon, I start a new Job this week and will need to use Pivot tables and other various excel functions. You have eased my mind and helped me gain more confidence in my capability to deliver my work with flair. I look forward to learning more and becoming super efficient and fast with excel! Thank you Champ!
your pic has eased my mind girl
@@cei5140 🤣🤣🤣
I recently started to learn the different functions in using a pivot table and adding charts for work. My boss is letting me take charge in creating analysis around different areas for our department. This was most helpful
I have struggled with excel till I bumped into your RUclips Channel. Excel has never been more fun to learn. What an amazing job you are doing! I have set aside some time every day to learn. Thank you very much.
Hello, I want to inform you that the video was really helpful to me. I was practising it along with you and enjoyed the process. I missed a job opportunity because I could not generate the pivot Table as directed. This is a wao!!!! moment for me now
ऊपर
Rxfvcdcq1qckjdndc fbdf1n
Hi John, Leon Kotze from Namibia, joined your campus lately, and really blessed to have been guided here, gain a lot from your sessions, also going to work through macros next, Greetings
Welcome aboard, Leon! 😀
I've been searching for a good tutorial on Pivot Tables for some time. Finally I've found a tutor who knows how to present the subject, has the skills to convey understanding, and a manner that makes listening and learning a pleasure. Thank you so mu8ch.
Yup, It's me again. Finished Parts 2 and 3 - and finally did your Dashboard Tutorial that I've wanted for ages!!! You make it so easy it's almost a sin. Even an old coot like me just sails along with your instructions. Thank you, Jon
This is , in my opinion, actually the best channel that I’ve found to learn this new functionality. I’ve watched other videos before I spontaneously fell on this one. Without mentioning names and I’m not saying that these people weren’t explaining well, but they just offer an Excel-folder that’s already completed with the stuff they show in their video and I obviously can’t work/learn with that while watching. Too bad. But this is a well-made video that explains everything in the necessary details and you get an Excel-Folder that YOU have to complete while watching. And this for free. Great job! 👍
I have seen several tutorials on the same subject, but this is by far the most explicit and easiest to understand. Congratulations Jon
Indeed
Yesterday, I was a completed ignorant. Thanks to your excellent tutorial video, now I have learned how to utilized Pivot tables. Rating 10 out of 10.
Thank you Ravana! :-)
This video is literally saving my life right now lol! I have worked in AR and considered myself to be an expert at Excel until I started my new job! My new job is very Excel-heavy. I am familiar with Pivot Tables, but I didn't realize how much I did not know until I started this job. I didn't understand the sum column in the Pivot Table until I saw your tutorial. Now it all makes sense! I'm not even done watching this yet, but I had to come here and comment while I was having my lightbulb moment. Thanks!
Although you dropped this video a few years ago... it doesn't go out of fashion!! Thank you!
Thank you very much for this instructional video. I will be starting to work as analyst and pivot table is a must. Before, I was really overly concern because I thought pivot table is really difficult. You made it so easy and I am thankful to God for people like you. More power, Sir!
Thank you Dennis and congrats on the new job! Awesome!
I did a lot of findings on pivot tables, charts and dashboard but i couldn't get an explicit understanding about it. But i can tell you this, this is by far the most easiest mothed ever. Cheers Jon
Dude, you saved my life today. My report is due in an hour and now it looks amazing! Thank you...
I've been wanting to get additional training on Excel for years & never thought it would be this easy. Thank you so much for your clear & concise training! Absolutely love this.
Great video. I received a promotion at my job and I'm using your videos to help me with my trainings. I will be working on several reports and metrics, so I appreciate this video. I took an excel training that involved pivot tables and charts, and I must say, if you don't use it, you'll lose it. Your video will be saved.
That is awesome, Isharah! Happy to hear that. 😀
Unlike other videos I have tried on pivot tables, this one is more detailed and it tells you why/how in a step-by-step process, and the visual and audio are really good. It is the best so far I have come across. Thanks Jon
Lll
Ql
1/q
PLp1\lPqp
/0q1
I am wowed....with your explanations on each steps...very short and detailed...video is seriously on point...good job
Yesterday I did the same kind of task using python and its different libraries and today I'm watching this video and I burned, How easy it is in excel. Also, you explain it very precisely, Thanks for creating this video.
are you from india can you teach me python please
I can’t imagine how grateful I am for coming to your campus to learn this Pivotal Table... Please accept my warmest appreciations
A big thank you for your "class" all of them about pivot tables. I learned and applied in my job and you help me to save my position. Thanks again
I am migrating to your free course here from edX. The problem with most online Excel courses and lessons (paid or otherwise) is that they go very slow throughout the videos and rightly so because we are beginners. Then halfway through those videoes as they introduce something new, they suddenly go fast without explaining what it is or how it works. I was 60% done with my edX course and I was infuriated when the coordinator failed to provide a proper explanation on how he customized the syntax of a function, and also, not giving us a model answer or solutions to the exercises so that we can work backward and maybe figure it out.
I have clicked and watched through a handful of your videoes and I must say you presented the information very well, in a way that new learners can understand. I was so thankful and appreciative of your work that I was looking for a donations tab on your website. Then I stumbled upon your "Elevate Excel Training Program" which is premium. If you end up replying to this, may I ask what is the benefit of signing up? Are there lessons in there which are not available on RUclips?? I would love to sign up however as I am currently unemployed I am being more prudent with my resources.
Regardless. Thank you so much for your classes again.
Hello Renzokuken, thank you for your interest in our Elevate course. 😀 The lessons we have in our Elevate course are not available here on RUclips, they are only exclusive to all active members. The step-by-step Elevate Excel tutorials will help you advance your Excel competency, so you can build upon your existing skills. Training includes video lessons (screencast videos), handouts, cheat sheets, and other resources. More information here www.excelcampus.com/join-elevate/
You have explained the subject in a very clear and simple way. Good job!
Thanks for explaining Pivot table with such great elegance. Really loved your presentation
Thanks Debabrata!
No doubt being a great teacher implies being an artist too, you are both a great teacher and an artist showing us how to use excel.
Would you tell me what excel version does he use please ? The version I’m using is so different
Thanks so much for this simplified explanation. One of my goals during the 2020 stay home order is to enhance my limited knowledge of Excel. This really helps!
This is the best, simplest "intro. to pivot tables" video I've seen. Will definitely use with some of our new employees. Thanks!
Thanks Arturo!
Having the ability to create dashboards in excel will certainly bring you a great professional prominence within the company you work for. A well-designed dashboard is capable of impressing from the janitor to the CEO.
Hi Jon, you are made adding tabs very easy for me. I have downloaded your free e-workbook. I am taking data analytic classes and when I reference adding tabs its much easier for me to do it now. You are a great instructor. I will now look at your video for Pivot tables and reference back to your free e-workbook. Please keep adding videos on excel. I will be very good at this in no time.
These tutorials give me in-depth learning about how excel can create a lot of things we use. Thank you for sharing with us and hope for more lessons and tips that you can teach.
support me sister
i can't believe how much i have learned in such a short time by watching your videos. Thank you so much.
Who all are watching this in 2024
Correct me if I'm wrong: Although there are many new functions in micro 365, the methods of building basic Pivot Tables is pretty much the same in 2024 after a big change brought by Office 2010. Isn't that true?
Me
Me 😂
Me 🙏
Am watching it on 04/09/2024
I'm watching this in 2019 and it's been very helpful. I'm going to use it to analyze data for my final year project. Thank you so much.
same here i'm in my second year I just don't understand my lecturer
Thank you so much. I am looking for new jobs and, after utterly failing an Excel test, got a good lesson to learn more skills. Coming from someone who's struggled in school, thank you.
I really enjoy watching your videos. I've checked a few out and yours are by far more superior to others I've watched. Others can have a patronising instructor but you come across friendly and professional. The pace is good and I can keep up. I had to do some learning prior to an interview on things I've never done before which helped me greatly. Got the job now to perfect my skills ready to start!!!
you are the benchmark for the best practices in Excel trainings
Glad to hear that, Shosh! 😀
@@ExcelCampusmy excel isn’t showing where to add the label data
Excel is indeed a powerful tool and knowing how to use it is a great differentiator and can bring you a huge professional prominence. Knowing different functions, graphics and knowing how to apply them to your problems, will certainly bring you an absurd differential.
Great first Pivot Table video. Very clear instructions on your tasks. I wanted to get into the functions, data changes, and filters right away and didn't think I needed the chart stuff so early but I'm glad to see that Video 2 will cover that stuff. Thank you!
I have always been intimidated by PVs; avoided them at all costs and did the calculations the LONG WAY (obviously creating more work for myself). Your video clearly explains the "why" and "how" more effectively than the Excel course I took in college! The textbook was utterly useless and only covered three lessons. I have subscribed - I'm a sponge for knowledge!
I bought one excel course on Udemy recently. Now I’m regretting it. Good job 👏🏻
Thanks to this video, my new job thinks I am a total genius for knowing how to do pivot tables!
That's awesome Paola (aka pivot table genius)! :-) Pivot tables really are Excel magic for anyone that has not seen them before.
Paola Lopez 09uu
How to set Auto Reply in Outlook
ruclips.net/video/3xjxWH2_EWU/видео.html
Me too.
yeah this is so Look awesome in your Job HEHEHE ,i Like to appLy and hands on for this exam ^_^
a Lot of magic i Learn ,Thank you sir Jon
Thank you for the clear and understandable explanation. Just right, not boring and slow or too fast and assuming!
Thanks Susan! :-)
This is the one of the best Excel Tutorial (Pivot Table) at RUclips, lecture is to the point and appropriate wording & example was used. Moreover, i would like to request to discuss Measures, Calculated Column & DAX Formula, please. Thanks a lot.
Thank you so much for producing these videos. I used to be incredibly intimidated by pivot tables, but your tutorials explain them in a very easy-to-understand manner! This has been unbelievably helpful!!!
earlier i watched your video on VLOOKUP and i knew that this is gonna be the channel im following:) Thank you for your videos! so clear and concise!:)
Awesome! Thank you! :)
Thank you so much for this video, I started a new position and they were talking about pivot table, I thought it was the hardest thing ever...
This is the best of the best Pivot Tables tutorial, I have seen. Good Job Jon.
+Ghazy Sabh Thanks Ghazy!
Hi Jon, can you tell me what software I would require to create those toon characters? I need to do a project for college and this would be great for my presentation.
awesome.
awesome.
How to set Auto Reply in Outlook
ruclips.net/video/3xjxWH2_EWU/видео.html
You made excel seem 90% less intimidating. This is coming from someone with zero knowledge of excel.. Thanks! 😄
ruclips.net/video/HOa5r2IavRY/видео.html
EXCEL SLICER FOR PIVOTS1
Hi Jon. I've taken many tutorials on Excel and Pivot tables, but your tutorial and exercises along with the worksheets are the best . Though I had a little trouble downloading the worksheet for this video, I was able to grab another data set from another one of your tutorials and practice along. I feel so much more comfortable in doing V lookups and pivot tables. Just what I needed as a refresher course. This was great!
Thanks so much for your kind words and nice feedback. I really appreciate it.
I'm sorry to hear you had trouble with the download. We'll take a look at what might be causing that.
Thanks again and have a nice weekend! 🙂
Hi Jon, simply outstanding presentation of the tutorials. I have seen multiple tutorials of yours, at the end of it, for learners like me, it provides a sense of satisfaction and confidence. Thank you!
Learning Python along with this will make one a Data Scientist. Smart managers who know excel and Python will have competitive advantage.
Excellent tutorial! Deserves to be top of Google's search. Easy to understand, good highlight graphics, nice speech pace.
Thank you! I just went to a job interview and the hiring manager is looking for someone with pivot table, charting and vlookup experience. Your tutorial was very helpful. I have subscribed to you channel, gave you thumbs up on video and hit the notification bell. Again thank you sharing your knowledge I will be watching your videos.
Great presentation Jon. Your voice modulation and expertise is second to none. Many thanks for your service.
Hi there, thank you so much for this wonderful video, I've studies pivot tables in my academic level. But, now I'm graduated and applying for jobs. That was a much needed videos to polish and review my excel skills. Thanks a lot :)
Hi Jon, thank you for your really helpfull videos! I start a new job next week and I feel like this series truely helped me to prepare for it. Everything was super clear and entertaining to watch! I hope you have a wonderful day and wish you all the best!
Uncomplicated and easy to follow, by far the best tutorial out there. Thank you very much for all your help
The best tutorial on the internet, easy to follow and easy to understand
Hope to pass this scary test tomorrow that I have
This was one of the best tutorials I could find on the introduction to Pivot Tables. Thank you very much!
Thank you, Jon, for your professional and easy-to-follow instruction. Really appreciate your making the practice data available and Mynda's link as well. So glad I found you!
Patricia Chilton agreed
I am from Ecuador, but I've received class in english language, I can sure that your video, and language are very clear for anyone.
hello villamar
Awesome teaching and quite simple, explaining in layman's terms. I have never used pivot tables before but think that I will be able to do so now confidently. Thank you.
Excellent video. One of the best lessons on Pivot Table I've seen. I was hoping that there was a Pivot Pal for the Mac, but I don't think so.
Jon, you are a very good instructor. You make everything seems so easy.
Mr.Jon I learned Pivot table through your channel.Its really amazing great work,continue it for career growth of people through out the universe.
Great to hear that, mgrnmgrn! 😀
This was great, haven’t used pivot tables in a very long time. Looking to incorporate this back into my daily life. Thank you
Amazing and easy-to-follow tutorial. Loved you provided the Excel template to follow along; helped a lot.
Jon's lessons are pretty awesome, I have pretty short attention span but I'm hooked on the tutorials.
Fantastic educational video! Clear, concise information that flowed smoothly. You integrated supporting tidbits of how's and why's very effectively. As an out-of-practice Industrial Engineering student, I especially appreciate the color coded boxing. I'm actually excited to see what else I learn from you guys.
Much appreciated! 😀
Thank you for this amazing tutorial ! You made it look so simple and is funny how I had a question in my mind and you almost instantly answered it every time! Thanks and keep the great work!
tutorial from indonesia
So I was turned down from a job because I was not familiar with pivot tables 😒, however I am very proficient in excel and turns out I’m more than capable of doing this! Just wasn’t aware of the proper name for all this!!! Thank you for showing us!!!
Very nicely explained. Just to the point and easy to follow. I wish there was a file to download and work with just to practice the features of pivot tables. Got it!. :-). Thank you for sharing your knowledge.
create one or google sample excel data, select copy and paste
Thanks. Actually, if you go to ExelCampus' website provided in the links below the video, Jon allows you to download all 3 sample files. He is a good teacher too.
Hi John. Thank you so much for your video. It was informational and very easy to follow.
Took me 2 days on a project to do this. Didn't realize it was this fast. Mind blown.
Awesome video! Very well presented. So easy to follow along. I was clueless on how to create a simple pivot table and this tremendously helped me . Thanks sooooooo much!
This was excellent! Very easy to follow along. I'm looking for additional videos!
I usually get the end product of excel reports and this video opened my eyes to a whole new world. Thank you
Jon this was awesome, very helpful. I recently accepted a new role and want to work with data better and I believe that your videos will give me the assistance I need! Thank you!
Great tutorial! I really appreciate you supplying the excel file to work along with you.
Thank you so much! I am a small business owner in retail, and thanks to the video I now have created a spreadsheet from my POS export that shows everything I need for a better buy plan!!! Amazing!
Hey Jon. Thank you so much for sharing. You are an excellent teacher, you explain very well. Your course is easy to follow and pretty useful to learn how to visualise in a clear manner lots of business data. I am starting a new role soon and the pivot tables are going to be super necessary! Thank you again for your effort and for being so helpful with your videos.
thanks sir, this was a very clear and positive effected lecture about pivot table
This was a tremendous tutorial. I choose to decline a job offer because my lack of knowledge however, I have studied and practised. I have made excellent process and will continue to practice and reapply for another role with confidence. Thank you!
You can do it! 😀
Thank you for the concise, informative video! The use of pivot tables will greatly enhance my productivity and impress my boss (I hope).
Hi Jon, I found your 3 part videos on Pivot tables very informative and helpful. I have a question on the detail tab tho. What are the drop-down arrows next to the titles of each column? And how to create them while entering data? Is it one of the features of Excel?
Hi Hong, Great question! Those are the Data Filters. You can turn them on/off from the Data menu in the ribbon. Here is an article I have on keyboard shortcuts for the Filter Drop-down Menus. www.excelcampus.com/keyboard-shortcuts/filter-dropdown-menu-shortcuts/
Thanks Jon!
Thanks for asking this! Was wondering how to create those data filters on my excel sheet.
Glad it was helpful for you.
I think her name is Luu.
thankyou Mr.Jon, for such good work .I am preparing for my interview next week and your videos are are of great quality and content. with gratitude.
A good Instructor could make his student understand better and are one of those.
Thank you for creating these videos for Pivot Tables! Very very helpful.
This series is significantly more professional than other Excel videos
This was actually pretty easy to understand. Thank you! 💗