Excel Tutorial Beginner to Advanced - 12-Hour Excel Course
HTML-код
- Опубликовано: 24 янв 2023
- ✅ Download the free exercise files to follow along ➡️www.simonsezit.com/excel-2021...
This Microsoft Excel 2021 Beginner to Advanced training course covers everything from the basics of Excel to intermediate and advanced skills.
Topics covered include logical IF functions, Excel lookup functions, formatting, statistical functions, and more. Downloadable exercise files from the paid-for course are included, helping users master Excel.
The course covers how to launch Excel, explore the interface, use ribbons, tabs, and menus, utilize the Quick Access Toolbar, and more.
Additionally, the course covers intermediate topics such as cell styles, data input, navigation buttons, and more.
Finally, the course covers advanced topics such as dynamic arrays, two-way lookups, median and mode, rounding values, and more.
📝 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:00:22 - Course Intro
0:02:42 - Excel 2021 vs Excel 365
0:08:21 - Launching Excel
0:12:00 - The Start Screen
0:22:12 - Exploring the Interface
0:33:51 - Ribbons, Tabs and Menus
0:42:20 - Backstage Area
0:47:00 - Quick Access Toolbar
0:56:45 - Useful Keyboard Shortcuts
01:06:27 - Getting Help
01:13:04 - Exercise 01
01:15:27 - Working with Templates
01:24:30 - Workbooks and Worksheets
01:32:04 - Saving Workbooks
01:40:50 - Entering and Editing Data
01:50:43 - Navigating and Selecting Cells, Rows and Columns
01:58:02 - Exercise 02
02:03:22 - Formulas and Functions Explained
02:15:06 - SUM Function
02:22:44 - COUNT Function
02:30:10 - AVERAGE Function
02:34:27 - MIN and MAX Function
02:36:52 - Handling Errors in Calculations
02:45:34 - Absolute vs Relative Referencing
02:52:29 - Autosum and Autofill Options
03:02:12 - Flash Fill
03:07:15 - Exercise 03
03:12:26 - What are Named Ranges
03:21:33 - Managing Named Ranges
03:25:22 - Using Named Ranges
03:30:42 - Exercise 04
03:35:00 - Applying Number Formats
03:45:03 - Applying Date and Time Formats
03:50:41 - Formatting Cells, Rows and Columns
03:59:20 - Format Painter
04:04:00 - Exercise 05
04:08:21 - Intermediate Course Introduction
04:14:39 - Improve Readability with Cell Styles
04:19:36 - Controlling Data Input
04:27:55 - Adding Navigation Buttons
04:36:42 - Logical Functions
04:50:01 - The IF Function
04:55:27 - Nested IFs
05:03:29 - The IFs Function
05:09:34 - Conditional IFs
05:16:19 - Multiple Criteria
05:23:30 - Error Handling
05:29:33 - Exercise 01
05:37:02 - VLookup (Exact Match)
05:47:43 - VLookup (Approximate Match)
05:52:09 - HLookup
05:57:46 - INDEX and MATCH
06:08:18 - XLookup and XMatch
06:18:26 - OFFSET Function
06:29:16 - INDIRECT Function
06:38:22 - Exercise 02
06:47:27 - Sorting on Multiple Columns
06:50:31 - Soring Using a Custom List
06:54:05 - SORT and SORTBY Functions
07:04:04 - Advanced Filter
07:10:58 - UNIQUE Function
07:16:16 - FILTER Function
07:25:45 - Exercise 03
07:31:26 - How Date and Times are Stored
07:35:38 - Custom Data and Time Formats
07:42:47 - Time and Date Functions
07:51:33 - WORKDAY and WORKDAY.INTL Functions
07:55:22 - NETWORKDAYS and NETWORKDAYS.INTL Functions
07:58:19 - DATEDIF
08:04:32 - EDATE and EOMONTH
08:12:15 - Advanced Course Introduction
08:15:04 - Exercise 01
08:17:08 - Dynamic Arrays
08:19:23 - Spill and Arrays
08:30:18 - Extract and Count Unique Entries
08:36:33 - Unique vs. Distinct
08:39:54 - Unique with Multiple Criteria
08:43:07 - Unique Values by Column
08:47:30 - SORT Function
08:56:25 - Horizontal Sort
09:02:30 - SORTBY Function
09:08:40 - Horizontal SORTBY
09:11:47 - Sequence and Unstacking Records
09:21:54 - Filter Function
09:28:54 - Using Filter with Logic Plus Operator
09:33:41 - Using Filter with Logic Asterisk Operator
09:39:19 - Using Filter with Logic Equals Operator
09:43:32 - Using Filter with Logic Minus Operator
09:48:21 - RANDARRAY and RANDBETWEEN
09:58:06 - XLookUp
10:10:26 - XMatch
10:16:50 - Exercise 02
10:29:57 - Two-way Lookups
10:38:23 - CHOOSE Function
10:48:25 - SWITCH Function
10:52:58 - Exercise 03
11:00:03 - Median and Mode
11:06:20 - Using LARGE and SMALL
11:13:51 - Ranking Data
11:21:33 - COUNTBLANK Function
11:26:19 - Exercise 04
11:33:24 - Rounding Values
11:40:23 - Specialized Rounding
11:44:52 - Aggregate Function
11:49:26 - Exercise 05
🌍 Get unlimited training with Simon Sez IT’s 160+ 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...
Check out our Microsoft Excel Long Tutorials playlist here
🔥 • Microsoft Excel Traini...
✅ PivotTable training here 👉 • Pivot Tables - All you...
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: / simon-sez-it 
Наука
✅ 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.
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.
We appreciate your feedback. Thanks for watching! 🙂
🔥Check out our FREE 300+ hour training course playlist here 👉
ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
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.
Awesome lesson! I finished the all recordings. I learned a lot. Thank you Deb for the clear instruction and exercise.
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!
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!
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??
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 :-)
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 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!
Thanks for helping me perfect my skills in Excel, your teaching style is apt and great instructors.
You are so welcome! 😃
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
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 :-)
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've returned back to this course after some months, it's just too good.
Thank you for the kind words 🤩 Glad it was helpful.
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
Thanks for this great material!
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. 🤩
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❤
Exceptional course!! Well done! Really helpful and totally easy to follow! Keep up the good work :)
Glad you enjoyed it!
A gift to professionals everywhere.
Thank you so much for your kind words! I'm glad you found this video helpful. 😊
We have a lot more courses on MS Office which you can find 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'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.
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!
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 😊
Great skills to teach.. I really enjoy learning from your videos
Thanks for the nice comments, Majid.
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?
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?
Just perfect,well done
excellent work . good job
Will take the course and keep you updated
Excellent course to learn Excel.
Very nice teaching style ,specific to the point,many thanks 3:28:00
Excellent tutorial. Thank you so much for bringing this, and free!
You're very welcome!
Thank you so much for this tutorial, the Instructor has done a superb job, keep it up.👍
You're very welcome! 😊
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. 🤩
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! . 🤩
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!
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
thank you a lot, I'm a new subscriber.
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. 🤩
Great Course , we helpful for this course.
Awesome Instructor . Thank you!
You are welcome!
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?
thanks for sharing this.
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
Excellent !
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!
3hrs and going, Very nice. Thanks for helping.
Our pleasure! Good luck finishing the course 💪🏼
Brilliant Course set at the right tempo and easy to follow with confidence
Thank you :-)
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
excellent course
Smashed it 2 days, thank-you so much, this was fun.
A bunch of the files in the advanced section are wrong, but usually if you choose the completed file, it is usually correct, just delete the work and start again :)
Glad it worked. Thanks for watching! 😃
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.
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.
Fantastic!, Thanks for sharing.
Glad you enjoyed it!
Fantastic explanation and very easy to understand amazing instructor
Glad it was helpful! Thanks for watching 😊
Great. Thanks for your time
I vLue ur efforts really very much
Thanks and welcome!
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 course helped me land an internship in two weeks. Literally changed my life. Thank you so much!
Wow, that's awesome! Thank you sharing ;-)
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 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
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!
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!
Not enough words to thank you ❤️✌️
Our pleasure 😊
THANKS A LOT .
I love you Instructor, you style is excellent
I appreciate that!
Excellent video
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?
Many thanks
Thank you, Miss Deb and Simon Sez
Glad you enjoyed it. Thanks for watching! 😃
great course with an excellent instructor.
Thank you for your kind words. Glad you enjoyed the course 😊
Thanks for this great course!
Glad you found the course helpful! Thanks for watching 😃
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
Started today, So far so good. Wonderful work.
Wonderful! Thanks for watching 🙂
Unarguably, The best Instructor around. 👏🏽👏🏽👏🏽
Appreciate your support and encouragement. 🤩
@@SimonSezIT Instructor like Deborah Ashby 💯❤️🔥👏🏽
THANK YOU
EXCELLENT COURSE, I'VE ALREADY FINISHED IT :)
Nice work!
Excellent
thanks ! best tutorial out there
You're welcome! Thanks for visiting our channel to watch it :-)
Great teaching and i'm enjoying the class, i downloaded the course file but most of the section and exercise files where showing error, the file name has been changed or moved... is there a way these can be fixed?
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
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! ❤
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?
great course, Does it include graphing data on excel ?
brilliant lesson. learned a lot
Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️
ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
Thank you
more than great Thanks ♥
Glad you like it!
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.
excellent course!..you forgot to add the course materials for EOMONTH and EDATE at the end of intermediate course.
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!
thank you
At 11:06:10 in the Mode.Multi
Why doesn’t it recognize all of the duplicate numbers?
Thank you so much
Thanks for watching ;-)
HELP please: I can only access the OPTIONS and GROUP SETTINGS on the files you have provided, but not on my own excel files. I have Microsoft office 365 on one drive through the monthly subscription. On my worksheets, when I go to File - Options is either grayed out or only lets me select a language.. no other option menus are available, even at the bottom of each group. Even the ribbon looks different.. Can anyone help me, it’s for a job. 😢
I need to work 2 excel worksheet side by side in windows 11 without collapsing (Reducing to mini version) of ribbon. What can I do. My monitor is 27'' 1080p .
I can not open the exercise files, the link given is not working for me
Could you make a course for charts and pivot tables in Excel