Madam, i have been following you for a long time, maybe you don't know how much you are lifting some of us in Africa out of poverty by enriching us with this kind of knowledge to improve human development. This is speeding up my career as a maintenance planner. Thank you so much
Hey there! I'm so glad to hear that my videos are making a difference in your life and career. Thank you for your support and keep up the great work as a maintenance planner! 🤩 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
What a great tutorial!!! I do a lot of the stuff in the vid but having a thorough walk through and explanation is so useful!! I learned so much more than expected. Thank you!!
I wish I could give a million likes. I am going back to work after being off for several years and want to refresh my Excel skills. This is fabulous. Thanks!
Thanks alot Simon,am new to data but because of your videos when i speak or work on a data they think am a professional already thanks alot simon for helping me
You're welcome! Glad it was helpful. 🤩 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
AGREE, absolutely would recommend this course! I love the way it begins to introduce us to the world of pivot tables, starting with CLEANING! Thank you, very professional!!!
Thanks for your positive feedback! Glad it was helpful. 🤩 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
I've watched the 2 short vids on Pivot Tables, twice. Now I'm watching this one for the second time but this time I'm following along, I'm literally flying 😎😎😎
Wonderful! Wishing you the best of luck with the interviews 😊 If you need additional prep for the interview, we have additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
You are very welcome! Glad you enjoyed it. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
The woman explained the excel in a really amazing way. Very articulate and easy to understand! I'am able to understand what she said quickly. really talented teacher. Kudos to all of the team 🙇
I can't explain how grateful I am to the Simon Sez team especially Deb Ashby. Detailed explanation and very helpful course files to follow along. My interest for learning has more than increase. Thank you for the training and may God bless you all.
Fantastic tutorial Deb. Don't know how to express my delight. This is definite more than I was expecting. I was not expecting such clarity. Many thanks for making this easy to learn.
Wow a fantastic tutorial. Ms. Ashby your are a expert in Excel. I have learnt so much, blown away at every lesson. This will help me make my reports quickly. Thank You.
This training is absolutely fantastic! Thank you so much. I found it extremely useful that you also taught how to clean up the data. This is an important step and knowing the techniques you taught will speed up my workflow considerably. I was doing many of these things manually and learning a better way was very helpful to me. Thank you again, much appreciated!
iT IS CRAZY AND VERY REALISTIC IN STORING AND DELETING DATA AS IT TAKES PROFESSIONAL SKILLS TO DO IT. IT SAVE SPACE AND TIME WASTE FOR FUTURE SALES OF NOTHING CAN BE MORE COMPREHENSIVE ON STAGE THINKING..
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Words cannot describe what a fantastic tutor you are!! The pace of the presentation, the tone and colour of your voice, the subjects you choose to present... Pivot tables are absolutely essential to what I have to deal with right now but I had developed a paralysing fear for them. With your presentation, I now know I can deal with this and feel so, so confident. Thank you, with all my heart thank you.
YOU are absolutely amazing! The presented material is so well explained, easy to follow and informative. Thank you for putting so much effort into this presentation.
Thank you so much for your kind words! I appreciate your support. 🙂 🔥Check out our FREE 400+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Glad you enjoyed it. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Cheers to 2024. I'm glad you enjoyed our training. Thanks for watching 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you so much! We're glad you enjoyed it! 🔥 Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
✅Download the Free Instructor Files to follow along the course here 👉www.simonsezit.com/pivot-table-beginners-instructor-files/ If the link doesn't work, please try another web browser or try clearing your browser cache. 🔥Check out our FREE 300+ hour training course playlist here 👉ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
You are very welcome! Thanks for watching 🙂 🔥Need training for Excel 2021/365? Check out our free 10-hour training course on UA-cam ➡️ ua-cam.com/video/fODnNDNMXiI/v-deo.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support! #SimonSezIT #Excel
You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Didn't realise that formatting as an Excel table results in them automatically expanding as new data is added to the end... the amount of time I've wasted... well, at least now I know, thank you!
Excellent tutorial. I have a complaint though, I couldn't seem to find the file you use for the clearing formatting, duplicates removal and empty rows removal in the files you instructed us to download from the link in the description.
Excel can automatically group dates by year, quarter, and months when you create a Pivot Table even if you don't have these fields/columns in your source table. You can simply remove them by unchecking in the Pivot Table field list.
Actually, I noticed one more short cut. At 47:42, after you entered the =proper(clean(trim(b4))) formula hit control+enter, then double clicked the small box in the corner of the cell to paste everything down, all the cells in the helper row are now highlighted. From there I was then able to select 'contorl+C and it copied all the data in the C column. I then moved my cursor to cell B4, and then pasted special. I didn't have to put my cursor in cell c4, hit control+shift+down arrow to highlight everything, then Control+C, then Control+up arrow to get back to the top. Does that make sense?
Brilliant tutorials as always but I have found a small error so the pivot tables analisys will be incorrect.....I noticed earlier in the tutorial but then realised in the spell checking section...After you got the word "Cancelled" correctly spelt on Row 11 then that row became a duplicate of Row 12....i.e. Rows 11 and 12 are exactly the same which means a Duplicate Records match needs to be run again
How we dynamically can extract the number of rows for: this month and last month, this quarter and last quarter, this year and last year from a table? Lets say there is column for thin 1, thing 2, thing 3 etc and each occur on daily basis and we want to know the number of those occurrences for the current month, quarter and year as well as the last ones? Could someone please help?
Hello! I'm having trouble finding the error for rows 9 and 14 (Sub-Saharan Africa). I followed each step in the tutorial (clean, trim etc.) and double-checked it as well. However those rows don't act OK. When I move on to change the formatting in column G to Date, G9 and G14 won't change to date but stay the same (41100, 42577). Not only that, those two rows have different row width as well and overall don't look OK.
It seems like the problem might be related to the browser or its cache. I suggest trying a different web browser or clearing the cache of your current browser.
@@SimonSezIT hello, i have used google chrome, mozilla firefox. microsoft edge and have the same problem with each (even after deleting the respective caches). it is possible for me to enter my email address and i receive the message that an email should arrive in my inbox in about 10 mins - and i am still waiting (before you suggest it: i thave checked my junk-box. is there any other way that i could receive the files? regards colin huntley
@@SimonSezIT i have used 3 browsers: firefox, chrome and edge. caches were deleted beforehand. it was possible to enter my email address and i even got confirmation that an email would land in my inbox in about 10 mins. and i am still waiting! could i receive the files some other way? regards, colin
Hi there. Please click the link below to download the exercise files: www.simonsezit.com/pivot-table-beginners-instructor-files/ 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
47:30 - None of the times you've used the PROPER() function up to this part in the lesson did the 'of the' in "Democratic Republic of the Congo" correctly display the prepositions in the title! How do you fix that?! 1:07:48 - Or even quicker with less mouse movement is to use the 'replace' keyboard shortcut: ctl-h
The first hour+ is critical to avoiding problems and pitfalls with problematic source data... the entire tutorial is a must watch for anyone that wants to develop true expertise. The trainer recognizes this so doesn't omit it from the lesson.
Hey, thanks a bunch for the shoutout! We're glad you enjoyed the video. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support! #SimonSezIT #Excel
Madam, i have been following you for a long time, maybe you don't know how much you are lifting some of us in Africa out of poverty by enriching us with this kind of knowledge to improve human development. This is speeding up my career as a maintenance planner. Thank you so much
Hey there! I'm so glad to hear that my videos are making a difference in your life and career. Thank you for your support and keep up the great work as a maintenance planner! 🤩
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thank you Deb - of all the Excel UA-cam videos available on Excel Pivot Tables, yours' are the most informative and complete.
Glad you like them!
Which video I should watch after this for pivot table please suggest.
OMG! This tutorial is well worth the 2 hours it takes to complete! I'm so happy I found this. Thank you Simon Sez and Instructor Deb A!
Glad you are enjoying the training. 😀
i AM ALREADY BORED AFTER 15 MIN I DONT KNOW HOW I CAN SEE IT TO THE END. IT IS SCIENCE TO HAVE PATCIENCE TO GET NOW WHERE YOU CANT NOT STAND
What a great tutorial!!! I do a lot of the stuff in the vid but having a thorough walk through and explanation is so useful!! I learned so much more than expected. Thank you!!
This is by far the BEST and VERY BEGINNER FRIENDLY video tutorial about Pivot Table I've ever watched. I cannot thank you enough for this!!!!
Wow, thank you! :-)
I wish I could give a million likes. I am going back to work after being off for several years and want to refresh my Excel skills. This is fabulous. Thanks!
Glad you found the content helpful as you refresh your Excel skills. You've got this! Thanks for watching 😃
top quality! thank you Deborah, you are a fantastic presenter/teacher
Words cannot describe how great a Tutor you are. Very detailed and clear voice modulation. God Bless !
Which video I should watch after this for pivot table please suggest.
Thanks alot Simon,am new to data but because of your videos when i speak or work on a data they think am a professional already thanks alot simon for helping me
You're welcome! Glad it was helpful. 🤩
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
AGREE, absolutely would recommend this course! I love the way it begins to introduce us to the world of pivot tables, starting with CLEANING! Thank you, very professional!!!
Thanks for your positive feedback! Glad it was helpful. 🤩
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
No words to describe the value added to my knowledge from this amazing video, many thanks
Glad it was helpful!
You are such a big help to so many people in the world. Thank you.
I've watched the 2 short vids on Pivot Tables, twice. Now I'm watching this one for the second time but this time I'm following along, I'm literally flying 😎😎😎
This is the best detailed tutorial I've seen on UA-cam, thank you for putting this out, I really gained value
God bless you
Wow, thanks! Glad it was helpful. 🤩 We have the latest tutorial for PivotTable. Hope this helps too: ua-cam.com/video/_Jtzgjts_r8/v-deo.html
Very well articulated Deb, you always take your time to give the best.
Thanks Rodney, much appreciated ☺️
Awesome tutorial- I finally learned pivot tables!
Glad you liked it! 😊 Check out our new 10 hour Excel course -> ua-cam.com/video/fODnNDNMXiI/v-deo.html
'I swear you are an amazing teacher thank you so much!! I have three interviews this week I needed this.
Wonderful! Wishing you the best of luck with the interviews 😊 If you need additional prep for the interview, we have additional free Excel training here 👉
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
This is one of the best courses and has so much value. Brilliantly done I learned so much in 2 hrs
Glad you liked it! 🙂
This is by far one of the best educational videos I have viewed. Thank you so much!!!
Wow, thank you!
Great teaching, now a pro. Thank you Debora!!!
Glad it was helpful! Thanks for watching :-)
This is the best. Thank you for being so thorough.
You are so welcome! Additional Pivot Table training is here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
At last people who know how to deliver superb training... love it Thank you
You are very welcome! Glad you enjoyed it. 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
OMG!!! I am in love with your voice Ash!!!
Finally finished the tutorial. It's well detailed and taught in an easy-to-understand language. Great job!
The woman explained the excel in a really amazing way. Very articulate and easy to understand! I'am able to understand what she said quickly. really talented teacher. Kudos to all of the team 🙇
This is so great to hear! Thank you!
I can't explain how grateful I am to the Simon Sez team especially Deb Ashby. Detailed explanation and very helpful course files to follow along. My interest for learning has more than increase. Thank you for the training and may God bless you all.
Our pleasure! Thank you for taking the time to leave a nice comment :-)
Excellent, ultra-detailed, well-organized tutorial.
Glad you found the tutorial helpful! Knowing that the details made a difference for you means a lot. 🤩
always great o be here and be part of the program.. They're super and basic
Thanks for the nice comments 😊 There's additional Excel training here if you need it -> ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
This is a great tuturial. Right from first fixing the table before making Pivots. Great explanation.
Glad you think so!
Fantastic tutorial Deb. Don't know how to express my delight. This is definite more than I was expecting. I was not expecting such clarity. Many thanks for making this easy to learn.
You are so welcome!
The contents and presentation is excellent, thank you so much!
You're very welcome, Madlen! Here's some additional training if you need it -> ua-cam.com/video/oN82Umc9MCQ/v-deo.html
Wow a fantastic tutorial. Ms. Ashby your are a expert in Excel. I have learnt so much, blown away at every lesson. This will help me make my reports quickly. Thank You.
Fantastic tutorial. I've learned a lot about pivot tables now I can apply it to my spreadsheets. Thank you for the tutorial.
You're very welcome, Maryrose. Thanks for watching!
Which video I should watch after this for pivot table please suggest.
@@SimonSezIT 0⅞op0009100q
This training is absolutely fantastic! Thank you so much. I found it extremely useful that you also taught how to clean up the data. This is an important step and knowing the techniques you taught will speed up my workflow considerably. I was doing many of these things manually and learning a better way was very helpful to me. Thank you again, much appreciated!
iT IS CRAZY AND VERY REALISTIC IN STORING AND DELETING DATA AS IT TAKES PROFESSIONAL SKILLS TO DO IT. IT SAVE SPACE AND TIME WASTE FOR FUTURE SALES OF NOTHING CAN BE MORE COMPREHENSIVE ON STAGE THINKING..
This is brilliant, you have covered every detail and explained in an easy to catch up, thank you so much 🙂
Glad you enjoyed it!
This is a very informative video I got to learn everything from scratch. 100% recommended for beginners like myself.
Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Many thanks for this training. I have indeed learnt new techniques of formatting large data.
Great to hear!
Words cannot describe what a fantastic tutor you are!! The pace of the presentation, the tone and colour of your voice, the subjects you choose to present... Pivot tables are absolutely essential to what I have to deal with right now but I had developed a paralysing fear for them. With your presentation, I now know I can deal with this and feel so, so confident. Thank you, with all my heart thank you.
Wow, I am out of words, but sure glad that it was helpful.
Which video I should watch after this for pivot table please suggest.
YOU are absolutely amazing! The presented material is so well explained, easy to follow and informative. Thank you for putting so much effort into this presentation.
Wonderful ethical detailing.
Thanks Kousik 😀
Thank You (specially for uploading these files for us) 🙏🙏🙏
Our pleasure!
TQ SIMON,GREAT TUTOR.
Love this excel tutorial
Wow, thanks! Glad it was helpful. 🤩
great video
Big up Deborah and your team
Thank you so much for your kind words! I appreciate your support. 🙂
🔥Check out our FREE 400+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
This was great! I really like her teaching style~ and if I can understand this, anyone can
Thank you!
AMAZING TUTORIAL!
Glad you enjoyed it. Thanks for watching! 🙂
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
THANK YOU! For sharing with others valuable information! Bod Bless You!
You are so welcome Ahmad Pour Javadi 😀
Thank you for this very informative tutorial!
You’re welcome Louis!😉
Great tips and explanations!
Glad it was helpful!
You are the best. Thank you so much.
You are very welcome! Glad it was helpful. 🙂
This is so helpful. Just amazing.
You are very welcome! Glad it was helpful. 🙂
Thank You Deb.
Happy New Year.
Cheers!
Cheers to 2024. I'm glad you enjoyed our training. Thanks for watching 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
World class!
Wow, thanks! Glad it was helpful. 🤩
Great Video👏😊
Thank you so much! We're glad you enjoyed it! 🔥
Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
✅Download the Free Instructor Files to follow along the course here 👉www.simonsezit.com/pivot-table-beginners-instructor-files/
If the link doesn't work, please try another web browser or try clearing your browser cache.
🔥Check out our FREE 300+ hour training course playlist here 👉ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
& here 👉ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thank you..this video tutorial is very helpful. Subscribed already.
Glad you are enjoying the training. 😀
Excellent!
Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
appreciate it!@@SimonSezIT
This is amazing...thank youu
You are very welcome! Thanks for watching 🙂
🔥Need training for Excel 2021/365? Check out our free 10-hour training course on UA-cam ➡️ ua-cam.com/video/fODnNDNMXiI/v-deo.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
#SimonSezIT #Excel
Thank You
You are very welcome! Thanks for watching 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
The Best 👍
Thanks 😊 There is additional Excel training here if you need it -> ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
Thanks❤
Perfect
Slad you found it perfect! 😃
Thank you very much..
No worries!
Thank you.
You're welcome!
Didn't realise that formatting as an Excel table results in them automatically expanding as new data is added to the end... the amount of time I've wasted... well, at least now I know, thank you!
Glad it helped!
Excellent tutorial. I have a complaint though, I couldn't seem to find the file you use for the clearing formatting, duplicates removal and empty rows removal in the files you instructed us to download from the link in the description.
Its pretty good. Give the file link for practice.
Can i do =PROPER(CLEAN(TRIM(B4)))? Thank you!❤
Why you didn't use power query for data cleaning and processing?
Love the course, but the downloaded files received seem to be already clean so you cannot follow along with the cleaning process, is that correct?
This training is part of the complete set of courses we offer at Simon Sez IT www.simonsezit.com/courses/
@1:17:45, there is duplicate row at row 12
It's hard to see at first, but the word "canceled" is misspelled in row 11 and correctly spelled in row 12. Not dupes.
@2:02:14 Where did the Year and Quarter fields come from in the pivot table? They are not on the original excel sheet.
Excel can automatically group dates by year, quarter, and months when you create a Pivot Table even if you don't have these fields/columns in your source table. You can simply remove them by unchecking in the Pivot Table field list.
Where can I find next video after this?
Actually, I noticed one more short cut. At 47:42, after you entered the =proper(clean(trim(b4))) formula hit control+enter, then double clicked the small box in the corner of the cell to paste everything down, all the cells in the helper row are now highlighted. From there I was then able to select 'contorl+C and it copied all the data in the C column. I then moved my cursor to cell B4, and then pasted special. I didn't have to put my cursor in cell c4, hit control+shift+down arrow to highlight everything, then Control+C, then Control+up arrow to get back to the top. Does that make sense?
Brilliant tutorials as always but I have found a small error so the pivot tables analisys will be incorrect.....I noticed earlier in the tutorial but then realised in the spell checking section...After you got the word "Cancelled" correctly spelt on Row 11 then that row became a duplicate of Row 12....i.e. Rows 11 and 12 are exactly the same which means a Duplicate Records match needs to be run again
How we dynamically can extract the number of rows for: this month and last month, this quarter and last quarter, this year and last year from a table? Lets say there is column for thin 1, thing 2, thing 3 etc and each occur on daily basis and we want to know the number of those occurrences for the current month, quarter and year as well as the last ones? Could someone please help?
Hello! I'm having trouble finding the error for rows 9 and 14 (Sub-Saharan Africa). I followed each step in the tutorial (clean, trim etc.) and double-checked it as well. However those rows don't act OK. When I move on to change the formatting in column G to Date, G9 and G14 won't change to date but stay the same (41100, 42577). Not only that, those two rows have different row width as well and overall don't look OK.
if you click on 41100 and press enter and then backspace . it will change into date. I tried that it worked for me.
Hello everybody at Simon Sez IT, all of your tutorials are very inspirational indeed! Many thanks for sharing. I have been tr
It seems like the problem might be related to the browser or its cache. I suggest trying a different web browser or clearing the cache of your current browser.
@@SimonSezIT hello, i have used google chrome, mozilla firefox. microsoft edge and have the same problem with each (even after deleting the respective caches). it is possible for me to enter my email address and i receive the message that an email should arrive in my inbox in about 10 mins - and i am still waiting (before you suggest it: i thave checked my junk-box. is there any other way that i could receive the files? regards colin huntley
@@SimonSezIT i have used 3 browsers: firefox, chrome and edge. caches were deleted beforehand. it was possible to enter my email address and i even got confirmation that an email would land in my inbox in about 10 mins. and i am still waiting! could i receive the files some other way? regards, colin
Can't access the training files. :(
Hi there. Please click the link below to download the exercise files:
www.simonsezit.com/pivot-table-beginners-instructor-files/
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
I cant find file
how to download the exercise file ?
Just follow the instructions here www.simonsezit.com/pivot-table-beginners-instructor-files/
47:30 - None of the times you've used the PROPER() function up to this part in the lesson did the 'of the' in "Democratic Republic of the Congo" correctly display the prepositions in the title! How do you fix that?!
1:07:48 - Or even quicker with less mouse movement is to use the 'replace' keyboard shortcut: ctl-h
👏👏
Pivot table training starts at 1:16:00
You can also check out the timestamps in the description box to select each topic.
The first hour+ is critical to avoiding problems and pitfalls with problematic source data... the entire tutorial is a must watch for anyone that wants to develop true expertise. The trainer recognizes this so doesn't omit it from the lesson.
Your are an Angel .... pl. drink warm Water ...
Hi, link to dataset does not work!
doesn't work for me either.
Downloadable Excel file are not opening …
Please try clearing your cache and/or try another web browser, thanks.
@@SimonSezIT Problem solved.. Thank you very much... I am 100% Satisfied..
=SUBSTITUE(B8,"Czech Republic","CZR") doesn't work for me.
If it still doesn’t work, check your spelling. It’s SUBSTITUTE.
Of course everyone knows what is an Excel table... It only take a holistic intelligence to understand all that table.
Thank you so much
You're most welcome, Panha!
Thank you very much
Hey, thanks a bunch for the shoutout! We're glad you enjoyed the video. 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
#SimonSezIT #Excel