Google Sheets Advanced Tutorial

แชร์
ฝัง
  • เผยแพร่เมื่อ 4 ต.ค. 2024

ความคิดเห็น • 509

  • @LearnitTraining
    @LearnitTraining  11 หลายเดือนก่อน +9

    How to edit the sheet:
    Exercise Files: bit.ly/3udealu
    Click the link
    Select File
    Select Copy
    Or
    Click the link
    Select File
    Select Download
    Choose the format you wish to download
    Click Save

    • @suzieogeto6319
      @suzieogeto6319 8 หลายเดือนก่อน

      Thank you very helpful!

  • @ceciliafarkas2705
    @ceciliafarkas2705 2 ปีที่แล้ว +42

    You are an amazing teacher. Perfect speed, easy to follow instructions, straight logic, no unnecessary repetition. Loved it!

  • @DivyanshuBansal-c3l
    @DivyanshuBansal-c3l หลายเดือนก่อน +1

    Thanks for the great walkthrough! You have an amazing teaching style, with a coherent thought process and realistic examples. The presentation had a logical flow, and the way you explained each concept, building on the previous ones, was excellent. Thanks, Joe! 😊

  • @RiskyInvestor001
    @RiskyInvestor001 ปีที่แล้ว +2

    learned a job skill in 2 hrs, easy & quick, thanks joe

  • @romyhistorillo9757
    @romyhistorillo9757 2 ปีที่แล้ว +1

    Learning from excel to google sheet wasn't a steep learning curve for me because of this tutorial. Thanks so much for creating informative videos.

    • @LearnitTraining
      @LearnitTraining  2 ปีที่แล้ว

      You're very welcome! We do have a video coming soon for Excel Users switching over Google Sheets as well.

  • @faheemqadri5457
    @faheemqadri5457 2 ปีที่แล้ว +2

    Great way to teach in a simple way with details. No time waste like others. Big thank you from India

  • @MGSV626
    @MGSV626 ปีที่แล้ว +2

    What an excellent tutorial! I learned so much ... and I thought I knew Sheets well. Thank you

  • @arindambasak5261
    @arindambasak5261 2 ปีที่แล้ว +2

    I love you Joe ,your voice is so good and the way you minutely discussed so many topics in this video is just amazing ,I am loving to learn from you :)

  • @kulmwuhn
    @kulmwuhn 4 หลายเดือนก่อน +2

    Thank you for sharing this! It has helped me so much :)

  • @ridmagamage3799
    @ridmagamage3799 ปีที่แล้ว +1

    This is brilliant! I learned everything from the scratch! Keep up the good work! Thank you so much!

  • @channibedi
    @channibedi ปีที่แล้ว +5

    An excellent tutorial with exceptionally perfect presentation skills! No time waster, to the point. Much appreciated!

  • @Veganbhavna
    @Veganbhavna ปีที่แล้ว +2

    Thank you for making a great tutorial that was easy to understand. You are an amazing teacher!

  • @mrCetus
    @mrCetus 2 ปีที่แล้ว +2

    Thanks a lot. Very informative. Inspiring. Revealing. Impressive. Interesting. Very eager to learn many more from you in the days to come. Very useful for students & professionals.

  • @akshatmeena1668
    @akshatmeena1668 ปีที่แล้ว +3

    For those people who check the ocmments to see if the video is fit to watch/learn. Then, heer's my testimonial, Just go for it. This one is surely to make to grasp each and everything easily.

  • @mahfuzulhaque5441
    @mahfuzulhaque5441 หลายเดือนก่อน +1

    Great learning with you ! Thanks a lot !

  • @is20206
    @is20206 2 ปีที่แล้ว +55

    It would be really nice if you included a link to a practice sheet like yours to follow along. Thank you, great content!

    • @alinaqi1616
      @alinaqi1616 2 ปีที่แล้ว +1

      same

    • @LearnitTraining
      @LearnitTraining  2 ปีที่แล้ว +11

      Added!

    • @blessedowo1958
      @blessedowo1958 2 ปีที่แล้ว +1

      1:19

    • @ingridjocelynab1
      @ingridjocelynab1 2 ปีที่แล้ว +5

      @@LearnitTraining where? there is not sorting sheet in the file

    • @haydnburke6171
      @haydnburke6171 2 ปีที่แล้ว +3

      @Learnit Training The dataset is missing the sorting, filter etc tabs

  • @mikhailrudenko3347
    @mikhailrudenko3347 ปีที่แล้ว +1

    Hey Joe!
    Thank you very much for your courses about Google Sheets! They are pretty useful!

  • @darkdevil2464
    @darkdevil2464 9 หลายเดือนก่อน +1

    Thanks for this great course. I learn a lot from this course. Very very thanks 👏👏

  • @aritovi
    @aritovi ปีที่แล้ว +1

    Great course, very good teacher.

  • @karamshahrour4836
    @karamshahrour4836 ปีที่แล้ว +1

    Perfect is the only word that describe your videos ,thanks a lot for this amazing work

  • @SwapnilBhat
    @SwapnilBhat ปีที่แล้ว +1

    This was so insightful. You have definitely made the viewers day. Thank you so much for sharing 🙏

  • @winwinis3483
    @winwinis3483 ปีที่แล้ว +2

    Extremely well organised and presented - no fluff - brilliant thanks

  • @LouiseMorgan-techteacher
    @LouiseMorgan-techteacher 9 หลายเดือนก่อน +1

    Thanks for this awesome video. I have been using it in chunks to help my students!

  • @ramimhaque249
    @ramimhaque249 11 หลายเดือนก่อน +1

    Thank you for this amazing class. I learned a lot. Thank you again and god bless you.

  • @googlegoogle1610
    @googlegoogle1610 ปีที่แล้ว +1

    nice video where no fluffs, perfect speed, and many more good things

  • @nabilmachani8220
    @nabilmachani8220 ปีที่แล้ว +1

    thanks so much for this perfect course

  • @jsjb3468
    @jsjb3468 ปีที่แล้ว +2

    Thanks bro. Google sheets was explained smoothly by you in a way easy to catch on. Very beneficial tutorial. 😘💗

  • @CoachShaunie
    @CoachShaunie 10 หลายเดือนก่อน +1

    Wow, Joe. Thank you. You are a phenomenal teacher.

  • @MsMadlenne
    @MsMadlenne 3 ปีที่แล้ว +6

    Great video. I always was struggling with Google Sheets, now I believe it should be easier to work on them. I need to make myself similar file and just exercise. Thank you so much, Joe!

  • @Rajagopalsprabhu
    @Rajagopalsprabhu 3 ปีที่แล้ว +6

    Kudos! Appreciate your clear presentation, professional and methodical, step by step which makes grasping easier.

  • @MizunoIronMan
    @MizunoIronMan 2 ปีที่แล้ว +1

    Clear, concise and highly informative. Thank you ,
    .

  • @WatchingBadTV
    @WatchingBadTV 2 ปีที่แล้ว +1

    god bless you for making this video. You just saved my brain.

  • @FreeFireEntertainment
    @FreeFireEntertainment ปีที่แล้ว +1

    Thanks for your explanation 😊

  • @mahmoudezz5208
    @mahmoudezz5208 ปีที่แล้ว +1

    love your teaching style

  • @siyuanliu1486
    @siyuanliu1486 2 ปีที่แล้ว +1

    Appreciate for you turorial!

  • @JoeTao
    @JoeTao ปีที่แล้ว +1

    Wow this is amazing teaching, thank you so much

  • @DanOfek
    @DanOfek ปีที่แล้ว +1

    THIS WAS AMAZING. Thank you so much, explained beautifuly and very useful. Boosted my knowledge. Shared with the entire team.

  • @bartonylee88
    @bartonylee88 3 ปีที่แล้ว +2

    You are a really good teacher. The video was easy to follow.

  • @prateeksharma5304
    @prateeksharma5304 28 วันที่ผ่านมา +1

    Nice work Joe!

  • @ramizkhan2411
    @ramizkhan2411 3 ปีที่แล้ว +1

    Basic Information is available in an easy and Clear way. Thanks

  • @ginalynpinos2484
    @ginalynpinos2484 2 ปีที่แล้ว +2

    Thank you so much! This is really helpful, concise and objective presentation.

  • @delpill
    @delpill 3 ปีที่แล้ว +5

    Great job! It's a very clear tutorial and a great effort. Thank you !

  • @Sociography00
    @Sociography00 ปีที่แล้ว +1

    Thanks!! it is extremely helpful

  • @halitsanr4439
    @halitsanr4439 หลายเดือนก่อน +1

    Thank you for your efforts !!!

  • @lepalmpremium2288
    @lepalmpremium2288 ปีที่แล้ว +1

    Thank you for sharing this amazing knowlegde with us!!! It really helped me a lot!!! You're awesome!!!

  • @sepandsarmadi5925
    @sepandsarmadi5925 3 ปีที่แล้ว +2

    very much enjoyed it. thankyou very much. it was very organized and well planned.

  • @NjonjoNtui
    @NjonjoNtui หลายเดือนก่อน +1

    Thanks again for this great video.

  • @luisguerreropenaranda3618
    @luisguerreropenaranda3618 ปีที่แล้ว +1

    Is the best tutorial that I've seen. Now, I can work better.

  • @BenDieselBasicAutomotive
    @BenDieselBasicAutomotive ปีที่แล้ว +1

    Wow.... new knowledge for me... Thank you very much and more power to you.

  • @Brinky645
    @Brinky645 ปีที่แล้ว +2

    Thank you so much sir I am Really appreciate to tutorial 😍

  • @konstantinorlovskii8719
    @konstantinorlovskii8719 9 หลายเดือนก่อน +1

    Thank you so much! I loved your explanation. May you please make your exercise files editable for everyone? I can only view them now.

    • @LearnitTraining
      @LearnitTraining  9 หลายเดือนก่อน

      Please feel free to download a copy to edit.

  • @amagdenovski
    @amagdenovski 2 ปีที่แล้ว +3

    Really appreciate the great content you showcased here. Been using Google Sheets for years and didn't know almost any of this. Or at least not nearly to the point that you explained it. Thank you so, so much!

  • @TheAmazingKris
    @TheAmazingKris ปีที่แล้ว +1

    Thank you for sharing in details and how-to in this video. Wanted to know it´s benefits and how I can be better within the Google Sheets opportunities and especially those formulas.
    Can or will always use this one for advice in the future.

    • @LearnitTraining
      @LearnitTraining  ปีที่แล้ว

      Thank you for the kind words!

    • @TheAmazingKris
      @TheAmazingKris ปีที่แล้ว

      @@LearnitTraining Perhaps a video, where you create those formula in a worksheet, where we can create the formula as well on our own template ?

  • @willrodriguez1224
    @willrodriguez1224 2 ปีที่แล้ว +1

    Thanks so much. This was an excellent training!

  • @sushants149
    @sushants149 2 ปีที่แล้ว +2

    Thanks for your video. Can u share some exercise for practice if u have

    • @LearnitTraining
      @LearnitTraining  2 ปีที่แล้ว

      The link to the exercise files is in the video description

  • @April-sf1vd
    @April-sf1vd 2 ปีที่แล้ว +1

    Thank you much for clear and easyo to follow tutorial.

  • @shwetabajpai6952
    @shwetabajpai6952 2 ปีที่แล้ว +1

    WONDERFUL EXPLANATION....THANKS A TON

  • @bartoszbereszko
    @bartoszbereszko 2 ปีที่แล้ว +1

    Good tutorial. Thank you

  • @Lifewithpradip
    @Lifewithpradip 2 ปีที่แล้ว +1

    Thank You So much for this course.

  • @s455am
    @s455am ปีที่แล้ว +2

    Thank you ❤

  • @arnellcarmichael635
    @arnellcarmichael635 2 ปีที่แล้ว

    Awesome tutorial about various functionalities within Google Sheets! Thanks a ton!

  • @MahendarKumar-fb2yc
    @MahendarKumar-fb2yc ปีที่แล้ว +1

    Really love the way you presented all things, an amazing experience of learning with you Sir, thanks for the great content.

  • @catoy2627
    @catoy2627 3 ปีที่แล้ว +1

    Thank You

  • @Jesuslovesyoumore-yes
    @Jesuslovesyoumore-yes 3 ปีที่แล้ว +1

    I like this. You talk fast and concise💕

  • @Smartienl72
    @Smartienl72 3 ปีที่แล้ว +6

    Thank you for the clear explanation. I miss this skill on many education channels on TH-cam.
    I also have the question whether this sheet can be shared.

    • @adios04
      @adios04 3 ปีที่แล้ว

      Yes it can, click on the share button at the upper right. This was in fact shown in the video at about 1:25:00

  • @RahulDas-gk7lk
    @RahulDas-gk7lk 11 หลายเดือนก่อน

    You are amazing thanks for teaching us😊😊

  • @brilliantpy
    @brilliantpy ปีที่แล้ว +1

    Thank you for creating a very helpful and easy to follow video! Great job!!! :) :) :)

  • @marietvtv
    @marietvtv 3 ปีที่แล้ว +1

    I learned alot and it kept me company when i was cleaning, so my place is clean and i learned a new information. Thanks for that 1hr of lecture! 🙌

  • @greatrespect1549
    @greatrespect1549 2 ปีที่แล้ว +1

    you really sound like sheldon cooper.
    btw thanks for this wonderful video..

    • @LearnitTraining
      @LearnitTraining  2 ปีที่แล้ว

      Thank you great respect! Joe takes that as a compliment!

  • @alanj9849
    @alanj9849 3 ปีที่แล้ว +2

    Excellent overview of advanced functions. Thanks.

  • @mereymeiram
    @mereymeiram ปีที่แล้ว +3

    In the exercise files there are no:
    Sorting
    Filtering
    Charting
    Sparkliness
    Conditional Formatting
    Pivot Table
    If you provide us the video can you please provide proper exercise files too?

  • @MoodyAlshehaby
    @MoodyAlshehaby ปีที่แล้ว +1

    Amazing work brother, really appreciate it!! Thanks.

  • @SatyamValluru
    @SatyamValluru 2 ปีที่แล้ว +1

    Thanks for all your efforts. Quite informative and useful.

  • @nishantbal9225
    @nishantbal9225 2 ปีที่แล้ว +1

    thanks a bunch for the video. Really appreciate your time and energy u spent for sharing your knowledge with us..

  • @davidmmmc
    @davidmmmc 2 ปีที่แล้ว +2

    Thank you! however could you include the practice sheet for sorting, filtering, the first one your are using?

  • @saikumargoud8952
    @saikumargoud8952 2 ปีที่แล้ว +1

    Thank you so much Joe Patti 👍

  • @alekdaniels
    @alekdaniels 2 ปีที่แล้ว +1

    This is great. I thought I know everything about Google Sheets but that Macro recording part just blew my mind. Would really save so much work. Not gonna tell my boss about this so I get free time. Work smart hahahaha jk

    • @LearnitTraining
      @LearnitTraining  2 ปีที่แล้ว

      Hi Alek! We are glad we made your life a little easier!

  • @juancruzdeelias7050
    @juancruzdeelias7050 4 หลายเดือนก่อน +1

    Hey man this is great!!! I just wanted to clarify something you seemed to miss when you were explaining the VLOOKUP function or maybe i'm wrong and you can correct me!! When you are using false in the last argument of the function it's not necessary to have the data in ascending order.
    For example, im using this function in my bakery spreadsheet to calculate my recipes and more. I have a sheet with the list of ingredients, the price and the weight of each. And then, i have a recipe calculator that i duplicate every time i want to calculate a new recipe with the vlookup function for every price and weight of ingredient searching by the name of every ingredient in my page with the list of ing. So everytime a price changes i can change it only in my list of ingredients sheet and it will automaticly change in the other pages.
    I hope im right jajajsjsjj if not i'll have to change everything!!!

    • @LearnitTraining
      @LearnitTraining  4 หลายเดือนก่อน +1

      If it works for you it works

  • @virginiasmall6420
    @virginiasmall6420 2 ปีที่แล้ว +1

    I love that you have provided a document to follow along with. I'm a little lost though, I seem to be missing Filtering through to Pivot tables in the sheets provided. I'm still getting some good info, but it's a bit harder to practice and cement things in my head.

  • @elevatedascent
    @elevatedascent 2 ปีที่แล้ว +13

    Really love your teaching style, one criticism would be it is hard to see on small screens, it would be nice if you could zoom in a bit, especially if the rest of the canvas is mostly blank rows. 🙂

  • @Panda-pp8xl
    @Panda-pp8xl 2 ปีที่แล้ว +1

    thanks for this helpful video

  • @narayananseshagirirao2569
    @narayananseshagirirao2569 2 ปีที่แล้ว +1

    Thanks very much for an excellent presentation.

  • @MohammadAli-jv1pw
    @MohammadAli-jv1pw 2 ปีที่แล้ว +1

    you are an amazing teacher. It is so informative video .

  • @mreighties2860
    @mreighties2860 3 ปีที่แล้ว +16

    Hello,
    How can I access the files so I can work side-by-side using the sheet file and watching the video? Do I need to join?
    Great videos btw!

  • @thuyvuong9874
    @thuyvuong9874 3 ปีที่แล้ว +11

    Do you have a file to download to work with this tutorial? This would be really useful in learning the material.

    • @LearnitTraining
      @LearnitTraining  2 ปีที่แล้ว

      The link to the exercise files is in the video description

  • @danielleshelbourne220
    @danielleshelbourne220 ปีที่แล้ว

    OMG what an amazing lesson! Holy cow I learned so much. This lesson was presented so well and totally demystified spreadsheets, just amazing. Thank you so much for making this available! I can’t believe it’s free! 🙏

    • @LearnitTraining
      @LearnitTraining  ปีที่แล้ว +1

      Thank you so much for the kind words!

  • @ChuckMeinecke
    @ChuckMeinecke 3 ปีที่แล้ว +1

    Very informative and a great presentation. Thanks Joe for you time.

  • @esanariam
    @esanariam 2 ปีที่แล้ว +1

    Great Video, Thank you very much!!

  • @okon1624
    @okon1624 ปีที่แล้ว +1

    You’re awesome..
    please can you make a video of ‘how you insert/put the currency symbol’ in that “note”, that talks about department bonus.
    Thanks..

    • @LearnitTraining
      @LearnitTraining  ปีที่แล้ว +1

      We will look into it!

    • @okon1624
      @okon1624 ปีที่แล้ว

      @@LearnitTraining ohh thanks
      57 minutes precisely.

  • @Sobitsaid
    @Sobitsaid ปีที่แล้ว +1

    When I was watching this video without looking at comments, I already know that the comments are gonna be super positive. Thanks a lot. If you read my comment, would you help me find out a function for "click" actions? - like if you just click a column, you get a checkmark symbol to be appeared (no checkbox).

  • @Jameel04Subhani
    @Jameel04Subhani ปีที่แล้ว +1

    Thank U Very Much.

  • @OmegaRejectz
    @OmegaRejectz ปีที่แล้ว +1

    Wow! This video is great.

  • @SaskicaP
    @SaskicaP 3 ปีที่แล้ว +5

    Thank you very much for presenting the information in such a precise and detailed way. I truly enjoyed exercising with you. Good job!

  • @mullahraheil
    @mullahraheil 3 ปีที่แล้ว +4

    A wonderful tutorial about Google Sheets. Thank you very much for the time and effort. It cleared a couple of things for me.
    However, just a small edit - @ 01:02:10, you mentioned that the data needs to be sorted for _VLOOKUP._ _VLOOKUP_ and _HLOOKUP_ functions don't need the data to be sorted. That condition only applies when using the _LOOKUP_ function.

  • @undertonebg
    @undertonebg 2 ปีที่แล้ว +1

    Extremely useful tutorial. The information was presented in a really simple and easy to understand way, thank you.

  • @hasnanadila3419
    @hasnanadila3419 2 ปีที่แล้ว +1

    thank you so much!

  • @imprezatheme6627
    @imprezatheme6627 2 ปีที่แล้ว +1

    That was really helpful. Thanks

  • @sadanandsinghchauhan1143
    @sadanandsinghchauhan1143 2 ปีที่แล้ว +1

    Awesome tutorial!

  • @calmwithsound
    @calmwithsound 2 ปีที่แล้ว +2

    I appreciate the sample worksheet so we can follow along, at the same time, I hope someone from your team can take a look at the tabs cause we're missing quite a lot. It doesn't have the sorting, filtering and pivot, if I may name a few. Thanks again!

    • @LearnitTraining
      @LearnitTraining  2 ปีที่แล้ว +2

      Hi Jey C! Looking into it!

    • @calmwithsound
      @calmwithsound 2 ปีที่แล้ว

      @@LearnitTraining thank you very much!

    • @tes33720
      @tes33720 ปีที่แล้ว

      @@LearnitTraining A ton of them is still missing

  • @abdullahalnaiem3501
    @abdullahalnaiem3501 3 ปีที่แล้ว +1

    Your tutorial is very helpful

    • @LearnitTraining
      @LearnitTraining  3 ปีที่แล้ว +1

      Thank you for the kind words Abdullah!