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 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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!
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.
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 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
Wow, thanks! Glad it was helpful. 🤩 We have the latest tutorial for PivotTable. Hope this helps too: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-_Jtzgjts_r8.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 🙇
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..
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.
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 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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 😎😎😎
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!!
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 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! Wishing you the best of luck with the interviews 😊 If you need additional prep for the interview, we have additional free Excel training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
You are very welcome! Glad you enjoyed it. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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.
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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.
Cheers to 2024. I'm glad you enjoyed our training. Thanks for watching 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Glad you enjoyed it. Thanks for watching! 🙂 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
Thank you so much for your kind words! I appreciate your support. 🙂 🔥Check out our FREE 400+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Hey, thanks a bunch for the shoutout! We're glad you enjoyed the video. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support! #SimonSezIT #Excel
You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
You are very welcome! Thanks for watching 🙂 🔥Need training for Excel 2021/365? Check out our free 10-hour training course on RU-vid ➡️ ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-fODnNDNMXiI.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support! #SimonSezIT #Excel
Thank you so much! We're glad you enjoyed it! 🔥 Check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ We appreciate your support!
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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
✅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 👉ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
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
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?
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?
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.
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.
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 👉 ru-vid.com/group/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ru-vid.com/group/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ru-vid.com/group/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RU-vid Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ru-vid.com ♥️ 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.