Microsoft Excel Intermediate Training (2021/365): 5-Hour Excel Tutorial Class

[@SimonSezIT]

✅ Download the free course files to follow along ➡www.simonsezit.com/excel-2021-intermediate-courseexercise-files/ 🔥Check out our FREE 300+ hour training course playlist here 👉kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀Level up your Microsoft Excel skill set with this free playlist 👉kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@mohsinawan3594]

This requires login to the site. Can you please provide a working link. TIA

[@zhangmr7955]

Sir, the example of 04-01-vlookup worksheet is missing, cannot follow. Please revise it. Thanks.

[@hazemali382]

more than great

[@shirlyliu8334]

The link does not email me the follow along files. Please advise. Thank you!

[@justhere9399]

1:21:42 exercise 1 2:30:37 exercise 2 3:17:56 exercise 3 4:04:06 exercise 4 Wooo i finished in 9 days 🎉🎉

[@philipaniche2451]

Her voice is so reassuring, navigating even the most complex concepts with grace and dexterity

[@maytesmart]

OMG, she is such a brilliant instructor that I could gladly learn physics if she taught it. Simply extraordinary!

[@SimonSezIT]

Thank you so much for the kind words. 🤩 Keep up the awesome work, and keep learning!

[@cannonzhou]

This is by far the most comprehensive and easiest to follow tutorials I have had. I picked up many useful tips. thanks Deb!

[@SimonSezIT]

Thank you! 😊 If you haven't already seen it, 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

[@edwardholyk7046]

How lucky I’m to find a genuine Tutor spending her precious time to offer tuition free course that everyone who need to excel in their career would take. Special thanks, I can’t wait to subscribe, like and share.

[@SimonSezIT]

Wow, thank you! :-)

[@peterkovacevic3255]

Your exercises are transparent, clear, and extremely interesting. In every lesson I found something new. Thank you for your efforts.

[@TheMsimpson1]

Absolutely by far the best presentation on Excel I’ve seen.

[@SimonSezIT]

Your feedback means a lot! I appreciate your support. 🤩

[@Metal_seer]

Thanks for a great course. I am using it as a refresher, since I haven't used Excel in 25 years.

[@SimonSezIT]

Glad you enjoyed it! Thanks very much for your support :-)

[@darrenjones1983]

Undoubtedly the best Microsoft Excel course I've ever done; and I've completed several...... Amazing work!

[@SimonSezIT]

Wow, thanks!

[@changchuntang1106]

I have watched all way through xlookup and index/match... so far so good....hope Simon Sez could provide more practice sheets to work with.

[@arnmt4]

This class is well done and is helping me with some sorting issues I had.

[@SimonSezIT]

Glad it helped. Thanks for watching!

[@yasir9909]

Ma'am your video tutorials are really amazing and very effective in learning Excel 👍Keep up the good work 👍

[@SimonSezIT]

Thanks a lot

[@changchuntang1106]

Great resources. helpful...I have been watching this series for two weeks....

[@The_Financial_Physician]

4:20:00 Removing blank row through Ctr+G and deleting Sheet Rows is effective only in case the complete row is blank in case in a row only single cell is blank still it deletes the whole row.

[@Reallifejourney388]

Thank you for your time care and videos. Muchly appreciated! Truly is. Thank you again.

[@SimonSezIT]

I'm grateful for your kind words and support! Thanks for watching 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@officepro2.0]

Thanke you for you excel clases....congratulations your channel is very good for learn

[@user-vb2vb1vs5i]

Thank you very much.. I learned more things about excel and this is the good tutorial for beginners ❤

[@SimonSezIT]

Thank you so much for your kind words! We're glad you found the tutorial helpful and that you were able to learn more about Excel. Keep practicing and you'll become an Excel pro in no time! 🔥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!

[@FayeFryer]

Just over 3 hours into the video. What an absolute belter of a tutorial! I did a couple ECDL courses back a while ago (2014/2015) but work-wise I haven't been using the more advanced features as they haven't been relevant to my role (although I do have an interview coming up where I need to show competence). I wanted to brush up and learn more of the new additions there have been to Excel that have passed me by and this course has been a revelation so far. Definitely one to re-visit time and time again to keep it fresh in my mind. I'm truly grateful as I've no spare funds for a paid course right now and most of my old coursework is a bit outdated / the publisher whose practice files were online appears to be no longer trading, so I've been in a bit of a panic trying to find something intuitive and practical (and safe security wise) to help me out! THANK YOU!

[@SimonSezIT]

Many thanks Faye :-) We have plenty of additional free training you are welcome to watch. 🔥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

[@junniorbundor1913]

Hey Deb! Thanks very much for the course. Can't tell that much, but your courses are awsome and comprehensive.

[@SimonSezIT]

You're very welcome! Thanks for watching and taking the time to leave a positive comment :-)

[@shabchique7149]

Thank you so much!

[@SimonSezIT]

You're welcome!

[@esthersuh3388]

I love this lecture and am really thankful for the hard work Ms. Deb Ashby put into for this excellent lecture. Thank you trillions!!!!!

[@SimonSezIT]

Glad it was helpful, Esther! Thanks for the nice comments 😊

[@daveh4208]

I really liked the section on how to jump from one worksheet to another with buttons or icons or text. One thing I've found useful where I sometimes have to jump from one worksheet to another and then back again is that on the sheet I jump to, I create a button there that allows me to jump back. So, in your example I would have a jump button on the sales worksheet that would take me to the analysis worksheet. Then on the analysis worksheet I would create a jump button that takes me back to the sales worksheet. I've been in worksheets before where they have created buttons to take me one way, but then I have to figure out on my own how to get back.

[@alexandravanson2366]

very, very helpful! Thank you soo much!

[@SimonSezIT]

Wow, thanks! Glad it was helpful. 🤩

[@hamz__zzz]

Thanks Deb!

[@SimonSezIT]

You are so welcome!

[@kimbleleauanae997]

thank you so much for this tutorial. really enjoyed it and it is very engaging because you keep it so simple. thank you :)

[@SimonSezIT]

Glad we could help!

[@revolutionarydefeatism]

3:46:43 In the Middle East Friday is the weekend, not Sunday and Monday!

[@hazemmelliti6183]

you are doing a really good job ! thank you for sharing the knowledge

[@SimonSezIT]

Thanks Hazam! The advanced course is coming soon to the channel :-)

[@revolutionarydefeatism]

in 2:39:46 the explanation is not accurate, we just sorted based on the last name! The reason that "East Sussex" on row 6 comes before "London" on row 7 is not that `E` comes before `L`, but because `M` (in "Chambers") comes before `P`( in "Chapel"). The explanation was right if both last names were exactly the same! We can check this by changing "Chambers" to, say, "Chaze" and then "East Sussex" would come after "London"!

[@tastein000]

Just a quick comment, love the courses. On the offset section, couldn't really see the change when you changed your range to a table, because you still had the range of the cells in the formula to the extended range.

[@user-tz5sn1ed8l]

Have to say this was a brilliant course for those wanting to refresh their Excel skills and get extra tips and tricks for everyday use. Managed to watch the whole thing without losing interest, was very well explained throughout and super useful . thank you very much

[@SimonSezIT]

We are glad you enjoyed it. Here's the advanced course if you need it -> kzbin.info/www/bejne/hp2zmIyFe6-Fhas

[@melandribrits6728]

Loving your videos, thoroughly explained! Even beginners will be able to understand these advance courses! Knew about IF and AND functions, but never really understood how to use them. Now I can start incorporating it into my work. Thanks Deb and Team.

[@SimonSezIT]

Glad you like them!

[@tiffanyhht]

I really thanks for your generosity, a great tutorial 👍

[@SimonSezIT]

Our pleasure 😊

[@amalia940]

so ridiculously grateful. amazing. thank you. if at all possible in future please also mention apple shortcuts versions? thanks so much!

[@SimonSezIT]

Thank you Alia! We'll see what we can do. You can also check out our Excel tutorial for Mac here where we discuss some mouse and trackpad features: kzbin.info/www/bejne/fovafGqLrreHock

[@amalia940]

@@SimonSezIT i had no idea, thank you so much will do! this is awesome

[@sajidahmed1383]

This is a very informative video. I really loved it!!

[@SimonSezIT]

Glad you liked it! 😊

[@favourben1427]

Excellent teaching

[@benosborne413]

Excellent training. Where can I find all Excel 365 functions/formulas with a short explanation of each?

[@shabchique7149]

Thanks!

[@SimonSezIT]

Wow, thank you very much for your support!!

[@priyankachourasiya9712]

Thank you so much for give this video and I am so lucky i found your channel ☺️☺️

[@SimonSezIT]

You're welcome, Priyanka Chourasiya 😊

[@marvintampoc3296]

New sub here. Thank you very much. This is very helpful. More power

[@youtubehero4442]

Awesome youtube channel

[@SimonSezIT]

Thanks for watching and leaving a positive feedback! 🙂 Check out our FREE 300+ hour training course playlist here ➡️ 🔥kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 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!

[@ahnafruhullah7134]

Can't thank you enough, @Simon and Deb

[@SimonSezIT]

You are welcome, and thank you for the nice comments. 🙂 We have additional videos to 🚀 boost your Excel knowledge 👉🏼 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉🏼 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉🏼kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

[@essieesterhuizen7049]

Great work!! Thanks Deb.

[@SimonSezIT]

You are so welcome!

[@omarmahmoudehabliethy8401]

Very Interesting course content !

[@SimonSezIT]

Glad you liked it

[@umbertocompagnone1421]

Very well explained , amazing!!!

[@SimonSezIT]

Much appreciated! 😊

[@KoenRoyackers]

Hi, great course, but one tiny thing. At 5:09:41 (logical statement the statement has to be "Expenses over or equal to the following amount must be approved".

[@SimonSezIT]

Thanks for pointing that out :-)

[@user-ni2hr6wl6l]

Loving this course! However, my download did not include any files past exercise 6. Nothing for "importing data into Excel" at about 4:08:00 onwards. Where can I find them?

[@BOGDES83]

Thank You! 🙏

[@SimonSezIT]

Thanks for watching. 😊 🚀 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!

[@prestonorrick3498]

3:59 I think you can just right click and get that menu, so it's not really secret.

[@hinamughal9056]

really appreciable ...thank u v much❤❤❤❤❤❤❤❤

[@SimonSezIT]

Most welcome 😊 Thanks for the ❤

[@engphal9754]

I like your lessons

[@SimonSezIT]

Thank you!😊 We have lots of additional free Excel training here if you need it 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

[@bambina5604]

04:20:00 I had to select the whole table and then use "Go to special" to select and delete rows. Without selecting it the "Delete Sheet Rows" option was greyed out even though the rows were selected.

[@AllenBennett-vp6gd]

How do I make the data validation source the entire column excluding the heading row, so I don't have to go to row one million+?

[@tarek.grisha]

Thank you

[@SimonSezIT]

You are very welcome 🙂

[@BOGDES83]

You kinda need to specify, comma doesn't work but semicolon

[@TonyaBrewton]

@SimonSezIT the Go To Special dialog box is not available in Excel 365 (online version). Since this is the case, how do we access the selections in Go To Special dialog box if it doesn't exist in the online version of Excel? Is there a work-around?

[@yasir9909]

Ma'am, do you also have any advanced video tutorials on Excel that involve some programming like using Python or MATLAB with Excel?

[@SimonSezIT]

We do have advanced Excel tutorial and Python tutorial separately, but not on using them together. Python playlist: kzbin.info/aero/PLzj7TwUeMQ3j4j3k3BuCXq6Dvhv-LlXux Excel 2021 Advanced course: kzbin.info/www/bejne/hp2zmIyFe6-Fhas

[@selvanaiyadurai8967]

Thank you so much for this incredible masterpiece work! Very useful.

[@SimonSezIT]

You're very welcome! Thanks for watching!

[@Sajad_2015]

Hello,I did the Controling Date Inpot method but just about the Names option was done. Salery and Input are not done. Where is the error and at the same time about the options ? tnx

[@nishanhamal8302]

In Mac which key button should we click instead of F3 for Vlookup exact or approx? It would be so much help if anyone could please answer my question.

[@SimonSezIT]

On a Mac, you can use the Function (fn) + F3 keys to achieve the same result as the F3 key on Windows.

[@a22258461]

Omg this is super helpful

[@SimonSezIT]

Glad you think so!

[@user-wt8ou4ve5u]

Cannot find the corresponding worksheets for following the instructor files!!!! Help?

[@ellywang5457]

it seems this 5 hours is not a complete course for intermediate level, anyone knows where is PV table to what if analysis part is

[@MagdalenaKulikowska-i6y]

for me the exercise instructions and exercises are not clear even after watching all that videos. even sometimes the video screen is not visible properly to see what instructor is dooing

[@SimonSezIT]

Thank you for the feedback on our older content. We hope our recent release here will be useful for you to learn. ➡️ Microsoft Excel 365 Intermediate Training: kzbin.info/www/bejne/fnW8in-sZslse5Y

[@debbyroseanalytics]

Magical 💚

[@boonlerthc6882]

You are gorgeous. I will keep in touch throughout your channel

[@SimonSezIT]

Thank you so much 🤗 The advanced course is here if you need additional training -> kzbin.info/www/bejne/hp2zmIyFe6-Fhas

[@charislove988]

Thank you so much for the training.Please do I need to install excel in my MAC before the training?If yes,how do I proceed please.Thank you.

[@SimonSezIT]

Hi Charis: having Excel installed is not a requirement but suggested since you can practice was is taught. The course is taught on a PC, so slight differences may be in the interface.

[@Sofiii85]

What could be the reason for CTRL + K not working? It does nothing when I want to create a link. 🤔

[@-PE53]

Just guessing, but is your excel in another language? Alternatively type "link" or "create link" in the search box at the very top of the window and the function may automatically come out.

[@CM-sb3yt]

All that is downloaded are Word files. I assume they are for a different course.

[@fahadjamshed7129]

Hello I didn't get the practice files link on email please help me out

[@variancewithin]

1:35:00 what if we dont know what the column is? or need to find the column based on some criteria?

[@natalieharrison5202]

Can you use indrect with a match to match a month column you want to total?

[@MattEversmann905]

1:48:58 if I don't type "False" and let the default exact option work, it comes out only "PG" instead of "PG_ 13" why?

[@yennifercabrera3816]

Hi everyone I WANT TO KNOW WHAT WORKS FOR ALL OF YOU TO GAIN THE KNOWLEDGE FAST AND BE READY for THE JOB? I know practice but this training doesn't show all of the practice file, and is a lot of hours of tutoring?

[@thecamssicle]

I tried downloading the files but my antivirus says there's malicious content in it. Do you have a copy where this wouldn't happen? Just to be safe.

[@SimonSezIT]

Please click the link below to download the exercise and instructor files to follow along with our instructor: ✅ Download here 👉 www.simonsezit.com/excel-2021-intermediate-courseexercise-files/ Rest assured that the link provided for downloading the files is completely free from viruses. Check out our FREE 300+ hour training course playlist here ➡️ 🔥kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 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!

[@reemsharaf1577]

Hello, I have a problem with the index function When I put the formula =INDIRECT("''R15C''&COUNTA(15:15)",FALSE) it gives me REF

[@-PE53]

I may be late but try without so many quote marks: =INDIRECT(''R15C''&COUNTA(15:15);FALSE)

[@kimnmyka]

unable to download course files. I am using 2021 with 365

[@darkhierophant4914]

me too. I guess I won't be using these videos anymore.

[@junniorbundor1913]

Try disabling your Adblocker. I did so and it worked perfectly

[@angiepresh8755]

I’m using office 365 and I’m able to download the files…

[@Piyushrahi]

What year office suite you are using means shit. Excel file is sent in email

[@sandrastyles3464]

Exellent course but files are still not available to downloaad. Such a shame. All that is returned is a email containing adverts no link io the files.

[@SimonSezIT]

Hi Sandra, once you confirm your email through the confirmation link sent to you, you should get a 2nd email containing the download link for the files.

[@Cookingandtravelingwithlilly]

Where can I find a tutorial about pivot charts/tables?

[@SimonSezIT]

Pivot Table training is here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

[@ahteshamulhaq3381]

Can I get this video offline for revision /practice purpose for personal use

[@SimonSezIT]

You'll need to get KZbin Premium, which allows for video downloads.

[@amysmith8103]

I've tried to download the free exercises and all I get is cannot open in protective view.

[@SimonSezIT]

Hi! You can click on "Enable Editing" if the file opens in Protected View.

[@lilianugoagha9724]

i can not seem to download the files. saying something about an IP address

[@SimonSezIT]

Please try this link simonsezit.lpages.co/excel-2021-intermediate-courseexercise-files/ If the issue continues, try clearing your browser cache or try another web browser. Thanks.

[@umbertocompagnone1421]

Hi , i don't receive the exercise files :(

[@SimonSezIT]

Sorry to learn that. Please check your Spam/Junk folder.

[@staceycollins3011]

Seems like a useful course. I can't stand the woman's voice though so could only manage 5 minutes....