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

  Рет қаралды 231,311

Simon Sez IT

Simon Sez IT

Күн бұрын

✅ Download to follow along and complete the exercises
➡️ www.simonsezit.com/excel-2021...
In this Excel 2021 Intermediate training course, you will build on your beginner-level Excel knowledge and expand your skills. We'll go over Excel logical functions such as IF, COUNTIF, and SUMIF and Excel lookup functions like VLOOKUP, HLOOKUP, INDEX, and MATCH. We will also discuss various other Excel formulas such as UNIQUE, CONCAT, and so much more!
You will also learn how to use advanced filters, sort columns and lists, use custom date formats, remove duplicate entries, split and combine data, and many other Excel tips and tricks. After this training video, you will have a solid foundation for using Excel 2021/Excel 365, as part of the Office 2021 suite of applications.
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 Microsoft Excel 2021/365 Tutorial.
✅ 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:06:38 - Improve Readability with Cell Styles
0:11:37 - Controlling Data Input
0:19:57 - Adding Navigation Buttons
0:28:43 - Logical Functions
0:42:02 - The IF Function
0:47:28 - Nested IFs
0:55:30 - The IFs Function
1:01:35 - Conditional IFs
1:08:20 - Multiple Criteria
1:15:33 - Error Handling
1:21:34 - Exercise 01
1:29:04 - VLOOKUP (Exact Match)
1:39:44 - VLOOKUP (Approximate Match)
1:44:10 - HLOOKUP Function
1:49:49 - INDEX and MATCH
2:00:16 - XLookup and XMatch
2:10:26 - OFFSET Function
2:21:17 - INDIRECT Function
2:30:24 - Exercise 02
2:35:26 - Sorting on Multiple Columns
2:42:31 - Sorting Using a Custom List
2:46:07 - SORT and SORTBY Functions
2:56:07 - Advanced Filter
3:02:59 - UNIQUE Function
3:08:16 - FILTER Function
3:17:48 - Exercise 03
3:23:29 - How Dates and Times are Stored
3:27:39 - Custom Date and Time Formats
3:34:49 - Time and Date Functions
3:43:33 - WORKDAY and WORKDAY.INT Functions
3:47:22 - NETWORKDAYS and NETWORKDAYS.INT Functions
3:50:20 - DATEDIF Function
3:56:33 - EDATE and EOMONTH Functions
4:03:55 - Exercise 04
4:08:51 - Importing Data into Excel
4:18:46 - Removing Blank Rows, Cells, and Duplicate Entries
4:24:07 - Changing Case and Removing Spaces
4:33:12 - Splitting Up Data Using Text to Columns
4:40:15 - Splitting Up Data Using Text Functions
4:48:22 - Using Flash Fill
4:53:21 - CONCAT Function
5:00:50 - Formatting Data as Table
🌍 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 Beginner to Advance Excel Training 👉 • How to Get Started in ...
✅How to Use Pivot Tables in Excel video playlist 👉 • How to Use Pivot Table...
✅ Microsoft Excel 30 Tips and Tricks here 👉 • Microsoft Excel Tips a...
✅ Microsoft Office 2021 and Office 365 playlist here 👉 • Microsoft Access Tutor...
🔥Check out our FREE 300+ hour training course playlist here ➡️
• Simon Sez IT Long Trai...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it
FaceBook: / simonsezit
🔔 Subscribe to our channel:
kzbin.info...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

Пікірлер: 142
@SimonSezIT
@SimonSezIT 2 жыл бұрын
✅ 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
@mohsinawan3594 2 жыл бұрын
This requires login to the site. Can you please provide a working link. TIA
@zhangmr7955
@zhangmr7955 2 жыл бұрын
Sir, the example of 04-01-vlookup worksheet is missing, cannot follow. Please revise it. Thanks.
@hazemali382
@hazemali382 Жыл бұрын
more than great
@shirlyliu8334
@shirlyliu8334 Жыл бұрын
The link does not email me the follow along files. Please advise. Thank you!
@philipaniche2451
@philipaniche2451 Жыл бұрын
Her voice is so reassuring, navigating even the most complex concepts with grace and dexterity
@cannonzhou
@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
@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
@peterkovacevic3255
@peterkovacevic3255 Жыл бұрын
Your exercises are transparent, clear, and extremely interesting. In every lesson I found something new. Thank you for your efforts.
@maytesmart
@maytesmart 27 күн бұрын
OMG, she is such a brilliant instructor that I could gladly learn physics if she taught it. Simply extraordinary!
@SimonSezIT
@SimonSezIT 26 күн бұрын
Thank you so much for the kind words. 🤩 Keep up the awesome work, and keep learning!
@justhere9399
@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 🎉🎉
@changchuntang1106
@changchuntang1106 Жыл бұрын
Great resources. helpful...I have been watching this series for two weeks....
@arnmt4
@arnmt4 2 жыл бұрын
This class is well done and is helping me with some sorting issues I had.
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Glad it helped. Thanks for watching!
@edwardholyk7046
@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
@SimonSezIT Жыл бұрын
Wow, thank you! :-)
@junniorbundor1913
@junniorbundor1913 2 жыл бұрын
Hey Deb! Thanks very much for the course. Can't tell that much, but your courses are awsome and comprehensive.
@SimonSezIT
@SimonSezIT 2 жыл бұрын
You're very welcome! Thanks for watching and taking the time to leave a positive comment :-)
@hazemmelliti6183
@hazemmelliti6183 2 жыл бұрын
you are doing a really good job ! thank you for sharing the knowledge
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Thanks Hazam! The advanced course is coming soon to the channel :-)
@changchuntang1106
@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.
@esthersuh3388
@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
@SimonSezIT Жыл бұрын
Glad it was helpful, Esther! Thanks for the nice comments 😊
@tastein000
@tastein000 2 жыл бұрын
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.
@daveh4208
@daveh4208 2 жыл бұрын
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.
@officepro2
@officepro2 Жыл бұрын
Thanke you for you excel clases....congratulations your channel is very good for learn
@kimbleleauanae997
@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
@SimonSezIT Жыл бұрын
Glad we could help!
@darrenjones1983
@darrenjones1983 7 ай бұрын
Undoubtedly the best Microsoft Excel course I've ever done; and I've completed several...... Amazing work!
@SimonSezIT
@SimonSezIT 7 ай бұрын
Wow, thanks!
@The_Financial_Physician
@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.
@TheMsimpson1
@TheMsimpson1 Ай бұрын
Absolutely by far the best presentation on Excel I’ve seen.
@SimonSezIT
@SimonSezIT Ай бұрын
Your feedback means a lot! I appreciate your support. 🤩
@Reallifejourney388
@Reallifejourney388 5 ай бұрын
Thank you for your time care and videos. Muchly appreciated! Truly is. Thank you again.
@SimonSezIT
@SimonSezIT 5 ай бұрын
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
@Metal_seer
@Metal_seer 4 ай бұрын
Thanks for a great course. I am using it as a refresher, since I haven't used Excel in 25 years.
@SimonSezIT
@SimonSezIT 4 ай бұрын
Glad you enjoyed it! Thanks very much for your support :-)
@marvintampoc3296
@marvintampoc3296 Жыл бұрын
New sub here. Thank you very much. This is very helpful. More power
@umbertocompagnone1421
@umbertocompagnone1421 Жыл бұрын
Very well explained , amazing!!!
@SimonSezIT
@SimonSezIT Жыл бұрын
Much appreciated! 😊
@favourben1427
@favourben1427 Жыл бұрын
Excellent teaching
@tiffanyhht
@tiffanyhht Жыл бұрын
I really thanks for your generosity, a great tutorial 👍
@SimonSezIT
@SimonSezIT Жыл бұрын
Our pleasure 😊
@essieesterhuizen7049
@essieesterhuizen7049 Жыл бұрын
Great work!! Thanks Deb.
@SimonSezIT
@SimonSezIT Жыл бұрын
You are so welcome!
@yasir9909
@yasir9909 11 ай бұрын
Ma'am your video tutorials are really amazing and very effective in learning Excel 👍Keep up the good work 👍
@SimonSezIT
@SimonSezIT 11 ай бұрын
Thanks a lot
@FayeFryer
@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
@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
@priyankachourasiya9712
@priyankachourasiya9712 Жыл бұрын
Thank you so much for give this video and I am so lucky i found your channel ☺️☺️
@SimonSezIT
@SimonSezIT Жыл бұрын
You're welcome, Priyanka Chourasiya 😊
@sajidahmed1383
@sajidahmed1383 Жыл бұрын
This is a very informative video. I really loved it!!
@SimonSezIT
@SimonSezIT Жыл бұрын
Glad you liked it! 😊
@user-vb2vb1vs5i
@user-vb2vb1vs5i 8 ай бұрын
Thank you very much.. I learned more things about excel and this is the good tutorial for beginners ❤
@SimonSezIT
@SimonSezIT 8 ай бұрын
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!
@hinamughal9056
@hinamughal9056 Жыл бұрын
really appreciable ...thank u v much❤❤❤❤❤❤❤❤
@SimonSezIT
@SimonSezIT Жыл бұрын
Most welcome 😊 Thanks for the ❤
@revolutionarydefeatism
@revolutionarydefeatism 3 ай бұрын
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"!
@a22258461
@a22258461 2 жыл бұрын
Omg this is super helpful
@SimonSezIT
@SimonSezIT 2 жыл бұрын
Glad you think so!
@revolutionarydefeatism
@revolutionarydefeatism 3 ай бұрын
3:46:43 In the Middle East Friday is the weekend, not Sunday and Monday!
@alexandravanson2366
@alexandravanson2366 3 ай бұрын
very, very helpful! Thank you soo much!
@SimonSezIT
@SimonSezIT 3 ай бұрын
Wow, thanks! Glad it was helpful. 🤩
@shabchique7149
@shabchique7149 3 ай бұрын
Thank you so much!
@SimonSezIT
@SimonSezIT 3 ай бұрын
You're welcome!
@user-tz5sn1ed8l
@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
@SimonSezIT Жыл бұрын
We are glad you enjoyed it. Here's the advanced course if you need it -> kzbin.info/www/bejne/hp2zmIyFe6-Fhas
@debbyroseanalytics
@debbyroseanalytics Жыл бұрын
Magical 💚
@hamz__zzz
@hamz__zzz 2 ай бұрын
Thanks Deb!
@SimonSezIT
@SimonSezIT 2 ай бұрын
You are so welcome!
@amalia940
@amalia940 Жыл бұрын
so ridiculously grateful. amazing. thank you. if at all possible in future please also mention apple shortcuts versions? thanks so much!
@SimonSezIT
@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
@amalia940 Жыл бұрын
@@SimonSezIT i had no idea, thank you so much will do! this is awesome
@BOGDES83
@BOGDES83 7 ай бұрын
Thank You! 🙏
@SimonSezIT
@SimonSezIT 7 ай бұрын
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!
@selvanaiyadurai8967
@selvanaiyadurai8967 Жыл бұрын
Thank you so much for this incredible masterpiece work! Very useful.
@SimonSezIT
@SimonSezIT Жыл бұрын
You're very welcome! Thanks for watching!
@bambina5604
@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.
@shabchique7149
@shabchique7149 3 ай бұрын
Thanks!
@SimonSezIT
@SimonSezIT 3 ай бұрын
Wow, thank you very much for your support!!
@omarmahmoudehabliethy8401
@omarmahmoudehabliethy8401 10 ай бұрын
Very Interesting course content !
@SimonSezIT
@SimonSezIT 10 ай бұрын
Glad you liked it
@ahnafruhullah7134
@ahnafruhullah7134 Жыл бұрын
Can't thank you enough, @Simon and Deb
@SimonSezIT
@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
@engphal9754
@engphal9754 Жыл бұрын
I like your lessons
@SimonSezIT
@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
@benosborne413
@benosborne413 Ай бұрын
Excellent training. Where can I find all Excel 365 functions/formulas with a short explanation of each?
@tarek.grisha
@tarek.grisha Жыл бұрын
Thank you
@SimonSezIT
@SimonSezIT Жыл бұрын
You are very welcome 🙂
@natalieharrison5202
@natalieharrison5202 Жыл бұрын
Can you use indrect with a match to match a month column you want to total?
@youtubehero4442
@youtubehero4442 7 ай бұрын
Awesome youtube channel
@SimonSezIT
@SimonSezIT 6 ай бұрын
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!
@user-ni2hr6wl6l
@user-ni2hr6wl6l 11 ай бұрын
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?
@charislove988
@charislove988 2 жыл бұрын
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
@SimonSezIT 2 жыл бұрын
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.
@KoenRoyackers
@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
@SimonSezIT Жыл бұрын
Thanks for pointing that out :-)
@prestonorrick3498
@prestonorrick3498 Жыл бұрын
3:59 I think you can just right click and get that menu, so it's not really secret.
@Sajad_2015
@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
@melandribrits6728
@melandribrits6728 11 ай бұрын
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
@SimonSezIT 11 ай бұрын
Glad you like them!
@MattEversmann905
@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?
@variancewithin
@variancewithin Жыл бұрын
1:35:00 what if we dont know what the column is? or need to find the column based on some criteria?
@AllenBennett-vp6gd
@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+?
@TonyaBrewton
@TonyaBrewton 6 ай бұрын
@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?
@CM-sb3yt
@CM-sb3yt 2 жыл бұрын
All that is downloaded are Word files. I assume they are for a different course.
@user-wt8ou4ve5u
@user-wt8ou4ve5u Жыл бұрын
Cannot find the corresponding worksheets for following the instructor files!!!! Help?
@fahadjamshed7129
@fahadjamshed7129 Жыл бұрын
Hello I didn't get the practice files link on email please help me out
@ellywang5457
@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
@yasir9909
@yasir9909 11 ай бұрын
Ma'am, do you also have any advanced video tutorials on Excel that involve some programming like using Python or MATLAB with Excel?
@SimonSezIT
@SimonSezIT 11 ай бұрын
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
@ahteshamulhaq3381
@ahteshamulhaq3381 2 жыл бұрын
Can I get this video offline for revision /practice purpose for personal use
@SimonSezIT
@SimonSezIT 2 жыл бұрын
You'll need to get KZbin Premium, which allows for video downloads.
@BOGDES83
@BOGDES83 6 ай бұрын
You kinda need to specify, comma doesn't work but semicolon
@yennifercabrera3816
@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?
@Cookingandtravelingwithlilly
@Cookingandtravelingwithlilly Жыл бұрын
Where can I find a tutorial about pivot charts/tables?
@SimonSezIT
@SimonSezIT Жыл бұрын
Pivot Table training is here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
@sandrastyles3464
@sandrastyles3464 2 жыл бұрын
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
@SimonSezIT 2 жыл бұрын
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.
@Sofiii85
@Sofiii85 5 ай бұрын
What could be the reason for CTRL + K not working? It does nothing when I want to create a link. 🤔
@-PE53
@-PE53 5 ай бұрын
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.
@lilianugoagha9724
@lilianugoagha9724 2 жыл бұрын
i can not seem to download the files. saying something about an IP address
@SimonSezIT
@SimonSezIT 2 жыл бұрын
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.
@reemsharaf1577
@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
@-PE53 5 ай бұрын
I may be late but try without so many quote marks: =INDIRECT(''R15C''&COUNTA(15:15);FALSE)
@boonlerthc6882
@boonlerthc6882 Жыл бұрын
You are gorgeous. I will keep in touch throughout your channel
@SimonSezIT
@SimonSezIT Жыл бұрын
Thank you so much 🤗 The advanced course is here if you need additional training -> kzbin.info/www/bejne/hp2zmIyFe6-Fhas
@amysmith8103
@amysmith8103 Жыл бұрын
I've tried to download the free exercises and all I get is cannot open in protective view.
@SimonSezIT
@SimonSezIT Жыл бұрын
Hi! You can click on "Enable Editing" if the file opens in Protected View.
@MagdalenaKulikowska-i6y
@MagdalenaKulikowska-i6y 12 күн бұрын
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
@SimonSezIT 10 күн бұрын
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
@thecamssicle
@thecamssicle 10 ай бұрын
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
@SimonSezIT 9 ай бұрын
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!
@kimnmyka
@kimnmyka 2 жыл бұрын
unable to download course files. I am using 2021 with 365
@darkhierophant4914
@darkhierophant4914 2 жыл бұрын
me too. I guess I won't be using these videos anymore.
@junniorbundor1913
@junniorbundor1913 2 жыл бұрын
Try disabling your Adblocker. I did so and it worked perfectly
@angiepresh8755
@angiepresh8755 2 жыл бұрын
I’m using office 365 and I’m able to download the files…
@Piyushrahi
@Piyushrahi Жыл бұрын
What year office suite you are using means shit. Excel file is sent in email
@umbertocompagnone1421
@umbertocompagnone1421 Жыл бұрын
Hi , i don't receive the exercise files :(
@SimonSezIT
@SimonSezIT Жыл бұрын
Sorry to learn that. Please check your Spam/Junk folder.
@staceycollins3011
@staceycollins3011 Жыл бұрын
Seems like a useful course. I can't stand the woman's voice though so could only manage 5 minutes....
Top Excel Formulas - Beginner to Advanced
2:23:28
Simon Sez IT
Рет қаралды 9 М.
50 Ultimate Excel Tips and Tricks for 2020
50:17
Sele Training
Рет қаралды 1,8 МЛН
Fast and Furious: New Zealand 🚗
00:29
How Ridiculous
Рет қаралды 22 МЛН
Pivot Tables Excel: Detailed Beginners Pivot Table Tutorial
2:39:56
Simon Sez IT
Рет қаралды 393 М.
Excel Power Query Course: Power Query Tutorial for Beginners
1:49:28
Simon Sez IT
Рет қаралды 821 М.
Microsoft Excel Intermediate Class: Elevate Your Skills ⬆️ 📈
1:14:35
How to Pass Intermediate Excel Employment Test: Questions and Answers
46:07
Online Training for Everyone
Рет қаралды 246 М.
Microsoft Excel Tutorial: 3-Hour MS Excel 2019 Course for Beginners!
3:03:16
Ноутбук за 20\40\60 тысяч рублей
42:36
Ремонтяш
Рет қаралды 379 М.
Как удвоить напряжение? #электроника #умножитель
1:00
Hi Dev! – Электроника
Рет қаралды 1 МЛН
تجربة أغرب توصيلة شحن ضد القطع تماما
0:56
صدام العزي
Рет қаралды 62 МЛН
ОБСЛУЖИЛИ САМЫЙ ГРЯЗНЫЙ ПК
1:00
VA-PC
Рет қаралды 2,4 МЛН
Kumanda İle Bilgisayarı Yönetmek #shorts
0:29
Osman Kabadayı
Рет қаралды 2 МЛН
Looks very comfortable. #leddisplay #ledscreen #ledwall #eagerled
0:19
LED Screen Factory-EagerLED
Рет қаралды 3,8 МЛН
Здесь упор в процессор
18:02
Рома, Просто Рома
Рет қаралды 420 М.