✅ Download the free exercise files to follow along ➡www.simonsezit.com/excel-2021-beginner-to-advanced-course-files/ 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
hi, IT. May I ask about the datedif function? The age calculation will show minor difference if I use cell (B2- cell D4)/365 and round the number, with the formula datedif? it is because not every year has exactly 365 days....so how to avoid such scenario and get a more precise age number?
We appreciate your feedback. Thanks for watching! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
FORMULAS 1. basic alzebra 2.count,countA(for albhatic also),countBlank(for no of blank blocks) 3. Average 3. min(to find min value in selected range)....MAX 4. CTRL+D to apply full formula to other tables 5. FLASH FILL (fills similar kinda data) can be found under data 6. CNTRL+SHIFT+DOWN ARROW to select full column 7. FORMAT PAINTER (to copy full design) below copy and past 8. DATA VALIDATION (4:22:00) to show list 9. To lock go to review and protect cell 10. CNTRL+K to insert link to any pic or text 11. using gates (IF,AND,OR) 4:45:00 to consider both use AND & t take consider any one use OR 12. NESTED IF [=IF(logic,IF(....))] 4:57:00 13. IFS [=IFS(logic1,logic2,logic3)] 14. SUMIF,COUNTIF,AVERAGEIF (critiria,formula) 5:14:00 SUMIFs,COUNTIFS,AVERAGEIFS(2 or more critiria,formula) 4:17:00 15. IFERROR (is udes to write desiered senetence in error block) 16. VLOOKUP (used to look value in coloums) 5:40:00 2types- approx and exact analysis HLOOKUP (for horizental lookup) 5:55:00 17. INDEX (same like lookup but also from R to left) 6:01:00 MATCH ( to find position of a value like row no ) 6:03:00 18. XLOOKUP ( same as lookup but very simple) 6:09:00 19. CNTRL+T to create a table and we can design table using options in top 20. OFFSET (gets value from rows and coloums from enterent value) 6:19:00 sum of last 6 months values ex - 6:25:00 21. INDIRECT (to entr another cell value) 6:30:00 22. under Data go to SORT to sort based on coloum and text 23. =SORT and SORTBY to sort by any coloum and asendening or desending order 7:02:40 24. UNIQUE to find unique items in repeated items 25. FILTER (to filter list by a value in that list) 7:20:00 26. =TOADY() or CNTRL+; present days date and change by time =NOW() or CNTRL+SHIFT+; to get time which changes 27. DATE and TIME functions 28. WORKDAY and WORKDAY.INTL (to calculate the work to be done by providing strt and end dates) 29. NETWORKDAYS (to find no of days b/w dates) 30. to find birthdays use DATEDIF() 31. EOMONTH to end end of the month dates 32. EDATE to add or sub the no. of months from given date 33. we can sort tables but just assigning some values and sort them asending or descending 34. INDEX can be used to enter data according to row or coloum no 9:20:00 35. RANDARRAY is used to enter random data in blocks 36. XLOOKUP can be used to look at 2 diff scenes 10:37:00 37. =CHOOSE(1,"A","B","C") 10:42:00 1 is A ...... 2 is B..... 3 is C 38. =SWITCH(expression,1,"hi",2,"kk") 10:51:00 1 is hi 39. MEDIAN (middle value) 40. MODE (most occering value) 41. =LARGE (to find 2nd or nth largest value in an arry) same =SMALL 11:11:00 42. RANK (to rank any num values in list) 11:19:00 43. ROUND ( for rounding values ) 11:37:00 44. AGGREGATE (to do arthametic calculations without considering errors or other) 11:46:00
You are very welcome! Glad it was helpful. 🙂 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
BEST TEACHER AND CHANNEL ON RUclips! SUBSCRIBED!! THANK YOU!! 😊 4:10:59 Intermediate starts 7:30:30 Filter and sort 7:36:40 date n time 7:58:30 dateif 8:04:43 loan amortization schedule 8:20:07 dynamic array 8:50:00 sort function 10:41:17 choose function
I just finished my journey with Excel 2021. I am so proud of myself and I can't stop thanking Simon Sez and Deb or this very interesting course. I've learned so many things during the 12 hours course and higher is my satisfaction. Thank you so much for your help!
Hello Deborah and the whole simon sez family, thank u guys very much for this wonderful course. It was learner's centered rather than teacher centered. I just finished it. What a lovely style of teaching.
I've just completed this 12-hour video, super useful and comprehensible (I played 1.5x speed bc it's a little slow to me). Literally recommend it for anyone who wanna gain a solid grounding in Excel. Thank you so much for providing us such free precious lessons. I'm really grateful for it❤❤❤
@@SuarezJim Not sure if you just want to self-learn & what your background is but with my certification we qualify for both business analyst & data... And also other positions like Project Managers etc. I've a Black Belt in Lean Six Sigma it may be possibly a route you could consider.
I thought I knew Excel until I started came across this video. It's the most comprehensive Excel tutorial I have ever seen in my 10 using excel. Thank you so much for sharing such a great work.
Thank you for your kind words! I'm glad you found the tutorial helpful. 🙂 🔥If you need more FREE training, please check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
I just completed the course on Excel 365. It was so fun studying Excel,learning new formulas,analysing data, etc. Thank you deborah and simon family for providing the study materials and such a wonderful course . I'm looking forward to learning more about pivot tables in detail.
Congratulations on completing the course! Excel can be so rewarding once you get the hang of it. We have a detailed Pivot Table tutorial here: ruclips.net/video/idgT7Gjf0P0/видео.html
Thank you for the best Excel course, Debs you taught me so much! Excellent tutor, great that you can download files and complete all the exercises, I've learnt more from this 12 hour course than throughout all my years of using Excel. Thank you!
Awesome! So happy to hear that you watched the entire video and practiced all the exercises. You're killing it! Keep up the awesome work and keep learning! 😊 We have additional free Excel training if you need it 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
All along following this lesson, I faced only one problem, and it was this hashtag ######## error. I recently found out that it's not an error, and the following information is from Google: The "hashtag" error, a string of hash or pound characters like ####### is not technically an error, but it looks like one. In most cases it indicates the column width is too narrow to display the value as formatted. And I am in the middle of the lesson now, 3:48:26 this is where I'm stopped at yhe moment. Beautiful teacher, awesome content, incredible teaching method. Wish I had Deb as my IT teacher in my school. May god bless you and the SimonSezIT community for sharing the knowledge with us. Thank you❤
I am writing to thank you for the excellent Excel training that I recently completed on your RUclips channel. I learned so much from your clear and concise explanations, and I am now much more confident in my ability to use Excel. I particularly appreciated the way you took the time to explain the underlying concepts of Excel, as well as the practical applications of these concepts. This made it much easier for me to understand how Excel works and how I can use it to solve real-world problems. Thank you for providing such a valuable resource. I highly recommend your Excel training to anyone who wants to learn how to use this powerful software tool.
Wonderful and helpfully thorough presentation. I learned alot. The British accent was a bonus, as any serious topic spoken with a British accent makes the topic suddenly sound more intellectually sophisticated lol
We're so glad to hear that the course was helpful and that your Excel knowledge has increased! Keep up the great work and keep on learning! 🚀 We have more free Excel training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
I really like the teaching style and lessons from Simon Sez, especially this instructor. I signed up for their Excel Business Analysis course because it had a lot of great worksheets (and others like MS Project, Alteryx, etc,). Just wish they had these instructions when I started out using the different software (I just find it too challenging to learn from books, or web articles, which was my primary learning method years ago).
Great video! By the way, when it comes to PEDMAS/BODMAS, Deb should have mentioned that multiplication and division (as well as subtraction and addition) have the same precedence and it is evaluated from left to right.
Thank you very much for this wonderful course ! I am an advanced Excel user but I watched it all and still learned quite a few things in every section.
Hey, thanks a bunch for the awesome comment! It's great to hear that even as an advanced Excel user, you found value in the course and learned new things. Keep up the good work and keep learning! 🙂 Check out our FREE 300+ hour training course playlist here ➡️ 🔥ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
I noticed an error with the 2 way look up, luckily I was able to solve it by swapping the arguments in the index function. I wonder why it worked In the video though. Because I'm using a lower version of Excel, I was only able to practice the dynamic array functions with Google Sheets, no problem because I still had the course files to upload and learn. Excellent course, Excellent teaching method. Thank you for adding the course resources. This is the best tutorial I've ever taken, I'm now very confident using spreadsheets! I don't comment a lot on RUclips, but I'll be an Ingrate not to show my appreciation to this tutor and this channel. This course is worth a fortune!
I just want to thank you for your selfless efforts.. thanks a lot.. god bless you... Also one thing I want to ask is this everything we have to know about Excel? Or there are something's left?
The eomonth and edate files the last instructor's files in the intermediate level are not included in the free exercise. But so far, so thankful!!! I'm heading now to the advance but I will watch video about eomonth and edate first. I will be back again to say thank you after I finished your whole video tutorial. ❤❤❤
Great Job!! I really enjoyed it! But I want to point in that part 6:47:30 while you mentioned the second sorting will work if we compared two names with the same initial letters -in the first sorting-. But that is actually incorrect, In order to see the difference we must compare two identical names, here we can look to the second sorting to make sure from the result.
Thanks for the kind comments 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
This is such a great resource and it is unbelievable that it is free. Is there a reason the lesson on Golden Rules of Spreadsheet Design is missing? Is it limited to paying subscribers?
Hi. Firstly, thank you so much for this EXCELLENT course. I am learning so much. I am in the last lesson of the Intermediate section: 06-07 calculate dates with edate and eomonth, but the Instructor File for this lesson is not in the download packet.
Thanks for the kind comments 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
Hey, thanks a bunch for your comment! We're thrilled to hear that you're loving the content. It's all about sharing and helping each other out. Keep watching and stay awesome! 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
Your lessons are really wonderful. Thank you so very much. However, under the Randarray assignment where the objective was to generate revenues and profits for the various sales personnel, some profit figures were greater than the corresponding revenues. Is that possible?
Hey, thanks a ton for watching and for the positive feedback! 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Glad you enjoyed it. Thanks for watching 🙂 Check out our FREE 300+ hour training course playlist here 👉 🔥ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
Hello Thanks for this courses, I like the way things are explain . Woud you add charts, powers pivots, working with several worksheets or workbooks? Thanks for all...
You're welcome. We're glad you enjoyed it.😊 🔥Please check out our FREE 300+ hour training course playlist here 👉 ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! RUclips Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► ruclips.net/user/simonsezittraining ♥️ We appreciate your support!
love the video, i had a question though about flash fill can "=find" or "=search" be also used in the same way? Or is it used for a much complex search in a cell.
hi thank you . that 's great. I have a question about DIV/0 error part, : i did not get why you change formula DIV to SUM formula and how did you determine Q2 position ? could you please explain it please.
5:35:07 there is a mistake here, because Debbie Wolf is said to be from *Canadata* and not from Canada. So in the actual sheet the formula seems wrong. But in the next frame you corrected it for the video. My question is - how do we make it search even with a grammatical error?
At hour 10:36 the two way look up function , when you try with index and match it only gives you back the correct answer if it's the same number for the column and for the row . If you have different numbers, it gives back a result that is wrong . Which is wrong formula shown here . But anyways of course I am grateful for the all course . Just had to point that out .
✅ Download the free exercise files to follow along ➡www.simonsezit.com/excel-2021-beginner-to-advanced-course-files/
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
hi, IT. May I ask about the datedif function? The age calculation will show minor difference if I use cell (B2- cell D4)/365 and round the number, with the formula datedif? it is because not every year has exactly 365 days....so how to avoid such scenario and get a more precise age number?
me
This is BS
interesting course
Thank you.
This is the best Excel course on RUclips so far, thanks for making it possible for us to learn.
We appreciate your feedback. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
FORMULAS
1. basic alzebra
2.count,countA(for albhatic also),countBlank(for no of blank blocks)
3. Average
3. min(to find min value in selected range)....MAX
4. CTRL+D to apply full formula to other tables
5. FLASH FILL (fills similar kinda data) can be found under data
6. CNTRL+SHIFT+DOWN ARROW to select full column
7. FORMAT PAINTER (to copy full design) below copy and past
8. DATA VALIDATION (4:22:00) to show list
9. To lock go to review and protect cell
10. CNTRL+K to insert link to any pic or text
11. using gates (IF,AND,OR) 4:45:00
to consider both use AND & t take consider any one use OR
12. NESTED IF [=IF(logic,IF(....))] 4:57:00
13. IFS [=IFS(logic1,logic2,logic3)]
14. SUMIF,COUNTIF,AVERAGEIF (critiria,formula) 5:14:00
SUMIFs,COUNTIFS,AVERAGEIFS(2 or more critiria,formula) 4:17:00
15. IFERROR (is udes to write desiered senetence in error block)
16. VLOOKUP (used to look value in coloums) 5:40:00 2types- approx and exact analysis
HLOOKUP (for horizental lookup) 5:55:00
17. INDEX (same like lookup but also from R to left) 6:01:00
MATCH ( to find position of a value like row no ) 6:03:00
18. XLOOKUP ( same as lookup but very simple) 6:09:00
19. CNTRL+T to create a table and we can design table using options in top
20. OFFSET (gets value from rows and coloums from enterent value) 6:19:00
sum of last 6 months values ex - 6:25:00
21. INDIRECT (to entr another cell value) 6:30:00
22. under Data go to SORT to sort based on coloum and text
23. =SORT and SORTBY to sort by any coloum and asendening or desending order 7:02:40
24. UNIQUE to find unique items in repeated items
25. FILTER (to filter list by a value in that list) 7:20:00
26. =TOADY() or CNTRL+; present days date and change by time
=NOW() or CNTRL+SHIFT+; to get time which changes
27. DATE and TIME functions
28. WORKDAY and WORKDAY.INTL (to calculate the work to be done by providing strt and end dates)
29. NETWORKDAYS (to find no of days b/w dates)
30. to find birthdays use DATEDIF()
31. EOMONTH to end end of the month dates
32. EDATE to add or sub the no. of months from given date
33. we can sort tables but just assigning some values and sort them asending or descending
34. INDEX can be used to enter data according to row or coloum no 9:20:00
35. RANDARRAY is used to enter random data in blocks
36. XLOOKUP can be used to look at 2 diff scenes 10:37:00
37. =CHOOSE(1,"A","B","C") 10:42:00
1 is A ...... 2 is B..... 3 is C
38. =SWITCH(expression,1,"hi",2,"kk") 10:51:00
1 is hi
39. MEDIAN (middle value)
40. MODE (most occering value)
41. =LARGE (to find 2nd or nth largest value in an arry)
same =SMALL 11:11:00
42. RANK (to rank any num values in list) 11:19:00
43. ROUND ( for rounding values ) 11:37:00
44. AGGREGATE (to do arthametic calculations without considering errors or other) 11:46:00
Thank you
THANK YOU
The time stamps are also in the description...
Is there any payroll computation there?
This is the best Excel course on RUclips so far, thanks for making it possible for us to learn.
I am happy to have found this video.
You are very welcome! Glad it was helpful. 🙂
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
BEST TEACHER AND CHANNEL ON RUclips! SUBSCRIBED!! THANK YOU!! 😊
4:10:59 Intermediate starts
7:30:30 Filter and sort
7:36:40 date n time
7:58:30 dateif
8:04:43 loan amortization schedule
8:20:07 dynamic array
8:50:00 sort function
10:41:17 choose function
Thank you for the support!
@@SimonSezITwhere is pivot tables
I just finished my journey with Excel 2021. I am so proud of myself and I can't stop thanking Simon Sez and Deb or this very interesting course. I've learned so many things during the 12 hours course and higher is my satisfaction. Thank you so much for your help!
That's a great job! Congrats on completing it, and we hope you "excel" with your future endeavors :-)
This course helped me land an internship in two weeks. Literally changed my life. Thank you so much!
Wow, that's awesome! Thank you sharing ;-)
At 5.5 Hours. Best tutorial ever taken. To the point, no fluff. Thank you.
Glad you are enjoying the training. 😀
Is it enough for excel??
Hello Deborah and the whole simon sez family, thank u guys very much for this wonderful course. It was learner's centered rather than teacher centered. I just finished it. What a lovely style of teaching.
I'm almost done with the course now, it's the best Excel course on the Internet, No cap!
Best Excel course on the Internet? Sounds like a formula for success! Thanks for watching! 😃
I've just completed this 12-hour video, super useful and comprehensible (I played 1.5x speed bc it's a little slow to me). Literally recommend it for anyone who wanna gain a solid grounding in Excel. Thank you so much for providing us such free precious lessons. I'm really grateful for it❤❤❤
Glad it helped! Wishing you all the best with your Excel skills :-)
Please where can I download the exercise files
good to know I'm self learning SQL and Excel because I want to be an Analyst.
@@SuarezJim
Not sure if you just want to self-learn & what your background is but with my certification we qualify for both business analyst & data... And also other positions like Project Managers etc. I've a Black Belt in Lean Six Sigma it may be possibly a route you could consider.
Can you tell me what else I should learn in Excel apart from what's given in this video?
I thought I knew Excel until I started came across this video. It's the most comprehensive Excel tutorial I have ever seen in my 10 using excel. Thank you so much for sharing such a great work.
Thank you for your kind words! I'm glad you found the tutorial helpful. 🙂
🔥If you need more FREE training, please check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
I just completed the course on Excel 365. It was so fun studying Excel,learning new formulas,analysing data,
etc. Thank you deborah and simon family for providing the study materials and such a wonderful course . I'm looking forward to learning more about pivot tables in detail.
Congratulations on completing the course! Excel can be so rewarding once you get the hang of it. We have a detailed Pivot Table tutorial here: ruclips.net/video/idgT7Gjf0P0/видео.html
I wish i could like this video 1000 times, it's amazing, thank you so much for this content
Thank you for the best Excel course, Debs you taught me so much! Excellent tutor, great that you can download files and complete all the exercises, I've learnt more from this 12 hour course than throughout all my years of using Excel. Thank you!
I watched this entire video and practiced all the exercises! Learnt a lot! Thank you Deborah and Simon!
Awesome! So happy to hear that you watched the entire video and practiced all the exercises. You're killing it! Keep up the awesome work and keep learning! 😊
We have additional free Excel training if you need it 👉
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Unarguably, The best Instructor around. 👏🏽👏🏽👏🏽
Appreciate your support and encouragement. 🤩
@@SimonSezIT Instructor like Deborah Ashby 💯❤️🔥👏🏽
All along following this lesson, I faced only one problem, and it was this hashtag ######## error. I recently found out that it's not an error, and the following information is from Google:
The "hashtag" error, a string of hash or pound characters like ####### is not technically an error, but it looks like one. In most cases it indicates the column width is too narrow to display the value as formatted.
And I am in the middle of the lesson now, 3:48:26 this is where I'm stopped at yhe moment. Beautiful teacher, awesome content, incredible teaching method. Wish I had Deb as my IT teacher in my school. May god bless you and the SimonSezIT community for sharing the knowledge with us. Thank you❤
I've returned back to this course after some months, it's just too good.
Thank you for the kind words 🤩 Glad it was helpful.
I am writing to thank you for the excellent Excel training that I recently completed on your RUclips channel. I learned so much from your clear and concise explanations, and I am now much more confident in my ability to use Excel.
I particularly appreciated the way you took the time to explain the underlying concepts of Excel, as well as the practical applications of these concepts. This made it much easier for me to understand how Excel works and how I can use it to solve real-world problems.
Thank you for providing such a valuable resource. I highly recommend your Excel training to anyone who wants to learn how to use this powerful software tool.
Many thanks for taking the time to write and to say "thank you". Wishing you all the best during your Excel journey :-)
Do you have the practice file?
Awesome lesson! I finished the all recordings. I learned a lot. Thank you Deb for the clear instruction and exercise.
Thanks Deborah for walking in your purpose, we are grateful for all these. Greetings from Germany
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
I was looking for something like this where whole excel course is available from beginners to advance. Thankyou so much ⭐
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
@@SimonSezITthanks :)
Do you also have any video on excel dashboard course?
@@bhumikaa.x_x Hi, in my excel i don't have dynamic array formula. Any help?
Wonderful and helpfully thorough presentation. I learned alot. The British accent was a bonus, as any serious topic spoken with a British accent makes the topic suddenly sound more intellectually sophisticated lol
This is the best Excel course on you tube so far. thanks a lot Deb and Simon sez !!!
Wow, thanks! Thanks for the kind comments. 🤩
I just did a LinkedIn Basic Excel course and I really liked it. I want to master it. Thank you for this course.
That's awesome to hear! Excel is such a valuable skill. Keep practicing, and you'll be a master in no time!
Its great to be able to do courses like this one, thank you so much for letting me learn for free.
Glad you are finding them helpful, John :-)
Thanks for helping me perfect my skills in Excel, your teaching style is apt and great instructors.
You are so welcome! 😃
Thank you so much for the detailed course. It was easy to understand and my Excel knowledge has definitely increased. Once again thanks :)
We're so glad to hear that the course was helpful and that your Excel knowledge has increased! Keep up the great work and keep on learning!
🚀 We have more free Excel training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
I really like the teaching style and lessons from Simon Sez, especially this instructor. I signed up for their Excel Business Analysis course because it had a lot of great worksheets (and others like MS Project, Alteryx, etc,). Just wish they had these instructions when I started out using the different software (I just find it too challenging to learn from books, or web articles, which was my primary learning method years ago).
I finished the whole entire series it’s a couple of mislabeled files in the advanced folder tho. Very useful material! Thank you so much
Congrats on watching the entire video! If you can let us know which files where incorrect, we''ll take a look at get them fixed, thanks!
Please, where did you get the exercise files?
@@adeolaadisa41 Description
hi Jeremy we are still waiting for your answer? thanks
@@adeolaadisa41 it’s on the right side of the page hit the button more and it’ll come down
Great video! By the way, when it comes to PEDMAS/BODMAS, Deb should have mentioned that multiplication and division (as well as subtraction and addition) have the same precedence and it is evaluated from left to right.
This was a really great course. I was deep into pivot tables for work, but there are so many things I didn't I know. Thanks so much!
Wow, thanks! Glad it was helpful. 🤩
Thanks a lot, Deb, this course is pure Gold. I am very Thankful.
You are most welcome!
Thanks for the tutorial. I learned a lot from it. Can we get a certificate of conclusion to post it on LinkedIn?
Thank you very much for this wonderful course ! I am an advanced Excel user but I watched it all and still learned quite a few things in every section.
Hey, thanks a bunch for the awesome comment! It's great to hear that even as an advanced Excel user, you found value in the course and learned new things. Keep up the good work and keep learning! 🙂
Check out our FREE 300+ hour training course playlist here ➡️
🔥ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Absolutely love this course! Deb is just wonderful! Thank you for this course and the rest of the courses which i have followed!
I'm so glad to hear that you loved the course! Appreciate your support! 😊
One of the best if not the best tutorial i've ever watched ! Thank you so much for sharing
Wow, thanks! Keep up the awesome work and keep learning! . 🤩
I finished today ! Amazing course ! And many thanks to those who decided to share their knowledge with willing people...with everyone...Thanks !
Thank you for your kind words! A pleasure to share knowledge and help others succeed. 🤩
I noticed an error with the 2 way look up, luckily I was able to solve it by swapping the arguments in the index function. I wonder why it worked In the video though.
Because I'm using a lower version of Excel, I was only able to practice the dynamic array functions with Google Sheets, no problem because I still had the course files to upload and learn.
Excellent course, Excellent teaching method. Thank you for adding the course resources. This is the best tutorial I've ever taken, I'm now very confident using spreadsheets!
I don't comment a lot on RUclips, but I'll be an Ingrate not to show my appreciation to this tutor and this channel. This course is worth a fortune!
Fabulous Deb 🤩,with your mesmerising voice, you make it sensationally helpful to grasp every single detail. Thanks a lot and well done 💯❤💪
Glad it was helpful! 🙂🙏
Great skills to teach.. I really enjoy learning from your videos
Thanks for the nice comments, Majid.
I just want to thank you for your selfless efforts.. thanks a lot.. god bless you... Also one thing I want to ask is this everything we have to know about Excel? Or there are something's left?
The eomonth and edate files the last instructor's files in the intermediate level are not included in the free exercise. But so far, so thankful!!! I'm heading now to the advance but I will watch video about eomonth and edate first. I will be back again to say thank you after I finished your whole video tutorial. ❤❤❤
Thank you so much for your enthusiasm! Enjoy and happy learning! ❤
Great Job!!
I really enjoyed it!
But I want to point in that part 6:47:30 while you mentioned the second sorting will work if we compared two names with the same initial letters -in the first sorting-. But that is actually incorrect,
In order to see the difference we must compare two identical names, here we can look to the second sorting to make sure from the result.
Thank You , for a great course, and the voice of the instructor is pleasant to the ear. I am learning a ton and easily.
You are most welcome. Thank you for watching 😊
Brilliant Course set at the right tempo and easy to follow with confidence
Thank you :-)
Beautiful! Probably the best course i've ever had.
Thanks for the kind comments 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
The course is creative, simple, and easy to learn. the best course for excel Beginners...
Glad you think so, Mohammed Abid 😊
@simonsezit could you please help me with the practice file?
This is such a great resource and it is unbelievable that it is free. Is there a reason the lesson on Golden Rules of Spreadsheet Design is missing? Is it limited to paying subscribers?
This training is part of the complete set of courses we offer at Simon Sez IT 👉 www.simonsezit.com/course-category/excel/
great course with an excellent instructor.
Thank you for your kind words. Glad you enjoyed the course 😊
The most useful video of excel ever. Thank you!
Wow, thanks! Glad it was helpful. 🤩
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
the best excell formulas in youtube
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Hi. Firstly, thank you so much for this EXCELLENT course. I am learning so much. I am in the last lesson of the Intermediate section: 06-07 calculate dates with edate and eomonth, but the Instructor File for this lesson is not in the download packet.
Exceptional course!! Well done! Really helpful and totally easy to follow! Keep up the good work ....
🍁 شكراً لحرضتكم 🍁
Thanks for the kind comments 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Started today, So far so good. Wonderful work.
Wonderful! Thanks for watching 🙂
Thanks guys for these awesome course. Greeting from Malaysia
You are very welcome! Thanks for watching 😃
I finished 2 hours 🤗
To be continued
We're rooting for you! :)
Thanks a lot for all of these and for free😊😊😊😊😊 it's just to good to be true
May God bless you, sir
Hey, thanks a bunch for your comment! We're thrilled to hear that you're loving the content. It's all about sharing and helping each other out. Keep watching and stay awesome! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Great instruction that is too much helpful for who want to learn.
thanks a lot from sharing this.
Glad you enjoyed it. Thanks for watching! 😃
Now I'm working as a PMO, what should I learn to improve myself. Do i learn Excel, VBA, Power BI
For project management I don't think expertise of excel is required its more of project management, still you want to learn VBA your welcome
Fantastic explanation and very easy to understand amazing instructor
Glad it was helpful! Thanks for watching 😊
Your lessons are really wonderful. Thank you so very much. However, under the Randarray assignment where the objective was to generate revenues and profits for the various sales personnel, some profit figures were greater than the corresponding revenues. Is that possible?
Awesome Instructor . Thank you!
You are welcome!
excellent course!..you forgot to add the course materials for EOMONTH and EDATE at the end of intermediate course.
Excellent tutorial. Thank you so much for bringing this, and free!
You're very welcome!
Clear concise and educational, thank you so much !!
Hey, thanks a ton for watching and for the positive feedback! 😊
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
great great teacher! =D
step by step.. she did a great job!
Deborah ❤
Glad it was helpful! 🤩
Learn more Microsoft Excel Tips and Tricks here ➡️
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Thank you so much for this tutorial, the Instructor has done a superb job, keep it up.👍
You're very welcome! 😊
Thanks A LOT for this amazing course
Wow, thanks! Glad it was helpful. 🤩
Will take the course and keep you updated
Excellent teaching. Much appreciated.
Glad you enjoyed it. Thanks for watching 🙂
Check out our FREE 300+ hour training course playlist here 👉
🔥ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Excellent course to learn Excel.
EXCELLENT COURSE, I'VE ALREADY FINISHED IT :)
Nice work!
3hrs and going, Very nice. Thanks for helping.
Our pleasure! Good luck finishing the course 💪🏼
Exceptional course!! Well done! Really helpful and totally easy to follow! Keep up the good work :)
Glad you enjoyed it!
Could you make a course for charts and pivot tables in Excel
Not enough words to thank you ❤️✌️
Our pleasure 😊
Hello
Thanks for this courses, I like the way things are explain .
Woud you add charts, powers pivots, working with several worksheets or workbooks?
Thanks for all...
You're welcome. We're glad you enjoyed it.😊
🔥Please check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🚀 Level up your Excel skills with free training here 👉 ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
& Pivot Table training here 👉 ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u
For more information about Simon Sez IT courses, visit:
SimonSezIT.com: www.SimonSezIT.com/
Stay in touch!
RUclips Channel: www.youtube.com/@SimonSezIT
LinkedIn: www.linkedin.com/company/simon-sez-it/
Please SUBSCRIBE ► ruclips.net/user/simonsezittraining
♥️ We appreciate your support!
Thanks
Very nice teaching style ,specific to the point,many thanks 3:28:00
I love you Instructor, you style is excellent
I appreciate that!
Thanks for this great course!
Glad you found the course helpful! Thanks for watching 😃
Simply an amazingly helpful video. I Am, i better say, we are immensely grateful to Deb Ashby for such an effort.
Your appreciation means the world. Grateful for your support!
love the video, i had a question though about flash fill can "=find" or "=search" be also used in the same way? Or is it used for a much complex search in a cell.
THANK U SOOO MUCH this is a brilliant course😍
You're very welcome! 😊
Please check out our other FREE tutorials here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
thank you a lot, I'm a new subscriber.
Thank you, Miss Deb and Simon Sez
Glad you enjoyed it. Thanks for watching! 😃
hi thank you . that 's great. I have a question about DIV/0 error part, : i did not get why you change formula DIV to SUM formula and how did you determine Q2 position ? could you please explain it please.
excellent course
5:35:07 there is a mistake here, because Debbie Wolf is said to be from *Canadata* and not from Canada. So in the actual sheet the formula seems wrong. But in the next frame you corrected it for the video.
My question is - how do we make it search even with a grammatical error?
This is the best Excel course on RUclips so far, thanks for it .
brilliant lesson. learned a lot
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Thanks. This video is very helpful.😍
So glad you found it helpful! 🤩 Thank you for the support!
just finished it, great course! took me 3-4 settings
Nice work! ;-)
Thank you so much and big hugs...❤😊
Wow, thanks! Glad it was helpful. 🤩
I just started , is this tutorial a to z or include advance things
Wow, Deby is good. Nice work dear👍
Glad you enjoyed it. Thanks for watching! 🙂
excellent work . good job
Your teaching is good madam
Thanks a lot!
At hour 10:36 the two way look up function , when you try with index and match it only gives you back the correct answer if it's the same number for the column and for the row . If you have different numbers, it gives back a result that is wrong . Which is wrong formula shown here . But anyways of course I am grateful for the all course . Just had to point that out .