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! 🙌
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!
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!
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.
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!
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
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
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.
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.
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.
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 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
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! 👍
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!
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!
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?
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.
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
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!
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!
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.
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.
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.
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.
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.
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.
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 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 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!!!
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 :)
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!
Thank you for watching the video! Here are the links I mentioned in the video. DOWNLOAD the Pivot Table Checklist & Excel File: www.excelcampus.com/pivot-table-checklist-yt Learn more about PivotPal: www.excelcampus.com/pivotpal Free webinar on The 5 Secrets to Understanding Pivot Tables: www.excelcampus.com/pivot-webinar-yt Watch video #2: ruclips.net/video/g530cnFfk8Y/видео.html Please leave a comment below with any questions, and hit the like button above if you enjoyed the video. I really appreciate your support! :-)
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/
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, 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 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!
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 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!
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.
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 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!
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.
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.
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.
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.
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!
Omgg!! I'm so happy found your video. I'm gonna be working and I was informed that the company use an old version so I wanna know how to use pivot table using the old version of excel. Thank you for attaching the file u use as well. Best regards!!
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!
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!
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.
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
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! 😀
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
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.
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.
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!
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 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.
I have a business and always working with Excel. Your video has been very instrumental. Thank you
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
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
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! 😀
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.
Although you dropped this video a few years ago... it doesn't go out of fashion!! Thank you!
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. 😀
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! 😀
Hamadu.Osman.Eibrhm.
12:35
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
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! :-)
Dude, you saved my life today. My report is due in an hour and now it looks amazing! Thank you...
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! 👍
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 🤣🤣🤣
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!
i can't believe how much i have learned in such a short time by watching your videos. Thank you so much.
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
I have seen several tutorials on the same subject, but this is by far the most explicit and easiest to understand. Congratulations Jon
Indeed
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
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!
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
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.
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 can’t imagine how grateful I am for coming to your campus to learn this Pivotal Table... Please accept my warmest appreciations
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!
I am wowed....with your explanations on each steps...very short and detailed...video is seriously on point...good job
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
I bought one excel course on Udemy recently. Now I’m regretting it. Good job 👏🏻
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!
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.
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
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!
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.
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
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
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...
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.
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
This series is significantly more professional than other Excel videos
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
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.
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
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 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
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! :)
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!!!
Jon this is the best pivot tables explanation one could ever ask for Thanks
Thanks, @alfredkaburuk6018! 😀
Learning Python along with this will make one a Data Scientist. Smart managers who know excel and Python will have competitive advantage.
This was great, haven’t used pivot tables in a very long time. Looking to incorporate this back into my daily life. Thank you
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 :)
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!
Thank you for watching the video! Here are the links I mentioned in the video.
DOWNLOAD the Pivot Table Checklist & Excel File: www.excelcampus.com/pivot-table-checklist-yt
Learn more about PivotPal: www.excelcampus.com/pivotpal
Free webinar on The 5 Secrets to Understanding Pivot Tables: www.excelcampus.com/pivot-webinar-yt
Watch video #2: ruclips.net/video/g530cnFfk8Y/видео.html
Please leave a comment below with any questions, and hit the like button above if you enjoyed the video. I really appreciate your support! :-)
I can't follow your instruction because it is not selecting the cells I need :(
I got it :)
thank you sir I got the file
thank you :)
I am also having trouble finding it!
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/
Uncomplicated and easy to follow, by far the best tutorial out there. Thank you very much for all your help
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!!!
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 one of the best tutorials I could find on the introduction to Pivot Tables. Thank you very much!
Hi John. Thank you so much for your video. It was informational and very easy to follow.
Jon's lessons are pretty awesome, I have pretty short attention span but I'm hooked on the tutorials.
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!
A good Instructor could make his student understand better and are one of those.
I am knowledgeable about Excel, but need to know more for my job. This example was terrific!
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
Great presentation Jon. Your voice modulation and expertise is second to none. Many thanks for your service.
Excellent tutorial! Deserves to be top of Google's search. Easy to understand, good highlight graphics, nice speech pace.
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
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!
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
Amazing and easy-to-follow tutorial. Loved you provided the Excel template to follow along; helped a lot.
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.
Found it very easy to learn and understand compared to other video tutorials, highly recommended.
thanks sir, this was a very clear and positive effected lecture about pivot table
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 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!
Tooooooooo Goooooooood. Have no words to express my happiness and in the end i would say God bless u always
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.
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.
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.
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.
I appreciated the clarity of the explanation. I am quite new to Excel and everything was clearly explained.
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!
Great tutorial! I really appreciate you supplying the excel file to work along with you.
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.
This was excellent! Very easy to follow along. I'm looking for additional videos!
this video is very informative, teaching us every single detail that I haven't seen from other video tutorial about excel. this is cool! thank you
Omgg!! I'm so happy found your video. I'm gonna be working and I was informed that the company use an old version so I wanna know how to use pivot table using the old version of excel. Thank you for attaching the file u use as well. Best regards!!
Thank you for the concise, informative video! The use of pivot tables will greatly enhance my productivity and impress my boss (I hope).
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!
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! 😀
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.