Microsoft Excel 2021/365 Tutorial: 3.5+ Hours of Advanced Excel Training Course

Поделиться
HTML-код
  • Опубликовано: 23 дек 2024

Комментарии • 236

  • @SimonSezIT
    @SimonSezIT  2 года назад +3

    ✅Download to follow along and complete the free exercises ➡️ www.simonsezit.com/excel-2021-advanced-instructorexercise-files/
    🔥Check out our FREE 300+ hour training course playlist here ➡️
    ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
    🚀 Boost your Excel skills with these free Excel playlists 👉🏼
    ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
    & here 👉🏼 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
    & Pivot Table training here 👉🏼ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

    • @zhangmr7955
      @zhangmr7955 2 года назад +1

      Hi Dab, do you consider to open some VBA courses?

    • @zhangmr7955
      @zhangmr7955 2 года назад +1

      Hi Dab, please confirm there are some incorrect workseets not matched to the courses content: 02-17,02-18,02-19

    • @antonmursid3505
      @antonmursid3505 2 года назад +1

      Antonmursid🙏🙏🙏🙏🙏✌💝🇲🇨🇲🇨🇲🇨🇲🇨🇲🇨✌💝👌

    • @paulprobusjr.7597
      @paulprobusjr.7597 2 года назад

      Adin points this out in his separate comment, below, but at 50:20 with the Horizontal Sort segment, there is a mistake, Deb did not make the final sort with the movies in mind so the list of actors is out of sync with the movies they starred in, so her conclusion as to which four movies they were all in together is incorrect. I noticed some mistakes in the earlier video on Beginner to Intermediate as well, but since this one is a bit more advanced functions and function combos, it should be re-looked at and corrected. Some of those previous ones I can figure out how to correct fairly easy, this one will take a bit more thinking on my part, but I think I can work out something. Still working through the video and may have other feedback to give. I am very impressed overall with how good this video has been, I wanted to make that clear that it has been very useful and its appreciated. Thanks!

    • @KhalistoBaakWieu-si3tk
      @KhalistoBaakWieu-si3tk Месяц назад

      downloading course file for this tutorial

  • @sdinvestments2537
    @sdinvestments2537 2 месяца назад +2

    Thanks Deb, amazing how much training is available online, but people still spend 1000's on courses. We are greatly indebted to all the creatives of this world, especially those who make it available for the masses not just the classes.. You All are Invaluable to humanity.. Thank You

    • @SimonSezIT
      @SimonSezIT  2 месяца назад

      Thank you so much for your kind words! It’s amazing to be part of a community that values sharing knowledge and creativity. 😊

  • @jackmuscovich9031
    @jackmuscovich9031 9 месяцев назад +2

    I have to say I almost never comment on RUclips videos I watch. But this course is flawless. Everywhere from the concepts covered to the files you can use to follow along... I'm blown away by how perfect this was. Thanks so much!!!

    • @SimonSezIT
      @SimonSezIT  9 месяцев назад

      Glad you enjoyed it! Thanks for taking the time to leave a nice comment 😊

  • @mariag2916
    @mariag2916 Год назад +13

    Thank you so much for this. This is amazing for anyone, but if you are unemployed and cannot afford to take a course, this really helps employment prospects. You can walk into a job role with more confidence knowing you have this knowledge. The downloadable files really help with practice too.

    • @SimonSezIT
      @SimonSezIT  Год назад +1

      We're so glad that you find this helpful!

  • @ismailfaruk6676
    @ismailfaruk6676 7 месяцев назад +1

    Today, is exactly 11 days of my self enrolment in to the course, and I can confidently say that my level of practical knowledge of the tutorial is at least 80% . And I know continue practice will make me a guru. Thanks so much Simon Sez IT

    • @SimonSezIT
      @SimonSezIT  7 месяцев назад

      Wonderful! Keep it up, and thanks for watching :-)

  • @MensoJero
    @MensoJero Год назад +5

    Excellent tutorial, however...
    There's a mistake at 49:15.
    You sort the data on the right but the left side remains unaffected.
    This means the rows no longer line up after you sorted.
    So when you match the red duplicates, they actually don't line up with the movie titles anymore.
    The duplicates were not "The Interview" and "Superbad", but instead "This is the end" and "Superbad".
    The duplicates were not "Burn After Reading" and "Insurgent", but instead "Divergent" and "Insurgent".

    • @sd9320
      @sd9320 9 месяцев назад

      Yeah , I was wondering the same..

  • @dansmith5037
    @dansmith5037 Год назад +3

    I believe @49:40 arranging the actors in alphabetical order displaced the movie reference. The duplicate movies would be Divergent/Insurgent and This is the end/ Superbad. Solution would be to create another column, copy the movies to that column (left), copy, paste as value, sort, expand selection.

    • @MensoJero
      @MensoJero Год назад +1

      Another solution is to make the whole thing a table now that it's ready for sorting, or SKIP THE SORTING and just go straight to duplicate highlighting, once highlighted it's much easier to match up the movies anyway, but sorted would be nice.

    • @Allona33
      @Allona33 Год назад

      I just left out the sorting it from a-z

  • @ussama8960
    @ussama8960 Год назад +2

    i started your course from beginners course 7days ago ,now i'm in the advanced course
    it's really a super course ,the way you explain ... thank you so much deb

  • @zhangmr7955
    @zhangmr7955 2 года назад +7

    Dab is the best teacher I ever met. I attend some classes on the other platform. Excellent!

    • @SimonSezIT
      @SimonSezIT  2 года назад

      Thank you for the kind comments Zhang! 🙂

  • @revolutionarydefeatism
    @revolutionarydefeatism 8 месяцев назад +1

    50:15 Deb, I thank you for your great course! I'm a big fan of you. However, although you found the actors, the corresponding movies are not right, since there is a column between the movies table and the column you created, and when you sort them, the movies' order doesn't change.

  • @phandongexcel
    @phandongexcel 9 месяцев назад +1

    I like this video and comment, I’m from Vietnam and you ❤❤❤❤

    • @SimonSezIT
      @SimonSezIT  9 месяцев назад

      Glad you think so! Thanks for leaving as comment ;-) Sending some ❤❤❤❤ back :-)

  • @revolutionarydefeatism
    @revolutionarydefeatism 8 месяцев назад +1

    2:23:13 With all due respect dear Deb, you should first MATCH for Company (since it is the row that asked as a prior argument in INDEX) and then for Month. Your sanity check had this problem: you checked for the 5th month and 5th company, the 1st month, and the 1st company, so the row and column numbers were the same.

  • @keteatareid
    @keteatareid 5 дней назад

    Thank you for your teaching and the effort put into this video and practice tasks. However, I noticed you have taught unique and distinct in the wrong order. Excel describes unique as values that appear only once and UK has been included in the unique list but appears multiple times within the table at (20:00)

  • @daniellukaobidakpasham103
    @daniellukaobidakpasham103 2 года назад +2

    Honstly am really enjoying the Advanced Excel Training course

  • @محمدالفاتح-ش9ه
    @محمدالفاتح-ش9ه Год назад +8

    The best tutorials I have ever watched .Well presented.thank you

  • @fitchfoo7082
    @fitchfoo7082 8 месяцев назад

    It is an amazing Excel video course. Your explanations are so clear. It takes a complex concept and makes it easy to understand.

    • @SimonSezIT
      @SimonSezIT  7 месяцев назад

      Glad it was helpful! 🤩
      Learn more Microsoft Excel Tips and Tricks here ➡️
      ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

  • @devramharak7934
    @devramharak7934 2 года назад +9

    Excellent tutorial.Well presented. The manner in which the tutorials are presented could be applied in the real world. I am addicted to learning and from most of the tutorials and videos this is one of the best that I have watched.

  • @arturoaugustoperezjaramill8590
    @arturoaugustoperezjaramill8590 8 месяцев назад

    Very nice and complete video... Tks 4 sharing... ¡Saludos desde Panamá City, América Central!

    • @SimonSezIT
      @SimonSezIT  8 месяцев назад

      Thank you so much for your kind words! I'm glad you enjoyed the video. 😊
      🚀 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

  • @andrehenry3212
    @andrehenry3212 9 месяцев назад +1

    Thanks for sharing this precious training.

  • @terrylee2094
    @terrylee2094 2 года назад +15

    Brilliant tutorial as always. Such calmness and clarity in the presentation

  • @tatipamulaashok5721
    @tatipamulaashok5721 2 года назад +2

    Excellent and simplified explanation with more useful examples by using advanced functions... Thank u so much 🥰

    • @SimonSezIT
      @SimonSezIT  2 года назад

      You are welcome 😊 We have lots of additional free Excel training if you need it ➡️ ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here ➡️ ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
      & Pivot Table training here ➡️ ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

  • @umeshkhatri3743
    @umeshkhatri3743 Год назад +1

    Brilliant tutorial. Explained with very calmness and clarity.

  • @sanimunir
    @sanimunir 7 месяцев назад +5

    The problem with the downloading file is that the software demands for email and after entering email, it says thanks and then you have to wait. How much no one knows then.

  • @faissalloussaief149
    @faissalloussaief149 Год назад +4

    Fabulous ❤course, thanks for sharing your knowledge with us. The explanation is super clear and easy to understand. ❤❤❤❤❤

  • @dontown-lb5ke
    @dontown-lb5ke Год назад

    I have been using Excel since 1993 (ver.5), it came on 11 floppy discs! but am still learning new things every day.

    • @SimonSezIT
      @SimonSezIT  Год назад

      My first version was in 1995, but I don't recall the actual version. It's hard to believe we are using it 30 years later 😊

  • @johnravi1683
    @johnravi1683 2 года назад +2

    Hi Simon,
    It was a great share! I have been very disorganized lately, so I am paying my younger nephew to help me organize my data with Excel. He is new to this, and he doesn’t understand all the features. I am sure this video will help him a lot, and he will be able to complete the task much faster. It was a very in-depth tutorial, and I am sure learning how to use Excel will help him later in life as well. Thanks for sharing this, it was a great watch.

    • @SimonSezIT
      @SimonSezIT  2 года назад

      Hi John! Your nephew has a nice Uncle :-) If he needs additional free training, he can check out our Excel playlist here -> ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI
      Good luck with organizing the data!

  • @kyithatun2277
    @kyithatun2277 2 месяца назад

    Thanks millions. So valuable lessons and course materials.

    • @SimonSezIT
      @SimonSezIT  2 месяца назад

      You are very welcome! Thanks for watching 😃

  • @xlwatcher8885
    @xlwatcher8885 7 месяцев назад +1

    This is amazing, but the downloaded files don't match the files in her excellent lectures. Did I download something wrong?
    thank you

  • @oxistlamb3336
    @oxistlamb3336 8 месяцев назад

    ❤ Deb
    Is my on repeat
    I just can tell your patience for slow learners like me, is infinite 🎉

    • @SimonSezIT
      @SimonSezIT  8 месяцев назад

      Thank you for your kind words, I appreciate it! 🙂
      🔥Check out our FREE 400+ hour training course playlist here 👉
      ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

  • @abdulmateen6101
    @abdulmateen6101 Год назад

    Excellent tutorial, nicely explained. However example 2 of XMATCH, the function fails to give correct number of employees who surpassed 17,000 sales figure if the sales figure are not of descending order.

  • @herio7776
    @herio7776 5 месяцев назад

    @2:09:25 Just wanted to point out this error here. The unique vs distinct values are wrong

  • @thelonerider917
    @thelonerider917 Год назад

    Thank you, this is Amazing, a quick question though -while typing formulas and referencing a cell or range of cells,you mentioned locking the cell, how do you do that?

    • @SimonSezIT
      @SimonSezIT  Год назад

      If you right click on a cell then select Format Cells, there should be a pop up window, then go to the Protection tab. All cells by default are locked, which is indicated by a checkmark next to the Locked option. You can close this window by clicking OK to save your changes or Cancel.
      Next, go to Review tab in the menu ribbon and click on Protect Sheet. You can then select what actions are allowed for the locked cells.
      You can lock or unlock multiple cells by highlighting all of them before right clicking.

  • @AsifTech_
    @AsifTech_ Год назад

    I have commented a problem about two way lookup using Index & Match function. I have solved the problem myself, The Formula that I have done-=INDEX(Data,MATCH(A14,company,0),MATCH(B13,Month,0)) and then give the right result.

  • @realvirtualdemand4222
    @realvirtualdemand4222 2 года назад +1

    I can increase my skills to get a better change at getting a job. Thank you

    • @SimonSezIT
      @SimonSezIT  2 года назад +1

      Thanks for dropping by. We hope the training results in your desired job :-)

  • @ErikaCruz-u4p
    @ErikaCruz-u4p Год назад

    Perfect tutorial! Thank you very much!. thank you so much! This is superb!.

    • @SimonSezIT
      @SimonSezIT  Год назад

      You're welcome.Thank you for you positive feedback. 🙂
      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!

  • @XxKingfisherxX
    @XxKingfisherxX 2 года назад +5

    Thanks to Deb for knowledge you are spreading and thanks to Simon for ensuring it, i wish getting the follow along files download would 've been straight forward.

  • @ogunbanjoolutayo33
    @ogunbanjoolutayo33 Год назад +2

    Simon Sez tutorial content always comes with clarity, concise and easy to understand especially with Deborah Ashby including other good tutors too. I want to find out if Simon Sez has any free content on Microsoft Azure. Thank you.

    • @SimonSezIT
      @SimonSezIT  Год назад +1

      You're very welcome! We have no training for Azure, but it something we are considering later in the year. Thanks for the visit ;-)

    • @adlerdoesstuff1872
      @adlerdoesstuff1872 9 месяцев назад +1

      SKIBIDI TOILET
      @@SimonSezIT

  • @Amitsingh-pu7qv
    @Amitsingh-pu7qv 3 месяца назад

    0.59:52 If I take classes on Saturday and Sunday in a week, how can I find the dates for those two days.

  • @tutsecret499
    @tutsecret499 Год назад

    I will have an interview about this topics: "...to provide high level support to programs and program management, including ongoing data collection, preliminary analysis, problem identification, planning and coordination, development of alternative resolutions, final recommendations and specialized projects..." So which topics in Excel I should focus and study more. What preliminary analysis they are talking about. When the analysis starts, after I refine, clean the data? What they mean about alternative resolutions when handling data and final recommendation mean?

  • @emmabeards
    @emmabeards 8 месяцев назад

    Saved me so much trouble! thank-you!

    • @SimonSezIT
      @SimonSezIT  8 месяцев назад

      Glad you enjoyed it. Thanks for watching! 🙂

  • @alistairspence8351
    @alistairspence8351 4 месяца назад

    Excellent tutorial Deb many thanks

    • @SimonSezIT
      @SimonSezIT  4 месяца назад

      Thanks for the kind comments 😊

  • @wilfredtaikerweyah4625
    @wilfredtaikerweyah4625 Год назад

    Thank you, thank you, thanks! This is more than great.

  • @kiiprop
    @kiiprop 8 месяцев назад

    Thank you for the detailed explanations 🤗

    • @SimonSezIT
      @SimonSezIT  7 месяцев назад

      You are very welcome! Thanks for watching 🙂

  • @kapil4757
    @kapil4757 2 года назад +4

    This is really great job done!!! Making such a wonderful content available for free is an amazing job you guys have done. Keep up the great work, god bless!

  • @ironpurush0978
    @ironpurush0978 2 года назад +3

    Your email service is not working I guess. Not getting files though.

  • @BrianCarey-e9l
    @BrianCarey-e9l 5 месяцев назад

    I am intrigued by this course; I'm excited to learn more! However, the course file download did not work for me. I watch approximately 1/2 hour worth of videos, but still now downloads.

    • @SimonSezIT
      @SimonSezIT  5 месяцев назад

      Follow along and complete the free exercises here: ️ www.simonsezit.com/excel-2021-advanced-instructorexercise-files/

  • @sushantramdas3078
    @sushantramdas3078 Год назад

    Deb is the goat excel trainer.

  • @atroposization
    @atroposization 11 месяцев назад

    Thank you for the informative course and engaging tutor! There seems to be a problem with the exercises. I cant download the files?? Kindly someone to advise. Thanks!!

    • @SimonSezIT
      @SimonSezIT  10 месяцев назад

      Hey there! Thanks a bunch for the awesome feedback!
      ✅You can download the course files here ➡️ www.simonsezit.com/excel-2021-advanced-instructorexercise-files/
      Just click the button that says "Get My Files" so that we can send you the course files through your email.

  • @goce113
    @goce113 2 года назад

    I think the values that appear only once are unique and the values with their duplicates removed are distinct. Correct me if I'm wrong.

  • @adin2600
    @adin2600 2 года назад +4

    At 50:20 when you name the movies, you get the wrong ones as you already sorted col G, and actors in col G don't match movie in col A anymore. Other than that is a great tutorial, thank you.

    • @rosaguillermo9547
      @rosaguillermo9547 2 года назад

      Hi there, I also have the same concern the names doesn't match the movie title. Regards.

  • @dansmith5037
    @dansmith5037 Год назад +1

    Thank you so much for posting this course and a link to the files!! I bought an Excel learning bundle with the 2021 beginner and intermediate but the bundle didn't have 2021 advanced. Very much appreciated and Deb- you're amazing!

  • @spreadknowledgeknowledge3361
    @spreadknowledgeknowledge3361 2 года назад

    Hi Dab your every video is incredible for excel learner. Thank you so much💌

    • @SimonSezIT
      @SimonSezIT  2 года назад

      Our pleasure Spread Knowledge Knowledge 🙂 You can get additional Excel training here ➡️
      ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

  • @dansmith5037
    @dansmith5037 Год назад

    @2:24:14 The double MATCH formula seems to only work once. I tried several different combinations and it isn't correct. My formula is: =INDEX(Data,MATCH(B13,Months,0),MATCH(A14,Companies,0)) which I believe is correct. I wonder why it doesn't work.

  • @valarmorghulis2736
    @valarmorghulis2736 6 месяцев назад

    great explanation, thanks for sharing

    • @SimonSezIT
      @SimonSezIT  6 месяцев назад

      Glad it was helpful!

  • @nigelwaxley
    @nigelwaxley 2 года назад

    Thank you for this. Where can I find the rest of the course. Some items, such as form controls and lumbda, are mentioned in the intro but aren't available in this vid.

  • @raaghavgr1990
    @raaghavgr1990 Год назад

    Lovely tutorial. Watched it all the way through.

    • @SimonSezIT
      @SimonSezIT  Год назад +1

      Glad you are finding them helpful, Raaghav G.R. :-)

  • @JamesNjanjo
    @JamesNjanjo 6 месяцев назад

    Afternoon, have really tried to download those practise files more than 5 times....but haven't not received them on my PC...

  • @صلاحالمسلم-ش5ف
    @صلاحالمسلم-ش5ف 2 года назад

    Peace be upon you Thank you for the wonderful content I would like you to specify the most important jobs required in the labor market. Who works in Excel? And what are the most important skills that you want to acquire to implement these activities in order to quickly enter the labor market?

  • @Kittukat24
    @Kittukat24 Год назад

    Hi, I have MSOffice LTSC Professional Plus 2021. I am not able to execute your formula in the first 2 lessons. My excel is not showing any formula such as filter. I did not check further. Do I have incorrect version of excel?

  • @pharmabro
    @pharmabro 2 года назад +1

    Love the calming voice and pace . I am learning alot however when I tested your 2 way look up with index and match I didnt get the right answer all the time then I realised the error. Index formula is array, then row_num then [column num] the example was giving column number then row number The examples were same row and column number ( 5x5 and 1x1). So that's why it still worked.

  • @Exceltech810
    @Exceltech810 Год назад

    the video is very clear. Thank you

  • @wayuwam
    @wayuwam Год назад

    thanks a lot for education..you're amazing

    • @SimonSezIT
      @SimonSezIT  Год назад

      Hey, thanks a bunch for the shoutout! We're thrilled that you're finding our videos helpful. Stay tuned for more educational content coming your way!
      🔥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!

  • @phandongexcel
    @phandongexcel 8 месяцев назад

    I like this video ❤❤❤

    • @SimonSezIT
      @SimonSezIT  8 месяцев назад

      Thanks for the kind comments 🙂

  • @readingkhmer49
    @readingkhmer49 Год назад

    Hello, I have a question
    In excel 2021, the Khmer font in work sheet is pretty normal, but when I go to print the khmer font is cut off above. So what can i do?

  • @banerjeesomdipta
    @banerjeesomdipta Год назад

    Absolutely Super Video . Loving it .

  • @nazarkamal8831
    @nazarkamal8831 Месяц назад

    ❤❤❤❤❤❤❤ Amazing Excel

    • @SimonSezIT
      @SimonSezIT  Месяц назад

      Glad you enjoyed it. Thanks for watching! 😃

  • @zhangmr7955
    @zhangmr7955 2 года назад

    Dear Dab, the attached instructor file 02-06-extract-unique-values-by-column workseet is wrong, this is the same with 02-05.

    • @SimonSezIT
      @SimonSezIT  2 года назад

      Hi Zhang, thank you for letting us know. In the meantime, you can use the 02-06-extract-unique-values-by-column-Complete.xlsx file to follow along in this section, although this file would already have the final solutions.

  • @popcat4ad
    @popcat4ad Год назад

    a question please: how come my Excel 365 does not work on array formula? I had Excel 2019 and upgraded it today.

  • @gregcachin8308
    @gregcachin8308 2 года назад

    nice and easy to understand the tutorial, TY

    • @SimonSezIT
      @SimonSezIT  2 года назад

      Glad it was helpful! Thanks for dropping by :-)

  • @AsifTech_
    @AsifTech_ Год назад

    In Two way Lookup section, I have tried your Instructor Files practice but I can not get right result using Index & match function, I have write-=INDEX(Data,MATCH($B$13,Month,0),MATCH($A$14,company,0)), It gives for Month Sep against GoExplore. Pls Give me a Solution

  • @Jas.dhariwal
    @Jas.dhariwal Год назад

    Having trouble with downloading excel files, stuck at 50%, any alternate link?

  • @AbdhelTalya
    @AbdhelTalya Год назад

    Excellent and simple and useful

  • @erererer8162
    @erererer8162 2 месяца назад

    When I'm trying to apply the unique function to arrays or tables, it just duplicates the values! Therefore, it only works with a single column and row?

    • @SimonSezIT
      @SimonSezIT  2 месяца назад

      The UNIQUE function in Excel works with arrays, but if you're seeing duplicates, it might be due to extra spaces or formatting issues. It can handle multiple columns and rows, but ensure the data is clean and properly formatted.

    • @erererer8162
      @erererer8162 2 месяца назад

      ​@@SimonSezITThank you!

  • @lorilori155
    @lorilori155 Год назад +1

    thank you so much! This is superb!

  • @mustapha5th
    @mustapha5th Год назад

    Hello Simon, I notice there are disparities between the files in the video and the files shared via email. is this in anyway intentional? if not how do i get access to the more complete files. thank you and great job by the way.

    • @SimonSezIT
      @SimonSezIT  Год назад

      Can you provide an example? The demo and exercise files are the same ones provided by Deb for the course.

    • @fredysaxo
      @fredysaxo Год назад

      @@SimonSezIT exercise 1 was not included

  • @gustavopineda7933
    @gustavopineda7933 Год назад +1

    Perfect course, thanks.

  • @abrahammanyang5313
    @abrahammanyang5313 11 месяцев назад

    I could only imagine the world without technology; how I would be without it. I can't thank you enough for this amazing work you are doing. Thank you so much to Mrs. Deb for helping me.💌💌

    • @SimonSezIT
      @SimonSezIT  11 месяцев назад

      Wow, thanks for your kind words! I'm glad it was helpful. 🤩
      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!

  • @laviejaguardiadeltango9201
    @laviejaguardiadeltango9201 2 года назад

    Okey Simòn thak you good nigth.

  • @manmantsethi6386
    @manmantsethi6386 8 месяцев назад

    excellent teaching material

  • @dannguyen239
    @dannguyen239 Год назад

    Thank you so much! This is super helpfull!!!

  • @BangabhabanClub
    @BangabhabanClub 11 месяцев назад

    Excellent Tutorial!

    • @SimonSezIT
      @SimonSezIT  11 месяцев назад

      You are very welcome! 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!

  • @SothearithKONGMrMuyKhmer
    @SothearithKONGMrMuyKhmer Год назад

    Perfect tutorial! Thank you very much!

    • @SimonSezIT
      @SimonSezIT  Год назад

      Glad you like it! 😊 We have additional free Excel training here 👉
      ruclips.net/p/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 ruclips.net/p/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training 👉ruclips.net/p/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

  • @muhammadika
    @muhammadika 2 года назад +1

    Excellent tutorial

  • @Exceltech810
    @Exceltech810 Год назад

    It's better if Simon can have Python, and Mysql full courses. This is b/c I love Simon's video with clarity and easy-understand

  • @karennguyen7083
    @karennguyen7083 2 года назад

    Great tutorial and many thanks. Keep going ^^

    • @SimonSezIT
      @SimonSezIT  2 года назад

      Glad it was helpful, Karen! Thanks for the encouragement 😃

  • @alymohamed8779
    @alymohamed8779 2 года назад +1

    So easy so good keep it up

  • @microsoftsarker
    @microsoftsarker Год назад

    Thank you so much for this

    • @SimonSezIT
      @SimonSezIT  Год назад

      You're welcome and thanks too for taking the time. 😊
      We also have a free 9-hour course for Office 2021/365 👉 ruclips.net/video/6qjoGc-KDYs/видео.html
      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!

  • @Sensible-Immigrant
    @Sensible-Immigrant Год назад

    I did not receive the link to the files? Does anyone else have the same problem or is it just me?

  • @maazziuche28
    @maazziuche28 2 года назад

    Great tutorial, well eplained

  • @ellenaellena295
    @ellenaellena295 11 месяцев назад

    life saver thanks man prayers from pakistan

    • @SimonSezIT
      @SimonSezIT  11 месяцев назад

      You are very welcome! Glad it was helpful. 🙂
      🔥Check out our FREE 300+ hour training course playlist here 👉
      ruclips.net/p/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

  • @hendriekap3087
    @hendriekap3087 Год назад

    Great but how to combine Countif with distinct value

    • @SimonSezIT
      @SimonSezIT  Год назад

      To combine the Excel Countif with the distinct value formula, you would need to use the IFERROR function. The syntax for the IFERROR function is as follows:
      IFERROR(value, error_message)
      In this example, we would use the IFERROR function to check to see if the value entered into the cell is less than or equal to 10. If it is, we would use the distinct value formula to display the number of distinct values in the column that is equal to 10. If the value is not less than or equal to 10, we would use the countif function to count the number of cells in the column that are not less than or equal to 10. We would then use the IFERROR function to check to see if the countif function returned an error. If it did, we would display the error_message in the cell.

  • @shamusm9252
    @shamusm9252 2 года назад

    Amazing as always

    • @SimonSezIT
      @SimonSezIT  2 года назад

      Glad you enjoyed it! Thanks for watching 😃

  • @mohammedkassimsalim9351
    @mohammedkassimsalim9351 Год назад

    i cant download the exercise file. nothing comes in email

  • @AzeezBukola-ux7ls
    @AzeezBukola-ux7ls Год назад

    How do I download the exercise files

  • @ytpadyt
    @ytpadyt Год назад

    2:08:30 unique and distinct are wrong

  • @kelkelly9038
    @kelkelly9038 11 месяцев назад

    Thank you!!

    • @SimonSezIT
      @SimonSezIT  11 месяцев назад

      You are very welcome! Thanks for watching 🙂
      🚀 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

  • @AK_forex.
    @AK_forex. 11 месяцев назад

    bro my shopify store plan is 36 now.I want to active again,now when i want to active shoud i pay 36 now again because i payid one after 1 month and i deactive now i want to active again

  • @davidfoust
    @davidfoust Год назад

    Submitted my email, but never received the training files that I was suppose to have gotten. Anyone else having this issue?

    • @davidfoust
      @davidfoust Год назад

      Never mind. Used a different email and it worked fine. BTW I am very impressed with her teachings.

  • @kombaipattypacs
    @kombaipattypacs 11 месяцев назад

    i want to calculate time 60 mintue one hour at the same time 61 minutes is one hour one minutes, so i want to solve this problem

  • @aoa8869
    @aoa8869 Год назад

    Hi, I need to lump certain values to sum up. But these values will get updated from time to time. Ideally, values can be listed in a separate sheet or table to update any time. For example, Salary pay report contains pay details for each employees detailed as normal pay, annual leave, sick leave, these are in the same category called Salary; meal allowance, car allow etc are all under the Allowance. I need to set up a template to sum up Salary, Allowance etc. I think xlookup will meet my need, but my excel version only return the first value...what's your advice.