✅ 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 👉 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
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 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you so much for the free tutorial. Maam Ashby's way of teaching helps me understand it easily. Great job. In return, i let the ads play, i never skip them. :)
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 👉 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
BEST TEACHER AND CHANNEL ON UA-cam! 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.
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❤
Since I discovered this channel, I have never sought any other. My excel skills have greatly improved as a result. And I get to apply quite a number of them since I work in accounting
So glad to hear that you found our tutorials helpful! It's great knowing you're applying your new Excel skills at work. Here’s to more learning in 2025 😊
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 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
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 👉 ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉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 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: ua-cam.com/video/idgT7Gjf0P0/v-deo.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!
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?
I am writing to thank you for the excellent Excel training that I recently completed on your UA-cam 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
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.
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 👉 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 have a doubt at 8:10:06 where the instructor unlocks the cell from Absolute to Relative... since it's leap year in 2022... HOW can the next year also be a leap year?!!(if you can see below). i would try and workout if i had working file for this 😐 Other than that she's so good :)
Hello! For 9:01:57, I noticed that the movie titles were incorrect, for example the last two rows of the same actors starting with Kate Winslet, they didn't cast Burn After Reading. Is there a to include the movie titles along with the cast names? English is not my first language, please forgive me for grammatical errors
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 .
The results in the Advanced/Sort Function Horizontal don't make sense to me. Around timestamp 9:02, In the bottom example after sorting, you're saying Kate Winslet, Miles Teller, Shailene Woodley and Theo James were all in both Burn After Reading and Insurgent together, but according to the table, none of them were in Burn After Reading. Same with the example above it. ?
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 ➡️ 🔥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 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 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 UA-cam, but I'll be an Ingrate not to show my appreciation to this tutor and this channel. This course is worth a fortune!
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?
Thanks for the kind comments 🙂 🔥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!
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. ❤❤❤
Just want to highlight that around 9:02:19, you name the wrong movies that the actors have all been in. Because you copy pasted and then sorted the joint actor names, the joint actor names moved rows and so don't match!
Thanks for the kind comments 🙂 🔥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!
Hey, thanks a ton for watching and for the positive feedback! 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Wow, thanks! Glad it was helpful. 🤩 🔥Check out our FREE 300+ hour training course playlist here 👉 ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
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 👉 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!
Glad you enjoyed it. Thanks for watching 🙂 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!
2:54:10 instead of dragging with mouse.. the teacher taught in the past on how to select with keyboard itself without using Mouse.. if anyone remembers PLEASE help me out.. responses are Highly appreciated!
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.
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.
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?
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.
✅ 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 👉
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
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 UA-cam 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 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Thank you so much for the free tutorial. Maam Ashby's way of teaching helps me understand it easily. Great job.
In return, i let the ads play, i never skip them. :)
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?
you're amazing brother
This is the best Excel course on UA-cam 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 👉 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
BEST TEACHER AND CHANNEL ON UA-cam! 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 :-)
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.
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??
2:03:27 Formulas and Functions
3:02:12 Flash fill
3:12:30 Named ranges
3:35:00 Number Formatting
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?
Thanks. This video is very helpful.😍
So glad you found it helpful! 🤩 Thank you for the 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'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! 😃
Since I discovered this channel, I have never sought any other. My excel skills have greatly improved as a result. And I get to apply quite a number of them since I work in accounting
So glad to hear that you found our tutorials helpful! It's great knowing you're applying your new Excel skills at work. Here’s to more learning in 2025 😊
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 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
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 👉
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html & here 👉 ua-cam.com/play/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI.html & Pivot Table training 👉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 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: ua-cam.com/video/idgT7Gjf0P0/v-deo.html
Awesome lesson! I finished the all recordings. I learned a lot. Thank you Deb for the clear instruction and exercise.
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.
Hey will u pls.tell that where is data set.. that link is not working
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!
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?
I am writing to thank you for the excellent Excel training that I recently completed on your UA-cam 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?
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
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 :-)
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.
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!
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. 🤩
Wow I've been searching for Excel course and THIS is by far the best I've come across.
So glad to hear you found the course helpful! It’s designed to take you from beginner to advanced in no time. 😃
Four hours done and still going.... Excited for the intermediate stage .... Loving this excellent course.... With love from Dubai ❤❤❤
So glad you're enjoying the course! Keep up the great work!
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 ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
@@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?
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 ;-)
Thanks for helping me perfect my skills in Excel, your teaching style is apt and great instructors.
You are so welcome! 😃
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 ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
Thanks for the tutorial. I learned a lot from it. Can we get a certificate of conclusion to post it on LinkedIn?
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 👉 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
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! 😊
i have a doubt at 8:10:06 where the instructor unlocks the cell from Absolute to Relative... since it's leap year in 2022... HOW can the next year also be a leap year?!!(if you can see below). i would try and workout if i had working file for this 😐
Other than that she's so good :)
I wish i could like this video 1000 times, it's amazing, thank you so much for this content
Wow, thank you so much for your kind words! Really glad you enjoyed the video. Your support means a lot!
Hello! For 9:01:57, I noticed that the movie titles were incorrect, for example the last two rows of the same actors starting with Kate Winslet, they didn't cast Burn After Reading. Is there a to include the movie titles along with the cast names?
English is not my first language, please forgive me for grammatical errors
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! . 🤩
3:09 - why use a sum function when you are doing just a multiplication? You can just use the formula =B3*C3, right? Is there any reason to use sum?
Great skills to teach.. I really enjoy learning from your videos
Thanks for the nice comments, Majid.
Thanks a lot, Deb, this course is pure Gold. I am very Thankful.
You are most welcome!
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 .
Exceptional course!! Well done! Really helpful and totally easy to follow! Keep up the good work :)
Glad you enjoyed it!
Unarguably, The best Instructor around. 👏🏽👏🏽👏🏽
Appreciate your support and encouragement. 🤩
@@SimonSezIT Instructor like Deborah Ashby 💯❤️🔥👏🏽
The results in the Advanced/Sort Function Horizontal don't make sense to me. Around timestamp 9:02, In the bottom example after sorting, you're saying Kate Winslet, Miles Teller, Shailene Woodley and Theo James were all in both Burn After Reading and Insurgent together, but according to the table, none of them were in Burn After Reading. Same with the example above it. ?
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 😊
At 11:06:10 in the Mode.Multi
Why doesn’t it recognize all of the duplicate numbers?
Oooh Wow! This was an incredible ride> Thanks, Deb. Thanks, Simon Sez IT.
Glad you enjoyed it. Thanks for watching! 😃
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. 🤩
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 ➡️
🔥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 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).
Hi, there's no working file for Module 06-07 Calculate Dates with EDATE and EOMonth at 08:04:33
at 5:35 no matter what i do it always gives me 0 !
any idea why ?
EDIT: it was the actual data error one of the canada data was written wrong
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. 🤩
Very nice teaching style ,specific to the point,many thanks 3:28:00
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 UA-cam, but I'll be an Ingrate not to show my appreciation to this tutor and this channel. This course is worth a fortune!
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?
Beautiful! Probably the best course i've ever had.
Thanks for the kind comments 🙂
🔥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!
Brilliant Course set at the right tempo and easy to follow with confidence
Thank you :-)
6:00:59 index match functions
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?
I finished 2 hours 🤗
To be continued
We're rooting for you! :)
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! ❤
Just want to highlight that around 9:02:19, you name the wrong movies that the actors have all been in. Because you copy pasted and then sorted the joint actor names, the joint actor names moved rows and so don't match!
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 👉
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!
great course with an excellent instructor.
Thank you for your kind words. Glad you enjoyed the course 😊
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 ➡️
ua-cam.com/play/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc.html
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 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
Excellent tutorial. Thank you so much for bringing this, and free!
You're very welcome!
6:38:14 indirect function
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! 🙂🙏
Started today, So far so good. Wonderful work.
Wonderful! Thanks for watching 🙂
Awesome Instructor . Thank you!
You are welcome!
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 👉
ua-cam.com/play/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU.html
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! 😃
5:32:25 Can i take cell reference instead of typing USA
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 👉
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!
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
Thanks guys for these awesome course. Greeting from Malaysia
You are very welcome! Thanks for watching 😃
10:21:20 i think wrong values in distinct and unique
Thank you so much for this tutorial, the Instructor has done a superb job, keep it up.👍
You're very welcome! 😊
2:57:13 the "secret menu" didn't work for me =/
Fantastic explanation and very easy to understand amazing instructor
Glad it was helpful! Thanks for watching 😊
Thank you very much 🎉....this course was amazing...
So glad you enjoyed the course! Here’s to more learning in 2025 🤩
Excellent teaching. Much appreciated.
Glad you enjoyed it. Thanks for watching 🙂
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!
Could you make a course for charts and pivot tables in Excel
2:54:10 instead of dragging with mouse.. the teacher taught in the past on how to select with keyboard itself without using Mouse.. if anyone remembers PLEASE help me out.. responses are Highly appreciated!
thank you a lot, I'm a new subscriber.
Thanks A LOT for this amazing course
Wow, thanks! Glad it was helpful. 🤩
Will take the course and keep you updated
6:00:00 Lookups formuls
Thanks for this great course!
Glad you found the course helpful! Thanks for watching 😃
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.
can you pls provide data set link
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.
EXCELLENT COURSE, I'VE ALREADY FINISHED IT :)
Nice work!
22:25 Starts after Introduction
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/
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.