This is where it goes "no comment". In a sense of great generosity, high level profesionalism, tutorials designed in detail, all combined to offer us an expensive tutorial program for free. Thank you Simon! I'm sure your generosity will return back to you. You are a genuine giver. Thank you Deb! You are a natural talent in teaching and we are so lucky to have you. You are really special.
@SimonSezIT Жыл бұрын
Wow! Thank you for taking the time to write nice comment 😊 There's additional Excel training here if you need it -> kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@kurdishmotivateАй бұрын
Hello dear , did you get the exercise files? Please let me know if you have them I really need them
@rajbirsandhu94242 жыл бұрын
As a Data Analyst intern, it has become my worst nightmare to analyze data and find out insights because sometimes, ite really hard to decide how to start and where to start. But by watching your videos, things have become so simple and interesting I would like to say. You truly are the Excel queen. Thank you so much for making our lives easier :)
@SimonSezIT2 жыл бұрын
Thank you for the kind words, Rajbir. Here's some additional videos on data analysis that may be of interest: -> kzbin.info/aero/PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi -> kzbin.info/aero/PLzj7TwUeMQ3iE3tUiAOKdVjSvcq0ynUS2
@kurdishmotivateАй бұрын
Hello dear , did you get the exercise files? Please let me know if you have them I really need them
@yohannesabraham74722 жыл бұрын
This is the only PivotTable course that one needs to be a good analyst. Thank you so much for your generosity in delivering such a valuable course for free by such professional and knowledgable person.
@SimonSezIT2 жыл бұрын
Glad you enjoyed! Thanks for watching ;-)
@petarpetrov5061 Жыл бұрын
I just recently got an opportunity to advance in my career to a new position. Turns out I must be a master of Excel which I had not ever opened once in my life! I want to sincerely thank you for your fantastic training and free training materials, which have made me gain so much confidence in dealing with Excel! Now I look at my future job requirements for Excel and I'm like- I GOT THIS EYES CLOSED !!!!! THANK YOU !!!!
@SimonSezIT Жыл бұрын
It's always nice to hear our tips are helping. Wishing you all the best with your new position. 😊 We have lots of additional free Excel training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@sakiboki1598Ай бұрын
I LEARN SO MUCH THROUGH YOUR TEACHING AND APPRECIATE SO MUCH. THANK YOU DEB.
@SimonSezITАй бұрын
You are very welcome! Thanks for watching 😃
@kurdishmotivateАй бұрын
Hello dear , did you get the exercise files? Please let me know if you have them I really need them
@J-qd5wd8 ай бұрын
Thank you Simon for your generosity; thank you Deb, you are an excellent communicator, the best teacher in the world.
@SimonSezIT8 ай бұрын
Hey, thanks a bunch for watching. I appreciate you taking the time to leave a positive feedback. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@kennymek37763 жыл бұрын
I honestly can not say how much of an assistance the tutorials that Deb Ashby's gives has been in advancing my skills and knowledge on Excel. To start with, Deb Ashby is an excellent tutor with fantastic communication style and approach. The course content is elaborate, detailed and structured. 100% informatively relevant content and very up to date. Thank you for these contents
@SimonSezIT3 жыл бұрын
Wow, thank you!
@A-broken-clay-jar3 жыл бұрын
You are a wonderful instructor! Pivot Table intimated me in college, but now it all starts making sense. I interviewed a job today that requires high level of Pivot Table skills. I am trying to improve my Pivot Table skills from basic to advanced just in case I get a 2nd interview/or the job. I am sure it will be very useful for me in the future for other jobs as well.
@SimonSezIT3 жыл бұрын
Thank you! Delighted that you are enjoying the courses. I hope you get it!
@fumobutu.s.s.r520 Жыл бұрын
Nice video!!! 🌶
@SimonSezIT Жыл бұрын
Thank you! Cheers!
@idayichingovo31356 ай бұрын
Deb you are such an excellent communicator and tutor, i got to understand a lot of formulaes i couldn't get from other tutorials.Thank you so much and SIMON YOU ARE STAR
@SimonSezIT6 ай бұрын
Thank you for your kind words! I'm glad the tutorial helped you understand the formulas.🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@bird85693 жыл бұрын
Your explaining/teaching procedure is excellent. Even any beginner can understand and learn, provided he makes practice of it.
@SimonSezIT3 жыл бұрын
Thank you for your kind words, Delighted you’ve enjoyed the tutorial!
@davidyang6766 Жыл бұрын
There is no download link for the course files. The only download link is for the exercise files.
@kurdishmotivateАй бұрын
Hello dear , did you get the exercise files? Please let me know if you have them I really need them
@denissteward95572 жыл бұрын
Great job done especially to support MEAL Departments in development world.
@OmefeVictor Жыл бұрын
Hi Deb, thanks for this tutorial. You're the best teacher in the world.
@SimonSezIT Жыл бұрын
You are very welcome! Thanks for watching 🙂
@wahidullahnoor20008 ай бұрын
I really enjoyed learning best quick pivot table training from your channel.
@SimonSezIT8 ай бұрын
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@EllenHurstfoxx2 жыл бұрын
I loved this training and thank you very much for making this training available for us.
@tonytaf1072 жыл бұрын
I watched first the 1h video Pivot tables beginner then the 1h advanced one. After that I watched the 2h video beginner Pivot Tables and now right here watching this 2h advanced one. All 4 together is like magic, Thank you so much 🙏🏻
@SimonSezIT2 жыл бұрын
Thanks for kind feedback, Tony! If you need additional Excel training, we recently uploaded our 5+ hour course for Excel 2021/365 intermediate ➡️ kzbin.info/www/bejne/pX-bY4ijmJ6AebM
@SaviJawa3 жыл бұрын
Thank you very much Simon and Deborah
@SimonSezIT3 жыл бұрын
You’re welcome!
@abipeters24543 жыл бұрын
immeasurably helpful. thanks Simon
@SimonSezIT3 жыл бұрын
Happy to help
@sanchezdora12662 жыл бұрын
Deborah, you have a great simple facility to explain excel that I even used your videos to perform my English! I thank you for your time and for sharing your knowledge!
@SimonSezIT2 жыл бұрын
You're very welcome, and thank you too!
@lloydfaulkner99202 жыл бұрын
very interesting course. The accent is very clear, thanks
@osoriomatucurane95116 ай бұрын
Great Tutorial, Crystal Clear and Concise. When grouping a numerical field into categories/classes, instead of keeping intervals, It would be awesome if we could have the option to rename the groups (like low, moderate, high, etc,...), just as we did when grouping text fields. Actually this feature I feel like it should be better named as hierarch or categorization/bucketing since right from the beginning, the pivot table is already grouping by unique fields/values, apply the aggregation metric (sum, average, count, min, max,.......)! just thinking loud!
@marymymodelmaria32102 жыл бұрын
You guys are good teachers. I appreciate you Deb.
@SimonSezIT2 жыл бұрын
Our pleasure!
@merittilewa3030 Жыл бұрын
You are simply the best. God bless you
@SimonSezIT Жыл бұрын
Wow, thank you
@apochioodo9032 Жыл бұрын
you are such a great and excellent excel teacher
@notificamedo2 жыл бұрын
Is very useful. God bless what you do!
@SimonSezIT2 жыл бұрын
Thanks Edwin 😄
@glorifinadelossantos6406 Жыл бұрын
What a great relief for us beginners. Thank you very much for your greatness in teaching people!
@SimonSezIT Жыл бұрын
Thanks for the nice comments and the visit 😊
@JA-kb2mh2 жыл бұрын
You´re such a great teacher. Thank you so much for sharing this valuable content for free! It was so great that I decided to become a member at your website. Keep it up!
@jazbaatilaunda Жыл бұрын
Hi Deb, first up, thanks a bunch! I can't express how much your videos have helped me learn pivot tables. Forever grateful. I downloaded the files but the sheets are totally different from what I see in the tutorials. Am I missing something? The files are under Folder 1, 2, 3 and 4 and they seem to be employee data files not sales figures.
@yunfengwang1510 Жыл бұрын
Excellent tutorial in Excel ever!
@SimonSezIT Жыл бұрын
Glad you think so!
@srtechno304910 ай бұрын
Unbelievable Simon
@SimonSezIT10 ай бұрын
Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!
@mekassociatescpa Жыл бұрын
great lectures
@choroyerebakia2742 Жыл бұрын
Brilliant presentation like never before
@SimonSezIT Жыл бұрын
Thank you so much, Choro! If you need additional Excel training, there is plenty of it here -> kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
@hatimhmt15023 жыл бұрын
thanks deb and thanks SIMON SEZ IT quite useful
@SimonSezIT3 жыл бұрын
Glad to hear it Hatim
@JacobKinsley3 жыл бұрын
Thanks for uploading this for free onto KZbin! Pivot Tables have always seemed really useful but I've never understood what some of the advanced features do until now.
@SimonSezIT3 жыл бұрын
Glad it was helpful! thanks for watching
@bernardgithua6029 Жыл бұрын
Thanks in a bunch Deb for this training. I can confirm this has improved my data analysis techniques
@SimonSezIT Жыл бұрын
You're welcome! Wishing you all the best in 2023 :-)
@divinelyguided_protected1442 жыл бұрын
This is excellent. Thank you for sharing this information for free.
@SimonSezIT2 жыл бұрын
Glad you enjoyed it, Nikki! 😃
@ProsenjitBappi2 жыл бұрын
nice explanation, thank you.
@SimonSezIT2 жыл бұрын
Glad you liked it!
@grahamhilldrup12563 жыл бұрын
Thank you so much for putting this video online; I found it very informative.
@SimonSezIT3 жыл бұрын
Glad you enjoyed it!
@alessandroinvernizzi32493 жыл бұрын
Great course on Pivot Table, very clear explanation supported with exercises. Highly recomended, thanks.
@SimonSezIT3 жыл бұрын
You're very welcome Alessandro!
@usmanmarikkar98653 жыл бұрын
Hello Alessandro ... Have u got the exercise files downloaded for this course.. I tried downloading through the above link ..but the link isn't working
@maameagyeiwaa85802 жыл бұрын
Thank you for this detailed course
@SimonSezIT2 жыл бұрын
You're very welcome!
@ahmedsamir1193 Жыл бұрын
Thank a lot Simon really I appreciate this high quality effort the course is amazing
@SimonSezIT Жыл бұрын
Our pleasure!
@lizzingbet Жыл бұрын
So good! Thank you. I've learnt so much.
@SimonSezIT Жыл бұрын
Glad you are enjoying the training. 😀
@piobasartejr.76863 жыл бұрын
I am enjoying watching and learning at the same time this video tutorial. It's easy to follow that will linger in my beautiful brain infinitely as long you focus, focus and most importantly focus whilst watching the tutorial. Much gratitude Simon Sez IT.
@SimonSezIT3 жыл бұрын
Thank you for your wonderful review, delighted that you've enjoyed the tutorial!
@lolaadeoye35843 жыл бұрын
Thank you for refreshing my Power pivot knowledge, the content is very useful.
@SimonSezIT3 жыл бұрын
Glad to hear that!
@selfmadetool Жыл бұрын
Thank you!
@oyunpurevbattumur60732 жыл бұрын
Brilliant teaching! Thank you very much!👍
@SimonSezIT2 жыл бұрын
Glad you liked it, Oyunpurev Battumur🙂 You can get additional Excel training here ➡️ kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
@mohamedkewan13643 жыл бұрын
Thank you so much for sharing this.
@SimonSezIT3 жыл бұрын
I’m glad you’ve enjoyed the tutorial Mohamed!
@zoilovaldez2 жыл бұрын
Best Excel training course I've ever seen on the web. Congrats., I've subscribed to receive further info from your channel and stay up-to-date on this matter.
@SimonSezIT2 жыл бұрын
Thanks Zoilo, greatly appreciate your kind comments. We'll pass it along to Deborah.
@oscararguijojr.49793 жыл бұрын
12 minutes in but already subbed!! thank you so much for this video!
@SimonSezIT3 жыл бұрын
Wohoooo, Delighted to hear it!
@samuelopoku-agyeman9432 Жыл бұрын
The relationship was not forming well though i was going through the process step by step, same help will be needed
@petetones37483 жыл бұрын
good detailed overview, thanks
@SimonSezIT3 жыл бұрын
You’re welcome!
@antoanD Жыл бұрын
Really great tutorial! Thank you!
@samuelopoku-agyeman9432 Жыл бұрын
Amazing class. I am Sam from Ghana
@SimonSezIT Жыл бұрын
Thanks for watching our training, Samuel 😀
@yumyes62722 жыл бұрын
Excellent presentation
@amilamsamson19772 жыл бұрын
very Helpful Vedio, Many Thanks for making and publishing this in You tube.
@SimonSezIT2 жыл бұрын
You are most welcome
@levkalishchuk5406 Жыл бұрын
Thank you! Super helpful!
@ofosuappiah52092 жыл бұрын
Thanks for this course
@SimonSezIT2 жыл бұрын
You are very welcome! Thanks for watching :-)
@prakashwadkar98992 жыл бұрын
A Very very helpful course. Thank you
@SimonSezIT2 жыл бұрын
Glad it was helpful!
@ebrimajobe75303 жыл бұрын
Thank for this great tutorial
@SimonSezIT3 жыл бұрын
Glad you liked it
@Thetrurth2 жыл бұрын
Should be getting like and getting view million
@SimonSezIT2 жыл бұрын
Thank you Sam, I’m glad you’ve enjoyed it! 🙃
@miftahfarid21413 жыл бұрын
Great content, really helpful
@SimonSezIT3 жыл бұрын
Delighted to hear that Miftah!
@hazemali3822 жыл бұрын
More than great Tutorial Many Thanks ♥
@SimonSezIT2 жыл бұрын
Glad it was helpful, Hazem ♥
@tone49963 жыл бұрын
Many thanks. Great course, all in one video.
@SimonSezIT3 жыл бұрын
Glad you liked it!
@samuelegbule8192 Жыл бұрын
Fantastic traning
@PrasannaKumar-bo3vt2 жыл бұрын
Teaching is excellent
@SimonSezIT2 жыл бұрын
😊 Thanks for watching!
@sumanpradhan34072 жыл бұрын
Thank you very much Sir/Ma'am for such a good content..wish you all the very best for your future advancement...
@SimonSezIT2 жыл бұрын
You're very welcome! Thank you for watching ;-)
@maxwell95663 жыл бұрын
Great and very helpful tutorial.
@SimonSezIT3 жыл бұрын
Glad you liked it
@listyokowisnuaji51793 жыл бұрын
very good way of improving your pivot table skills.. thank you for uploading this video
@SimonSezIT3 жыл бұрын
Thanks and welcome
@35jays3 жыл бұрын
Great tutorial and easy to follow. Thanks for sharing!
@SimonSezIT3 жыл бұрын
Thanks for watching!
@gianlucatorriglia37602 жыл бұрын
Thanks, great course so far .. I'm on the middle of that. Doing Exercise 2 I found a typo, you missed to delete duplicates before doing the Pivot Chart.
@simshp2 жыл бұрын
Yip, picked that up as well .. nevertheless a great course so far
@priscillarubio60792 жыл бұрын
love this video! thanks for sharing!
@SimonSezIT2 жыл бұрын
Thanks for watching! :-)
@kamineyiresha3583 жыл бұрын
Thank you so much for this valuable tutorial
@SimonSezIT3 жыл бұрын
You're very welcome!
@hemanttewari67524 жыл бұрын
Tutorial is exceptionally well explained!!!
@SimonSezIT4 жыл бұрын
Glad you think so!
@kamalchellani74122 жыл бұрын
Excellent. Thank you
@SimonSezIT2 жыл бұрын
You're welcome!
@junalynbagani51543 жыл бұрын
Thank you 😀 The tutorial help me a lot. I enjoyed it as well.
@SimonSezIT3 жыл бұрын
You're welcome 😊
@jonathand1702 жыл бұрын
Great tutorial!
@abubakarrk.conteh3253 жыл бұрын
Great tutorial
@SimonSezIT3 жыл бұрын
Glad you think so Abu!
@EcommerceOfGeorgia Жыл бұрын
amazing!
@SimonSezIT Жыл бұрын
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!
@abdidekmuhumed45103 жыл бұрын
Very very useful, thanks.
@davegrimes3 жыл бұрын
Thank you. Great intro!!
@SimonSezIT3 жыл бұрын
Thank you Dave!
@hatimhmt15023 жыл бұрын
very great
@prabhleenmalhotra14693 жыл бұрын
A very helpful course. Thank you!
@SimonSezIT2 жыл бұрын
Glad it was helpful!
@bradleybarker31332 жыл бұрын
Great course! Nice refresher and learned some new things along the way.
@SimonSezIT2 жыл бұрын
Thanks Bradley, appreciate the feedback!
@jakobforslin63013 жыл бұрын
Awesome video, thank you so much!
@SimonSezIT3 жыл бұрын
Glad you liked it!
@humayonkabir67292 жыл бұрын
Great job!
@SimonSezIT2 жыл бұрын
Thank you! Cheers!
@tranngoctrung41502 жыл бұрын
Very useful lesson. Thanks so much!
@SimonSezIT2 жыл бұрын
Glad it was helpful!
@tennispie12 жыл бұрын
Thanks :)
@SimonSezIT2 жыл бұрын
No problem!
@janakadissanayake93503 жыл бұрын
Just what I wanted Thanks 😀
@SimonSezIT3 жыл бұрын
You're welcome 😊 Glad you enjoyed it Janaka! Thank you for watching and commenting!
@dream910113 жыл бұрын
thank you
@SimonSezIT3 жыл бұрын
You're welcome
@futuregenetics978 Жыл бұрын
Hi Deb, obviously a fan of yours. Just a worrying question... If we upgrade from Office 2019 to Office 2021, will this corrupt the formulas already created in our source tables and will there be any issues when we start using the new Office 2021 Pivot/ Power Pivot functions with excel data that was created in Office 2019? Thanks for any help you can offer.
@CR-lz5yx3 жыл бұрын
Awesome👍👍👍
@SimonSezIT3 жыл бұрын
Thanks for watching!
@avr97473 жыл бұрын
Plz cover: *data analysis *data protection *machine learning. -simplyfy.That holds the key. Many thanks Ashish
@SimonSezIT3 жыл бұрын
Thanks for the ideas, we have quite a bit on data analysis already. Not so much on the other areas
@tommasosquarzoni86143 жыл бұрын
AMAZING
@SimonSezIT3 жыл бұрын
Thanks for watching Tommaso!
@wendyyepez75949 ай бұрын
Hello, I love the content! However, I have one doubt, when we practiced with the CleaningData File, I did notice that you did not delete the duplicate rows?
@vinayzzzful Жыл бұрын
The file sent through the link are completely different. @Simon Sez IT - please correct the files, otherwise the course could not be followed. Please paste the updated link here -
@shermeenzeidan5697 Жыл бұрын
The above link for downloading the files doesn't work, only the exercise ones work. I have been trying since last night. Thank you for sending me the files used in the video.
@ishine_tv7 ай бұрын
Very detailed, thanks very much. but pivot chart is not really treated. Will sign up for more courses
@SimonSezIT7 ай бұрын
You are very welcome! Thanks for watching 🙂 For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info
@PangPangXiong Жыл бұрын
Nice course to go through! However, there is a small mistake at 1'16" time with excise 2 practice and you have not yet removed duplicate fields for 2018 Balance department. Anyway, it's an excellent course to learn through. Thanks very much!
@EK-wq7qt2 жыл бұрын
Hi, I can't find Course file in the given link. There are only exercise files which don't match the data which you have in the video. Can you help me please in this regard? Thank you so much.
@sachinchari41442 жыл бұрын
Pivot table is counting formula also.. Kindly help to solve this problem Thanks in advance