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 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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!
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 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
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
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.
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 🙇
You are very welcome! Glad you enjoyed it. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
✅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 👉ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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.
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 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..
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 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.
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Cheers to 2024. I'm glad you enjoyed our training. Thanks for watching 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Glad you enjoyed it. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
Thank you so much! We're glad you enjoyed it! 🔥 Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
You are very welcome! Thanks for watching 🙂 🔥Need training for Excel 2021/365? Check out our free 10-hour training course on RUclips ➡️ ruclips.net/video/fODnNDNMXiI/видео.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support! #SimonSezIT #Excel
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.
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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!
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
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?
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.
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.
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 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
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.
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
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
Hey, thanks a bunch for the shoutout! We're glad you enjoyed the video. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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!!
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
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 😃
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! :-)
Thank you Deb - of all the Excel RUclips 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.
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 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
This is the best detailed tutorial I've seen on RUclips, 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: ruclips.net/video/_Jtzgjts_r8/видео.html
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 :-)
No words to describe the value added to my knowledge from this amazing video, many thanks
Glad it was helpful!
top quality! thank you Deborah, you are a fantastic presenter/teacher
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!
You are such a big help to so many people in the world. Thank you.
This is by far one of the best educational videos I have viewed. Thank you so much!!!
Wow, thank you!
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! 🙂
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
'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 👉
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
✅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 👉ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
& here 👉ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
Excellent, ultra-detailed, well-organized tutorial.
Glad you found the tutorial helpful! Knowing that the details made a difference for you means a lot. 🤩
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.
This is a great tuturial. Right from first fixing the table before making Pivots. Great explanation.
Glad you think so!
Finally finished the tutorial. It's well detailed and taught in an easy-to-understand language. Great job!
Very well articulated Deb, you always take your time to give the best.
Thanks Rodney, much appreciated ☺️
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 😎😎😎
Awesome tutorial- I finally learned pivot tables!
Glad you liked it! 😊 Check out our new 10 hour Excel course -> ruclips.net/video/fODnNDNMXiI/видео.html
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..
Great teaching, now a pro. Thank you Debora!!!
Glad it was helpful! Thanks for watching :-)
OMG!!! I am in love with your voice Ash!!!
This is the best. Thank you for being so thorough.
You are so welcome! Additional Pivot Table training is here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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 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!
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 -> ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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.
The contents and presentation is excellent, thank you so much!
You're very welcome, Madlen! Here's some additional training if you need it -> ruclips.net/video/oN82Umc9MCQ/видео.html
Many thanks for this training. I have indeed learnt new techniques of formatting large data.
Great to hear!
This is brilliant, you have covered every detail and explained in an easy to catch up, thank you so much 🙂
Glad you enjoyed it!
Thank You (specially for uploading these files for us) 🙏🙏🙏
Our pleasure!
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
Wonderful ethical detailing.
Thanks Kousik 😀
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
This was great! I really like her teaching style~ and if I can understand this, anyone can
Thank you!
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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!😉
This is so helpful. Just amazing.
You are very welcome! Glad it was helpful. 🙂
Love this excel tutorial
Wow, thanks! Glad it was helpful. 🤩
TQ SIMON,GREAT TUTOR.
AMAZING TUTORIAL!
Glad you enjoyed it. Thanks for watching! 🙂
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
Great tips and explanations!
Glad it was helpful!
You are the best. Thank you so much.
You are very welcome! 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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Thank you..this video tutorial is very helpful. Subscribed already.
Glad you are enjoying the training. 😀
World class!
Wow, thanks! Glad it was helpful. 🤩
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 RUclips ➡️ ruclips.net/video/fODnNDNMXiI/видео.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
#SimonSezIT #Excel
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.
Excellent!
Glad you enjoyed it. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
appreciate it!@@SimonSezIT
The Best 👍
Thanks 😊 There is additional Excel training here if you need it -> ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
Thank You
You are very welcome! Thanks for watching 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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!
Thanks❤
Thank you very much..
No worries!
Can i do =PROPER(CLEAN(TRIM(B4)))? Thank you!❤
Why you didn't use power query for data cleaning and processing?
Thank you.
You're welcome!
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/
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
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?
@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.
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.
how to download the exercise file ?
Just follow the instructions here www.simonsezit.com/pivot-table-beginners-instructor-files/
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
I cant find file
Hi, link to dataset does not work!
doesn't work for me either.
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.
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.
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
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
Your are an Angel .... pl. drink warm Water ...
👏👏
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 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
#SimonSezIT #Excel