Excel Intermediate Tutorial

Поділитися
Вставка
  • Опубліковано 23 гру 2024

КОМЕНТАРІ • 119

  • @LearnitTraining
    @LearnitTraining  8 місяців тому +9

    Exercise Files: learnitanytime.com/p/exercise-files-excel-intermediate-tutorial-2024

    • @nebajordan268
      @nebajordan268 3 місяці тому

      Guu

    • @Makhehlane
      @Makhehlane Місяць тому

      great tut

    • @nothing7127
      @nothing7127 Місяць тому

      I want to ask one thing, when doing the sorting function i noticed that (,)isnt working for me, (;) this is the one working for me. Why is it like that?

  • @danielkaribi1248
    @danielkaribi1248 8 місяців тому +13

    The intermediate tutorial was a perfect sequel to the beginner tutorial...
    Thank you Joe Patti and Learnit for providing such valuable content...

  • @neeraj1180
    @neeraj1180 2 місяці тому +13

    thanks Joe buddy for providing this diamond quality content free of cost

  • @Abzarad
    @Abzarad 4 місяці тому +12

    Joe is even better than I expected

  • @DarkieMatters
    @DarkieMatters 8 місяців тому +5

    Thank you very much!!!😘

  • @Laura-eb8uz
    @Laura-eb8uz 4 місяці тому +3

    This was a good pace and really clear and logical to follow. Thanks Joe.

  • @PulkitonInternet
    @PulkitonInternet 3 місяці тому +4

    Thanks a lot from India.
    Joe Sir and Learnit Training
    Learned a Lot, Appreciate your generosity❤❤

    • @LearnitTraining
      @LearnitTraining  3 місяці тому

      You are very welcome! Thank you for watching!

  • @noorullahsayed3409
    @noorullahsayed3409 3 місяці тому +3

    Thank you for this comprehensive tutorial. It too useful for intermediate level.

  • @JeffreyLiu-k9d
    @JeffreyLiu-k9d 7 місяців тому +8

    Joe is even better than I expected!

  • @AhmedOmar-bc9kt
    @AhmedOmar-bc9kt 6 місяців тому +4

    Sometimes, use slicers instead of conditional formatting: It is easier and displays particular information. To use this tool, change data into table.
    For example, if you want to find out a house with 4 bedrooms, 3 bathrooms, and has the least price among all, check out with slicers.
    To fo find the least price, sort the "Listing price" as ascending order.

  • @johanruizcelis7991
    @johanruizcelis7991 3 місяці тому

    I didn't know about Flash Fill. I usually use functions like LEFT, RIGHT, MID combined with FIND and LEN. Flash Fill is wow. I don't have words for this, it's so amazing feature. Thanks a million for bring this up.

  • @luckybankz8569
    @luckybankz8569 3 місяці тому +2

    I’m gonna learn a lot from you thanks a lot just subscribed ❤

  • @ahmedabdelmaksoud2005
    @ahmedabdelmaksoud2005 Місяць тому +1

    Thank you very much for the valuable informations..Appreciate that

  • @MikeDillon
    @MikeDillon 5 місяців тому +1

    learning Excel has never been easier, thank you!

  • @asadusubov4991
    @asadusubov4991 3 місяці тому +1

    Thanks Joe super done ,..but ONE more thing if you could give the name of the soundtrack that starts at the beginning of the video , much appreciated, Regards

    • @LearnitTraining
      @LearnitTraining  3 місяці тому +2

      Oh man we have had that music licensed for so long that we just know it as intro. haha

  • @danielnorena4230
    @danielnorena4230 2 місяці тому +1

    Thank you ever so much! I have learned a lot.
    I did not find the SORT function on my Excel 365. Do you know the reason

  • @flaviadias9234
    @flaviadias9234 Місяць тому +1

    I Learned a lot with this tutorial.....amazing!

  • @TibetanStudentAbroad
    @TibetanStudentAbroad 2 місяці тому +1

    Thank you so much for the cource. Learned a lot. 🙏🙏🙏

  • @michaelhynds8035
    @michaelhynds8035 25 днів тому +1

    Fantastic content. Thank you for sharing.

  • @AnnaOlander-pn3rm
    @AnnaOlander-pn3rm 3 місяці тому +1

    These videos are SO helpful...THANK YOU!

  • @ianl1052
    @ianl1052 8 місяців тому +1

    Excellent video. Anything that can fill in gaps in my knowledge is welcome. Looking forward to Friday's launch of Advanced.* Thanks for your work.

  • @gkprasath89
    @gkprasath89 Годину тому

    Nice tutorial. Keep up your Good work !!

  • @lisaorubo5070
    @lisaorubo5070 5 місяців тому +1

    Thank you so much. Please where can i get projects to do so i can build my portfolio

    • @LearnitTraining
      @LearnitTraining  5 місяців тому +1

      Upwork and Fivver are great places to put yourself out there and get experience

  • @mohammadvaziri1504
    @mohammadvaziri1504 7 місяців тому +1

    Thank you so much for your informative and excellent presentation.

  • @resumebynelson
    @resumebynelson 3 місяці тому

    Can you help with a list of how to watch all these videos from beginner to advanced so I won't lost my pace. Thanks

  • @geget988
    @geget988 4 дні тому +1

    this is very digestable good job

  • @AliceABetti
    @AliceABetti Місяць тому +1

    That was really helpful! Thank you :)

  • @julienPELE
    @julienPELE 21 день тому

    Hello Sir thanks for the tutorial. At 11 :00 how can we automatically fill Last, First if the person have only one name? I do not master the "if" condition.

  • @rohitpandey832
    @rohitpandey832 2 місяці тому

    Don't understand how did you locked the header - 5:40?

  • @sisildyn9198
    @sisildyn9198 3 місяці тому +2

    i can't find the data we are working with. do i have to pay for this section please

    • @LearnitTraining
      @LearnitTraining  3 місяці тому

      learnitanytime.com/p/exercise-files-excel-intermediate-tutorial-2024

  • @mehdirhobaibi1702
    @mehdirhobaibi1702 2 місяці тому +1

    Thanks, Joe for your explication

  • @QuinnPisani
    @QuinnPisani 2 місяці тому +1

    Thank you very much.

  • @akshitathakur6124
    @akshitathakur6124 5 місяців тому +1

    Joe thanks much....u are a savior❤❤❤

  • @marinamihic8416
    @marinamihic8416 21 годину тому

    What if I dont get Quick Analysis icon after marking the table range?

  • @laser00
    @laser00 8 місяців тому +1

    what if I dont have the quick analyse tool in excel ( free 365 microsoft tools) ? can somebody help, I don't have the pivot tables aswell in excel

  • @ahmadhooman
    @ahmadhooman 5 місяців тому +1

    you are the best bro. thanks a lot of

  • @KSDCACADEMY
    @KSDCACADEMY 2 місяці тому

    is the sort function only for Excel 365?

  • @kauancorte541
    @kauancorte541 7 місяців тому +1

    Amazing tutorial!

  • @MahadHadadi
    @MahadHadadi 24 дні тому +1

    Thanks G

  • @mahfuzulhaque5441
    @mahfuzulhaque5441 4 місяці тому +1

    Thanks a lot!!

  • @omiology5613
    @omiology5613 2 місяці тому +1

    Thanks, I am enjoying learning Excel, is there any opportunity to get a free certificate?

    • @LearnitTraining
      @LearnitTraining  Місяць тому

      Certificates can be earned at www.learnitanytime.com

  • @sherda7079
    @sherda7079 4 місяці тому +1

    Thanks a lot🤝

  • @aliciamoggy3374
    @aliciamoggy3374 6 місяців тому +1

    great am learning a lot. Thanks

  • @aniketbhateja9638
    @aniketbhateja9638 2 місяці тому +1

    Awesome 👌

  • @muhammedsalih6958
    @muhammedsalih6958 6 місяців тому

    There is no phone number option available in format cells... Could u pls help!!

  • @Aybmhm
    @Aybmhm 2 місяці тому +2

    15:00 right here will be 10/10/2024 10:00 PM

  • @habibullah-ff8om
    @habibullah-ff8om 5 місяців тому

    Thank You Very Much

  • @TheDevilscrap
    @TheDevilscrap 18 днів тому

    Just wonderful :)

  • @arayamasreshaferede4138
    @arayamasreshaferede4138 3 місяці тому

    Thanks for teaching me excel, but the data on exl worksheet is unable to see

  • @Safe_n_Him
    @Safe_n_Him 2 місяці тому

    Why won't the error msg work for my phone number if more than 10 digits?

  • @vedawhisper
    @vedawhisper 5 місяців тому +1

    thanks , you are awsome

  • @khalidmohamed6888
    @khalidmohamed6888 День тому +1

    Has anyone experienced that the SORT function isn't not working!?
    Nor the UNIQUE one

  • @Israeslam
    @Israeslam 5 місяців тому +3

    I dont have sort function option in my excel why 🙄

    • @LearnitTraining
      @LearnitTraining  5 місяців тому

      Sort is only available on the Microsoft 365 versions of Excel

  • @victoraldin2305
    @victoraldin2305 7 місяців тому +1

    Where can I find the exercise files?

    • @LearnitTraining
      @LearnitTraining  6 місяців тому +1

      learnitanytime.com/p/exercise-files-excel-intermediate-tutorial-2024

  • @bavemustafa4054
    @bavemustafa4054 4 місяці тому +1

    You are the bestttt

  • @rizwanaliali71rizwanali30
    @rizwanaliali71rizwanali30 4 місяці тому +1

    Superb

  • @yoosh0
    @yoosh0 3 місяці тому

    The fill opened in wps office and i didn't know that excel is free in WPS office?

  • @REHANKHAN-kn6iy
    @REHANKHAN-kn6iy 4 місяці тому +1

    i don't have unique option in my excel why

    • @LearnitTraining
      @LearnitTraining  4 місяці тому

      The Unique function is only available on Excel 365 and Excel 2021.

  • @maditationmusic3676
    @maditationmusic3676 4 місяці тому

    Sir can you provide Excel certificate please.

  • @studirtgerman
    @studirtgerman 6 місяців тому +1

    how can i strart it ?

  • @live-music-z
    @live-music-z 8 місяців тому

    @0:14 0:17 0:17 @😊

  • @muhassan8021
    @muhassan8021 2 місяці тому

    The exercise files do not work with me

    • @LearnitTraining
      @LearnitTraining  Місяць тому

      We just tested the link and files. They are currently working

  • @victoraldin2305
    @victoraldin2305 7 місяців тому +1

    got it.

  • @mariogutierrez7336
    @mariogutierrez7336 7 місяців тому +1

    Muchas Muchas Gracias ❤❤

  • @designhub360customapparel
    @designhub360customapparel 13 днів тому +2

    I need my $92K back from webster because now I am seeing why I failed accounting 1.

    • @LearnitTraining
      @LearnitTraining  13 днів тому

      We are glad you found so much value in our videos!

  • @ShOrTdAy7946
    @ShOrTdAy7946 4 місяці тому +1

    Joe is even better than I expected