Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course
Рет қаралды 1,649,348
Күн бұрын✅ Download to follow along and complete the exercises ➡️ www.simonsezit.com/excel-2021...
In this Microsoft Excel 2021 Advanced training course, fast-track your Excel skills to expert level. We introduce you to new dynamic array functions, how to deal with spills in arrays, and use advanced Excel formulas and functions like XLOOKUP and XMATCH.
We also discuss the difference between Unique and Distinct, how to use different sort functions, and advanced filtering. You will learn to create advanced and flexible lookup formulas, use statistical functions to rank data, calculate the MEDIAN and MODE, and so much more!
We've even included downloadable exercise and instructor files from our paid-for course so you can follow along and complete the exercises in this Advanced Excel 2021/365 Tutorial. This will help you put what you are learning into practice and master Excel.
✅ www.simonsezit.com/excel-2021...
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
0:00:00 - Introduction
0:03:09 - Exercise 01
0:05:15 - Dynamic Arrays
0:07:31 - Spill and Arrays
0:18:23 - Extract and Count Unique Entries
0:24:38 - Unique vs. Distinct
0:28:02 - Unique with Multiple Criteria
0:31:13 - Unique Values by Column
0:35:37 - SORT Function
0:44:30 - Horizontal Sort
0:50:38 - SORTBY Function
0:56:47 - Horizontal SORTBY
0:59:52 - Sequence and Unstacking Records
1:10:02 - Filter Function
1:16:59 - Using Filter with Logic Plus Operator
1:21:47 - Using Filter with Logic Asterisk Operator
1:27:27 - Using Filter with Logic Equals Operator
1:31:40 - Using Filter with Logic Minus Operator
1:36:29 - RANDARRAY and RANDBETWEEN
1:46:11 - XLookUp
1:58:34 - XMatch
2:04:55 - Exercise 02
2:18:04 - Two-way Lookups
2:26:29 - CHOOSE Function
2:36:33 - SWITCH Function
2:41:03 - Exercise 03
2:48:11 - Median and Mode
2:54:25 - Using LARGE and SMALL
3:01:58 - Ranking Data
3:09:39 - COUNTBLANK Function
3:14:25 - Exercise 04
3:21:31 - Rounding Values
3:28:29 - Specialized Rounding
3:33:00 - Aggregate Function
3:37:31 - Exercise 05
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first...
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
✅ Check out our free video playlist for Excel beginners 👉 • Microsoft Excel Beginn...
✅ Excel 2021 Tutorials for Intermediate Users here 👉 • Excel 2021 Tutorials f...
✅ Microsoft Excel Tips and Tricks 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 Training here 👉 • Microsoft Office 2021 ...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzfaq.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
❤️ We appreciate your support!
@user-ex5pt6fo9f Жыл бұрын
The best tutorials I have ever watched .Well presented.thank you
@sanimunir Ай бұрын
The problem with the downloading file is that the software demands for email and after entering email, it says thanks and then you have to wait. How much no one knows then.
@Get.YouTube.Views.756 3 ай бұрын
Your video had me captivated from start to finish. The storytelling was engaging and compelling.
@faissalloussaief149 Жыл бұрын
Fabulous ❤course, thanks for sharing your knowledge with us. The explanation is super clear and easy to understand. ❤❤❤❤❤
@XxKingfisherxX Жыл бұрын
Thanks to Deb for knowledge you are spreading and thanks to Simon for ensuring it, i wish getting the follow along files download would 've been straight forward.
@devramharak7934 Жыл бұрын
Excellent tutorial.Well presented. The manner in which the tutorials are presented could be applied in the real world. I am addicted to learning and from most of the tutorials and videos this is one of the best that I have watched.
@SimonSezIT Жыл бұрын
Much appreciated! 😊
@daniellukaobidakpasham103 Жыл бұрын
Honstly am really enjoying the Advanced Excel Training course
@mariag2916 10 ай бұрын
Thank you so much for this. This is amazing for anyone, but if you are unemployed and cannot afford to take a course, this really helps employment prospects. You can walk into a job role with more confidence knowing you have this knowledge. The downloadable files really help with practice too.
@SimonSezIT 10 ай бұрын
We're so glad that you find this helpful!
@jackmuscovich9031 3 ай бұрын
I have to say I almost never comment on KZfaq videos I watch. But this course is flawless. Everywhere from the concepts covered to the files you can use to follow along... I'm blown away by how perfect this was. Thanks so much!!!
@SimonSezIT 3 ай бұрын
Glad you enjoyed it! Thanks for taking the time to leave a nice comment 😊
@dansmith5037 11 ай бұрын
Thank you so much for posting this course and a link to the files!! I bought an Excel learning bundle with the 2021 beginner and intermediate but the bundle didn't have 2021 advanced. Very much appreciated and Deb- you're amazing!
@terrylee2094 2 жыл бұрын
Brilliant tutorial as always. Such calmness and clarity in the presentation
@gustavopineda7933 Жыл бұрын
Perfect course, thanks.
@andrehenry3212 3 ай бұрын
Thanks for sharing this precious training.
@tatipamulaashok5721 Жыл бұрын
Excellent and simplified explanation with more useful examples by using advanced functions... Thank u so much 🥰
@SimonSezIT Жыл бұрын
You are welcome 😊 We have lots of additional free Excel training if you need it ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@dannguyen239 Жыл бұрын
Thank you so much! This is super helpfull!!!
@ussama8960 10 ай бұрын
i started your course from beginners course 7days ago ,now i'm in the advanced course it's really a super course ,the way you explain ... thank you so much deb
@SimonSezIT 10 ай бұрын
Great to hear!
@zhangmr7955 2 жыл бұрын
Dab is the best teacher I ever met. I attend some classes on the other platform. Excellent!
@SimonSezIT Жыл бұрын
Thank you for the kind comments Zhang! 🙂
@umeshkhatri3743 Жыл бұрын
Brilliant tutorial. Explained with very calmness and clarity.
@SimonSezIT Жыл бұрын
Many thanks!
@Exceltech810 Жыл бұрын
the video is very clear. Thank you
@SothearithKONGMrMuyKhmer Жыл бұрын
Perfect tutorial! Thank you very much!
@SimonSezIT Жыл бұрын
Glad you like it! 😊 We have additional free Excel training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@johnravi1683 2 жыл бұрын
Hi Simon, It was a great share! I have been very disorganized lately, so I am paying my younger nephew to help me organize my data with Excel. He is new to this, and he doesn’t understand all the features. I am sure this video will help him a lot, and he will be able to complete the task much faster. It was a very in-depth tutorial, and I am sure learning how to use Excel will help him later in life as well. Thanks for sharing this, it was a great watch.
@SimonSezIT Жыл бұрын
Hi John! Your nephew has a nice Uncle :-) If he needs additional free training, he can check out our Excel playlist here -> kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI Good luck with organizing the data!
@alymohamed8779 2 жыл бұрын
So easy so good keep it up
@spreadknowledgeknowledge3361 Жыл бұрын
Hi Dab your every video is incredible for excel learner. Thank you so much💌
@SimonSezIT Жыл бұрын
Our pleasure Spread Knowledge Knowledge 🙂 You can get additional Excel training here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
@laviejaguardiadeltango9201 2 жыл бұрын
Okey Simòn thak you good nigth.
@raaghavgr1990 Жыл бұрын
Lovely tutorial. Watched it all the way through.
@SimonSezIT Жыл бұрын
Glad you are finding them helpful, Raaghav G.R. :-)
@karennguyen7083 Жыл бұрын
Great tutorial and many thanks. Keep going ^^
@SimonSezIT Жыл бұрын
Glad it was helpful, Karen! Thanks for the encouragement 😃
@darealstatic Жыл бұрын
Very straight forward. Thank you!
@SimonSezIT Жыл бұрын
Glad you found it helpful! Wishing you all the best in 2023 :-)
@kapil4757 Жыл бұрын
This is really great job done!!! Making such a wonderful content available for free is an amazing job you guys have done. Keep up the great work, god bless!
@SimonSezIT Жыл бұрын
Thanks so much, Kapil!
@lorilori155 Жыл бұрын
thank you so much! This is superb!
@adlerdoesstuff1872 4 ай бұрын
SKIBIDI TOILET
@wilfredtaikerweyah4625 8 ай бұрын
Thank you, thank you, thanks! This is more than great.
@SimonSezIT 8 ай бұрын
Thank you very much!
@user-lo1vs3sr2y 6 ай бұрын
Perfect tutorial! Thank you very much!. thank you so much! This is superb!.
@SimonSezIT 6 ай бұрын
You're welcome.Thank you for you positive feedback. 🙂 Check out our FREE 300+ hour training course playlist here ➡️ 🔥kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!
@fitchfoo7082 2 ай бұрын
It is an amazing Excel video course. Your explanations are so clear. It takes a complex concept and makes it easy to understand.
@SimonSezIT 2 ай бұрын
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@Exceltech810 Жыл бұрын
It's better if Simon can have Python, and Mysql full courses. This is b/c I love Simon's video with clarity and easy-understand
@banerjeesomdipta Жыл бұрын
Absolutely Super Video . Loving it .
@SimonSezIT Жыл бұрын
Thank you! Cheers!
@arturoaugustoperezjaramill8590 3 ай бұрын
Very nice and complete video... Tks 4 sharing... ¡Saludos desde Panamá City, América Central!
@SimonSezIT 3 ай бұрын
Thank you so much for your kind words! I'm glad you enjoyed the video. 😊 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@gregcachin8308 Жыл бұрын
nice and easy to understand the tutorial, TY
@SimonSezIT Жыл бұрын
Glad it was helpful! Thanks for dropping by :-)
@emmabeards 2 ай бұрын
Saved me so much trouble! thank-you!
@SimonSezIT 2 ай бұрын
Glad you enjoyed it. Thanks for watching! 🙂
@shamusm9252 Жыл бұрын
Amazing as always
@SimonSezIT Жыл бұрын
Glad you enjoyed it! Thanks for watching 😃
@dontown-lb5ke Жыл бұрын
I have been using Excel since 1993 (ver.5), it came on 11 floppy discs! but am still learning new things every day.
@SimonSezIT Жыл бұрын
My first version was in 1995, but I don't recall the actual version. It's hard to believe we are using it 30 years later 😊
@wayuwam 7 ай бұрын
thanks a lot for education..you're amazing
@SimonSezIT 7 ай бұрын
Hey, thanks a bunch for the shoutout! We're thrilled that you're finding our videos helpful. Stay tuned for more educational content coming your way! 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!
@kiiprop 2 ай бұрын
Thank you for the detailed explanations 🤗
@SimonSezIT 2 ай бұрын
You are very welcome! Thanks for watching 🙂
@muhammadika 2 жыл бұрын
Excellent tutorial
@SimonSezIT 2 жыл бұрын
Thank you! Cheers! 🙂
@roote4k154 2 жыл бұрын
I like your video
@phandongexcel 4 ай бұрын
I like this video and comment, I’m from Vietnam and you ❤❤❤❤
@SimonSezIT 4 ай бұрын
Glad you think so! Thanks for leaving as comment ;-) Sending some ❤❤❤❤ back :-)
@maazziuche28 Жыл бұрын
Great tutorial, well eplained
@SimonSezIT Жыл бұрын
Glad you liked it!
@user-hc6gu3xt9t 10 ай бұрын
Excellent and simple and useful
@SimonSezIT 10 ай бұрын
Glad you liked it
@nigelwaxley Жыл бұрын
Thank you for this. Where can I find the rest of the course. Some items, such as form controls and lumbda, are mentioned in the intro but aren't available in this vid.
@BangabhabanClub 6 ай бұрын
Excellent Tutorial!
@SimonSezIT 6 ай бұрын
You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!
@taiwoadebesin3882 3 ай бұрын
I dey enjoy it well well
@ismailfaruk6676 2 ай бұрын
Today, is exactly 11 days of my self enrolment in to the course, and I can confidently say that my level of practical knowledge of the tutorial is at least 80% . And I know continue practice will make me a guru. Thanks so much Simon Sez IT
@SimonSezIT 2 ай бұрын
Wonderful! Keep it up, and thanks for watching :-)
@oxistlamb3336 3 ай бұрын
❤ Deb Is my on repeat I just can tell your patience for slow learners like me, is infinite 🎉
@SimonSezIT 3 ай бұрын
Thank you for your kind words, I appreciate it! 🙂 🔥Check out our FREE 400+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@microsoftsarker 8 ай бұрын
Thank you so much for this
@SimonSezIT 8 ай бұрын
You're welcome and thanks too for taking the time. 😊 We also have a free 9-hour course for Office 2021/365 👉 kzfaq.info/get/bejne/bNeaoqqUkrGoiac.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!
@valarmorghulis2736 Ай бұрын
great explanation, thanks for sharing
@SimonSezIT Ай бұрын
Glad it was helpful!
@realvirtualdemand4222 Жыл бұрын
I can increase my skills to get a better change at getting a job. Thank you
@SimonSezIT Жыл бұрын
Thanks for dropping by. We hope the training results in your desired job :-)
@sushantramdas3078 Жыл бұрын
Deb is the goat excel trainer.
@SimonSezIT Жыл бұрын
Thank you!
@chitsuhtwe2510 Жыл бұрын
Thanks
@goce113 Жыл бұрын
I think the values that appear only once are unique and the values with their duplicates removed are distinct. Correct me if I'm wrong.
@revolutionarydefeatism 3 ай бұрын
2:23:13 With all due respect dear Deb, you should first MATCH for Company (since it is the row that asked as a prior argument in INDEX) and then for Month. Your sanity check had this problem: you checked for the 5th month and 5th company, the 1st month, and the 1st company, so the row and column numbers were the same.
@revolutionarydefeatism 3 ай бұрын
50:15 Deb, I thank you for your great course! I'm a big fan of you. However, although you found the actors, the corresponding movies are not right, since there is a column between the movies table and the column you created, and when you sort them, the movies' order doesn't change.
@kelkelly9038 5 ай бұрын
Thank you!!
@SimonSezIT 5 ай бұрын
You are very welcome! Thanks for watching 🙂 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@dansmith5037 11 ай бұрын
I believe @49:40 arranging the actors in alphabetical order displaced the movie reference. The duplicate movies would be Divergent/Insurgent and This is the end/ Superbad. Solution would be to create another column, copy the movies to that column (left), copy, paste as value, sort, expand selection.
@MensoJero 7 ай бұрын
Another solution is to make the whole thing a table now that it's ready for sorting, or SKIP THE SORTING and just go straight to duplicate highlighting, once highlighted it's much easier to match up the movies anyway, but sorted would be nice.
@Allona33 7 ай бұрын
I just left out the sorting it from a-z
@abrahammanyang5313 6 ай бұрын
I could only imagine the world without technology; how I would be without it. I can't thank you enough for this amazing work you are doing. Thank you so much to Mrs. Deb for helping me.💌💌
@SimonSezIT 6 ай бұрын
Wow, thanks for your kind words! I'm glad it was helpful. 🤩 Check out our FREE 300+ hour training course playlist here ➡️ 🔥kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!
@user-uv6dc2uk3w Жыл бұрын
Peace be upon you Thank you for the wonderful content I would like you to specify the most important jobs required in the labor market. Who works in Excel? And what are the most important skills that you want to acquire to implement these activities in order to quickly enter the labor market?
@AsifTech_ 10 ай бұрын
I have commented a problem about two way lookup using Index & Match function. I have solved the problem myself, The Formula that I have done-=INDEX(Data,MATCH(A14,company,0),MATCH(B13,Month,0)) and then give the right result.
@SimonSezIT 2 жыл бұрын
✅Download to follow along and complete the free exercises ➡️ www.simonsezit.com/excel-2021-advanced-instructorexercise-files/ 🔥Check out our FREE 300+ hour training course playlist here ➡️ kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Boost your Excel skills with these free Excel playlists 👉🏼 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉🏼 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉🏼kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@zhangmr7955 2 жыл бұрын
Hi Dab, do you consider to open some VBA courses?
@zhangmr7955 Жыл бұрын
Hi Dab, please confirm there are some incorrect workseets not matched to the courses content: 02-17,02-18,02-19
@antonmursid3505 Жыл бұрын
Antonmursid🙏🙏🙏🙏🙏✌💝🇲🇨🇲🇨🇲🇨🇲🇨🇲🇨✌💝👌
@paulprobusjr.7597 Жыл бұрын
Adin points this out in his separate comment, below, but at 50:20 with the Horizontal Sort segment, there is a mistake, Deb did not make the final sort with the movies in mind so the list of actors is out of sync with the movies they starred in, so her conclusion as to which four movies they were all in together is incorrect. I noticed some mistakes in the earlier video on Beginner to Intermediate as well, but since this one is a bit more advanced functions and function combos, it should be re-looked at and corrected. Some of those previous ones I can figure out how to correct fairly easy, this one will take a bit more thinking on my part, but I think I can work out something. Still working through the video and may have other feedback to give. I am very impressed overall with how good this video has been, I wanted to make that clear that it has been very useful and its appreciated. Thanks!
@manmantsethi6386 3 ай бұрын
excellent teaching material
@SimonSezIT 3 ай бұрын
Many thanks!
@rabeehaithamrashid942 8 ай бұрын
Great ! 😃
@SimonSezIT 8 ай бұрын
Thanks 🤗
@christianmprieto Жыл бұрын
Only a fourth the way through so far but it's been very helpful.
@zarifali3784 7 ай бұрын
Great 😍
@SimonSezIT 7 ай бұрын
Glad you enjoyed it. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZfaq Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzfaq.info ♥️ We appreciate your support!
@abdulmateen6101 7 ай бұрын
Excellent tutorial, nicely explained. However example 2 of XMATCH, the function fails to give correct number of employees who surpassed 17,000 sales figure if the sales figure are not of descending order.
@ellenaellena295 6 ай бұрын
life saver thanks man prayers from pakistan
@SimonSezIT 6 ай бұрын
You are very welcome! Glad it was helpful. 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@EXCELMASTER-Wiseoption 6 ай бұрын
Great content
@SimonSezIT 6 ай бұрын
I really appreciate your feedback! Thanks for watching 😊 Check out our FREE 300+ hour training course playlist here ➡️ 🔥kzfaq.info/sun/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
@phandongexcel 2 ай бұрын
I like this video ❤❤❤
@SimonSezIT 2 ай бұрын
Thanks for the kind comments 🙂
@readingkhmer49 Жыл бұрын
Hello, I have a question In excel 2021, the Khmer font in work sheet is pretty normal, but when I go to print the khmer font is cut off above. So what can i do?
@MensoJero 7 ай бұрын
Excellent tutorial, however... There's a mistake at 49:15. You sort the data on the right but the left side remains unaffected. This means the rows no longer line up after you sorted. So when you match the red duplicates, they actually don't line up with the movie titles anymore. The duplicates were not "The Interview" and "Superbad", but instead "This is the end" and "Superbad". The duplicates were not "Burn After Reading" and "Insurgent", but instead "Divergent" and "Insurgent".
@sd9320 3 ай бұрын
Yeah , I was wondering the same..
@thelonerider917 7 ай бұрын
Thank you, this is Amazing, a quick question though -while typing formulas and referencing a cell or range of cells,you mentioned locking the cell, how do you do that?
@SimonSezIT 7 ай бұрын
If you right click on a cell then select Format Cells, there should be a pop up window, then go to the Protection tab. All cells by default are locked, which is indicated by a checkmark next to the Locked option. You can close this window by clicking OK to save your changes or Cancel. Next, go to Review tab in the menu ribbon and click on Protect Sheet. You can then select what actions are allowed for the locked cells. You can lock or unlock multiple cells by highlighting all of them before right clicking.
@xlwatcher8885 Ай бұрын
This is amazing, but the downloaded files don't match the files in her excellent lectures. Did I download something wrong? thank you
@JamesNjanjo Ай бұрын
Afternoon, have really tried to download those practise files more than 5 times....but haven't not received them on my PC...
@ogunbanjoolutayo33 Жыл бұрын
Simon Sez tutorial content always comes with clarity, concise and easy to understand especially with Deborah Ashby including other good tutors too. I want to find out if Simon Sez has any free content on Microsoft Azure. Thank you.
@SimonSezIT Жыл бұрын
You're very welcome! We have no training for Azure, but it something we are considering later in the year. Thanks for the visit ;-)
@adlerdoesstuff1872 4 ай бұрын
SKIBIDI TOILET @@SimonSezIT
@ironpurush0978 Жыл бұрын
Your email service is not working I guess. Not getting files though.
@Kittukat24 Жыл бұрын
Hi, I have MSOffice LTSC Professional Plus 2021. I am not able to execute your formula in the first 2 lessons. My excel is not showing any formula such as filter. I did not check further. Do I have incorrect version of excel?
@Jas.dhariwal Жыл бұрын
Having trouble with downloading excel files, stuck at 50%, any alternate link?
@zhangmr7955 Жыл бұрын
Dear Dab, the attached instructor file 02-06-extract-unique-values-by-column workseet is wrong, this is the same with 02-05.
@SimonSezIT Жыл бұрын
Hi Zhang, thank you for letting us know. In the meantime, you can use the 02-06-extract-unique-values-by-column-Complete.xlsx file to follow along in this section, although this file would already have the final solutions.
@tutsecret499 Жыл бұрын
I will have an interview about this topics: "...to provide high level support to programs and program management, including ongoing data collection, preliminary analysis, problem identification, planning and coordination, development of alternative resolutions, final recommendations and specialized projects..." So which topics in Excel I should focus and study more. What preliminary analysis they are talking about. When the analysis starts, after I refine, clean the data? What they mean about alternative resolutions when handling data and final recommendation mean?
@QadiimiEnterprises Жыл бұрын
Thank so much i hope you great in life. you made us satisfied.
@SimonSezIT Жыл бұрын
You are welcome, thank you for the nice comments. If you need more Excel satisfaction🙂 we have additional videos to 🚀 boost your Excel knowledge 👉🏼 kzfaq.info/sun/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉🏼 kzfaq.info/sun/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉🏼kzfaq.info/sun/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@Sensible-Immigrant Жыл бұрын
I did not receive the link to the files? Does anyone else have the same problem or is it just me?
@herio7776 8 күн бұрын
@2:09:25 Just wanted to point out this error here. The unique vs distinct values are wrong
@atroposization 5 ай бұрын
Thank you for the informative course and engaging tutor! There seems to be a problem with the exercises. I cant download the files?? Kindly someone to advise. Thanks!!
@SimonSezIT 5 ай бұрын
Hey there! Thanks a bunch for the awesome feedback! ✅You can download the course files here ➡️ www.simonsezit.com/excel-2021-advanced-instructorexercise-files/ Just click the button that says "Get My Files" so that we can send you the course files through your email.
@asimsiddiq475 2 жыл бұрын
I want to do this.
@mrthompson4438 7 ай бұрын
Less selling and more teaching. Your welcome
@stec0123 Жыл бұрын
Excellent I can't believe that it is free. Far better than udamy rubbish courses
@SimonSezIT Жыл бұрын
Glad it was helpful, Deepak! Thanks for the nice comments 😊
@AsifTech_ 10 ай бұрын
In Two way Lookup section, I have tried your Instructor Files practice but I can not get right result using Index & match function, I have write-=INDEX(Data,MATCH($B$13,Month,0),MATCH($A$14,company,0)), It gives for Month Sep against GoExplore. Pls Give me a Solution
@himangsusarkar6737 Жыл бұрын
can I get the original file?
@achariyagroup-ns7wy 3 ай бұрын
good
@SimonSezIT 2 ай бұрын
Hope you enjoy it! 🙂
@popcat4ad 7 ай бұрын
a question please: how come my Excel 365 does not work on array formula? I had Excel 2019 and upgraded it today.
@popcat4ad 7 ай бұрын
Resolved
@mohammedkassimsalim9351 8 ай бұрын
i cant download the exercise file. nothing comes in email
@angelafiola4989 Жыл бұрын
did the beginer then the next and now i am here
@AzeezBukola-ux7ls 6 ай бұрын
How do I download the exercise files
@pharmabro Жыл бұрын
Love the calming voice and pace . I am learning alot however when I tested your 2 way look up with index and match I didnt get the right answer all the time then I realised the error. Index formula is array, then row_num then [column num] the example was giving column number then row number The examples were same row and column number ( 5x5 and 1x1). So that's why it still worked.
@SimonSezIT Жыл бұрын
Wonderful! Glad it worked out.
@elaineminoza3927 Жыл бұрын
W aha
@elaineminoza3927 Жыл бұрын
W aha,
@sprayarm 2 жыл бұрын
I wish I could learn pivot tables!
@SimonSezIT 2 жыл бұрын
Here are some of our videos on Pivot Tables -> kzfaq.info/get/bejne/n8qXh5p4z8yUgGQ.html & -> kzfaq.info/get/bejne/p8WHfs6D1a-pj58.html 🙂
Simon Sez IT
Рет қаралды 67 М.
Simon Sez IT
Рет қаралды 397 М.
Technology for Teachers and Students
Рет қаралды 305 М.
Google Cloud Platform Tutorial 2024 | Google Cloud In Depth Tutorial | Cloud Computing | Simplilearn
Simplilearn
Рет қаралды 988 М.
Simon Sez IT
Рет қаралды 65 М.