✅ 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 👉ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀Level up your Microsoft Excel skill set with this free playlist 👉ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
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.
Thank you! 😊 If you haven't already seen it, additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
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.
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!
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 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
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.
I'm grateful for your kind words and support! Thanks for watching 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
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
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 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
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.
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: ua-cam.com/video/HZwK7UyRTkg/v-deo.html
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"!
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.
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?
You are welcome, and thank you for the nice comments. 🙂 We have additional videos to 🚀 boost your Excel knowledge 👉🏼 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉🏼 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉🏼ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thanks for watching. 😊 🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
Thank you!😊 We have lots of additional free Excel training here if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thanks for watching and leaving a positive feedback! 🙂 Check out our FREE 300+ hour training course playlist here ➡️ 🔥ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
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".
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
@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?
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.
We do have advanced Excel tutorial and Python tutorial separately, but not on using them together. Python playlist: ua-cam.com/play/PLzj7TwUeMQ3j4j3k3BuCXq6Dvhv-LlXux.html Excel 2021 Advanced course: ua-cam.com/video/PlPgYOFJROI/v-deo.html
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.
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.
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.
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 ➡️ 🔥ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! UA-cam Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining ♥️ We appreciate your support!
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.
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?
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
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: ua-cam.com/video/HDYYLv1d9E4/v-deo.html
✅ 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 👉ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀Level up your Microsoft Excel skill set with this free playlist 👉ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
This requires login to the site. Can you please provide a working link. TIA
Sir, the example of 04-01-vlookup worksheet is missing, cannot follow. Please revise it. Thanks.
more than great
The link does not email me the follow along files. Please advise. Thank you!
Her voice is so reassuring, navigating even the most complex concepts with grace and dexterity
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 🎉🎉
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.
Wow, thank you! :-)
Your exercises are transparent, clear, and extremely interesting. In every lesson I found something new. Thank you for your efforts.
OMG, she is such a brilliant instructor that I could gladly learn physics if she taught it. Simply extraordinary!
Thank you so much for the kind words. 🤩 Keep up the awesome work, and keep learning!
This is by far the most comprehensive and easiest to follow tutorials I have had. I picked up many useful tips. thanks Deb!
Thank you! 😊 If you haven't already seen it, additional free Excel training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thanks for a great course. I am using it as a refresher, since I haven't used Excel in 25 years.
Glad you enjoyed it! Thanks very much for your support :-)
Undoubtedly the best Microsoft Excel course I've ever done; and I've completed several...... Amazing work!
Wow, thanks!
Absolutely by far the best presentation on Excel I’ve seen.
Your feedback means a lot! I appreciate your support. 🤩
Thank you so much Derby, learnt a lot. You explain so well and clearly. I'm sure you know that by now. God bless you!
Really glad to hear that you found the content helpful! Your support means a lot 😊
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.
Great resources. helpful...I have been watching this series for two weeks....
This class is well done and is helping me with some sorting issues I had.
Glad it helped. Thanks for watching!
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!
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 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
1:39:47 This is where I am now, do remind me to come back and continue the class.
Ma'am your video tutorials are really amazing and very effective in learning Excel 👍Keep up the good work 👍
Thanks a lot
Thanke you for you excel clases....congratulations your channel is very good for learn
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.
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.
I love this lecture and am really thankful for the hard work Ms. Deb Ashby put into for this excellent lecture. Thank you trillions!!!!!
Glad it was helpful, Esther! Thanks for the nice comments 😊
Thank you for your time care and videos. Muchly appreciated! Truly is. Thank you again.
I'm grateful for your kind words and support! Thanks for watching 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
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
We are glad you enjoyed it. Here's the advanced course if you need it -> ua-cam.com/video/PlPgYOFJROI/v-deo.html
Thank you very much.. I learned more things about excel and this is the good tutorial for beginners ❤
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 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Hey Deb! Thanks very much for the course. Can't tell that much, but your courses are awsome and comprehensive.
You're very welcome! Thanks for watching and taking the time to leave a positive comment :-)
thank you so much for this tutorial. really enjoyed it and it is very engaging because you keep it so simple. thank you :)
Glad we could help!
Excellent teaching
you are doing a really good job ! thank you for sharing the knowledge
Thanks Hazam! The advanced course is coming soon to the channel :-)
I really thanks for your generosity, a great tutorial 👍
Our pleasure 😊
3:46:43 In the Middle East Friday is the weekend, not Sunday and Monday!
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.
very, very helpful! Thank you soo much!
Wow, thanks! Glad it was helpful. 🤩
This is a very informative video. I really loved it!!
Glad you liked it! 😊
so ridiculously grateful. amazing. thank you. if at all possible in future please also mention apple shortcuts versions? thanks so much!
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: ua-cam.com/video/HZwK7UyRTkg/v-deo.html
@@SimonSezIT i had no idea, thank you so much will do! this is awesome
New sub here. Thank you very much. This is very helpful. More power
Thank you so much for give this video and I am so lucky i found your channel ☺️☺️
You're welcome, Priyanka Chourasiya 😊
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"!
Very Interesting course content !
Glad you liked it
Great work!! Thanks Deb.
You are so welcome!
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.
Glad you like them!
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?
Thank you so much!
You're welcome!
Thanks Deb!
You are so welcome!
Can't thank you enough, @Simon and Deb
You are welcome, and thank you for the nice comments. 🙂 We have additional videos to 🚀 boost your Excel knowledge 👉🏼
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
& here 👉🏼 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉🏼ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Very well explained , amazing!!!
Much appreciated! 😊
Thank You! 🙏
Thanks for watching. 😊
🚀 Level up your Excel skills with free training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
I like your lessons
Thank you!😊 We have lots of additional free Excel training here if you need it 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html
& Pivot Table training here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Thanks!
Wow, thank you very much for your support!!
really appreciable ...thank u v much❤❤❤❤❤❤❤❤
Most welcome 😊 Thanks for the ❤
Awesome youtube channel
Thanks for watching and leaving a positive feedback! 🙂
Check out our FREE 300+ hour training course playlist here ➡️
🔥ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
Excellent training. Where can I find all Excel 365 functions/formulas with a short explanation of each?
3:59 I think you can just right click and get that menu, so it's not really secret.
Thank you
You are very welcome 🙂
Magical 💚
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".
Thanks for pointing that out :-)
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+?
Cannot find the corresponding worksheets for following the instructor files!!!! Help?
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
@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?
Thank you so much for this incredible masterpiece work! Very useful.
You're very welcome! Thanks for watching!
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.
1:35:00 what if we dont know what the column is? or need to find the column based on some criteria?
Hello I didn't get the practice files link on email please help me out
You kinda need to specify, comma doesn't work but semicolon
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?
Can you use indrect with a match to match a month column you want to total?
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.
On a Mac, you can use the Function (fn) + F3 keys to achieve the same result as the F3 key on Windows.
Omg this is super helpful
Glad you think so!
Ma'am, do you also have any advanced video tutorials on Excel that involve some programming like using Python or MATLAB with Excel?
We do have advanced Excel tutorial and Python tutorial separately, but not on using them together.
Python playlist:
ua-cam.com/play/PLzj7TwUeMQ3j4j3k3BuCXq6Dvhv-LlXux.html
Excel 2021 Advanced course:
ua-cam.com/video/PlPgYOFJROI/v-deo.html
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
What could be the reason for CTRL + K not working? It does nothing when I want to create a link. 🤔
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.
Where can I find a tutorial about pivot charts/tables?
Pivot Table training is here 👉 ua-cam.com/play/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u.html
Hello, I have a problem with the index function
When I put the formula =INDIRECT("''R15C''&COUNTA(15:15)",FALSE) it gives me REF
I may be late but try without so many quote marks: =INDIRECT(''R15C''&COUNTA(15:15);FALSE)
unable to download course files. I am using 2021 with 365
me too. I guess I won't be using these videos anymore.
Try disabling your Adblocker. I did so and it worked perfectly
I’m using office 365 and I’m able to download the files…
What year office suite you are using means shit. Excel file is sent in email
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.
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.
You are gorgeous. I will keep in touch throughout your channel
Thank you so much 🤗 The advanced course is here if you need additional training -> ua-cam.com/video/PlPgYOFJROI/v-deo.html
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.
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.
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.
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 ➡️
🔥ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
UA-cam Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ua-cam.com/users/simonsezittraining
♥️ We appreciate your support!
i can not seem to download the files. saying something about an IP address
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.
All that is downloaded are Word files. I assume they are for a different course.
I've tried to download the free exercises and all I get is cannot open in protective view.
Hi! You can click on "Enable Editing" if the file opens in Protected View.
Can I get this video offline for revision /practice purpose for personal use
You'll need to get UA-cam Premium, which allows for video downloads.
Hi , i don't receive the exercise files :(
Sorry to learn that. Please check your Spam/Junk folder.
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?
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
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: ua-cam.com/video/HDYYLv1d9E4/v-deo.html
Seems like a useful course. I can't stand the woman's voice though so could only manage 5 minutes....