10 Google Sheets Tips You DON'T Want to Miss

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

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

  • @LeilaGharani
    @LeilaGharani  11 месяцев назад +1

    Discover more practical Google Sheets tricks like the ones in this video by joining our full "Google Sheets Masterclass" here 👉 www.xelplus.com/course/google-sheets/

  • @mlittlemlittle2966
    @mlittlemlittle2966 3 года назад +5

    I used Google sheets for some time, still found tips I didn't know. Great job and thanks!

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

      Glad it was helpful!

    • @didiko3466
      @didiko3466 3 года назад

      Thanks you very much! I am from myanmar.

    • @bripedrozo
      @bripedrozo 3 года назад

      @Rehan Ahmed Informative & Entertainment Jajajajajaja

  • @vijayarjunwadkar
    @vijayarjunwadkar 3 года назад +39

    The "Excel Queen" has conquered the "Rival" too, and we are benefitted in the process! Best tips! 👌 Thank you! 😊👍

  • @AJ-et3vf
    @AJ-et3vf Год назад +2

    Very nice video indeed. Three (3) great things I learned from here: 1) the scrolling table chart, 2) the open-ended references which allow me to account for future data, and 3) the dynamic filter functions!

  • @aqpogi
    @aqpogi 3 года назад +3

    This gives a me a good reason to shift from excel to sheets. Impressive tips.

  • @mikeg1226
    @mikeg1226 3 года назад +6

    Leila. I used google sheet instead of desktop excel because I used a stock macro pull and could just refresh instantly.
    Each time sheet was opened stock data was live. Thanks so much for your tips on all these. I use MS tricks at work even though I do IBM mainframe coding. Excel is very big as a validator and data extractor

  • @evanlloydsagala6980
    @evanlloydsagala6980 3 года назад +5

    Solid!!! Can't wait to see you doing Google Data Studio

    • @BrianBullington
      @BrianBullington 3 года назад

      That would be great. I'm getting deep into Data Studio, but there just aren't the same kind of google-able supports out there yet.

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

    The "Publish to Web" feature is absolutely awesome- EXACTLY what I've been needing for a particular project of mine. Thanks Leila!

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

    Great video. No time wasted. Just features. Thank you.

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

    Open ended cell references and column stats tips were really good one.

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

    Leila, you do an amazing job of conveying information in a simple and easy to follow manner. You are the best!

  • @Samba-F
    @Samba-F 2 года назад

    I learn something NEW everytime I watch your video. Thank you!!!!!!

  • @edwinjonah
    @edwinjonah 3 года назад +4

    Your videos are always awesome! They add so much value. Keep it up!

  • @houssemhizi1011
    @houssemhizi1011 3 года назад +1

    Never seen someone explain sheet like she did well done
    I use excel its hard to me to change to sheets but i will try to learn it in the summer nice job

  • @JonErikKvamme
    @JonErikKvamme 3 года назад +3

    Awesome tips. Just the right level and straight to the point 😃

  • @margulan111
    @margulan111 3 года назад +1

    Publishing the document to our web site would be very helpful and convenient. Thank you so much!

  • @venkatiyer7459
    @venkatiyer7459 3 года назад +1

    Hello Mam ... I have started using google sheets recently for monitoring stocks ... explored the functions which are available through your excel videos [using office 365] ... I am indebted to you for teaching me virtually ... thanks a lot and God Bless You

  • @AJ-et3vf
    @AJ-et3vf Год назад

    wow! The scrolling table chart blew my mind! Jaw-dropping feature! Thank you!

  • @fadi.droubi
    @fadi.droubi 3 года назад +8

    Fantastic Leila! you helped me to switch completely to g-sheets, especially that files do NOT count against my quota size. Thanx a lot

  • @aperkinsvt
    @aperkinsvt 3 года назад +1

    Thank you Leila - I use Sheets a lot but did not know about several of these features.

    • @LeilaGharani
      @LeilaGharani  3 года назад

      Glad you found something new, Andy.

  • @DevanshuJain-n4n
    @DevanshuJain-n4n 26 дней назад

    Great information ma'am. As i am going through every other video, that you have posted, so much to learn. "Thank you" is such a small word, but still thanks a lot. Huge Respect and love from INDIA.

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

    Thanks a lot. Very well explained and demonstrated. Great examples.

  • @mosadiq123
    @mosadiq123 3 года назад +1

    Really good 👍👍👍

  • @thierryhoornaert9950
    @thierryhoornaert9950 3 года назад +1

    I use Google Sheets primarily to mass-(Google) translate from one language to others.
    Thanks for the tips.

    • @hammockmonk
      @hammockmonk 3 года назад

      Then you might like what I’m doing: I use IMPORTXML to data scrape sample sentences and synonyms from the web for a given word in a foreign language. It’s incredibly powerful!

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

    This one is worth keeping around. Just happens that 90 percent of these I need for a project right now. Well done!

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

    Always informative and helpful. Thanks 🙏

  • @hammockmonk
    @hammockmonk 3 года назад +1

    Brilliant! Thanks!

  • @olipeeeeee
    @olipeeeeee 3 года назад +12

    🤔 I'm starting to love Google Sheets. 🤫

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

    Very helpful, thank you

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

    Awesome video packed with useful tips! Thank you

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

    Amazing tricks, thank you for shared it!!!

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

    Thank you! Really useful!

  • @benign39
    @benign39 3 года назад

    I'm new to google sheets. You always make it easy to learn, thank you.

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

    Thank you so much. this tutorial helped me a lot. 😊😊

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

      Happy to hear it was helpful!😊

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

    Thanks! As a newbie, do you know if I can track birthday rewards using Google Sheets?

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

    Great video, very informative. I am starting to make the transition into Google sheets instead of Excel, so thank you again for the tips.

  • @lawrencekazibwe9751
    @lawrencekazibwe9751 3 месяца назад

    Thanks Leila,it's very informative 🎉

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

    1:07 HOLY SH...!!!!!!!!! THANKS YOU FOR DISCOVERING THIS TO ME!!!

  • @roiipatterson
    @roiipatterson 3 года назад

    Great video. Had no idea all the powerful yet simple functions. Tks!

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

    This video is a goldmine

  • @chrism9037
    @chrism9037 3 года назад +1

    Thanks Leila, great tips

  • @ifineNick
    @ifineNick 3 года назад

    so simple but AMAZING!!

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

    Woah! I thought I was decent
    This is very helpful!

  • @g.muthukumar
    @g.muthukumar 2 года назад

    Very useful functions, thanks for this videos

  • @jamilhfl
    @jamilhfl 3 года назад

    Tremendous, great
    Love you
    Very useful video
    Google Sheet 👍

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

    Wow, this video was so helpful! Thank you for sharing your knowledge and expertise on this topic

  • @cattuongtramnguyen7552
    @cattuongtramnguyen7552 3 года назад

    Thanks your video. It helps me a lot ❤️

  • @reijelcueva5208
    @reijelcueva5208 3 года назад

    Thank you Leila Gharani! You are Brilliant!

  • @nirmalasenerath
    @nirmalasenerath 3 года назад

    Thanks! very useful tips...

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

    Very informative
    😊

  • @sunil1229
    @sunil1229 3 года назад +1

    Great learning video

  • @jacquelines3093
    @jacquelines3093 3 года назад +1

    Amazing video Leila - great tips and many features I was not aware of. Thanks!!!

  • @dashnv7933
    @dashnv7933 3 года назад

    Really useful, Thanks!

  • @badalsinha3106
    @badalsinha3106 3 года назад +1

    Tip no. 3 is very useful since we work in Google drive so we can create a link and share it to the clients so that they can access the data without login into drive👍

  • @eraoctaviani2931
    @eraoctaviani2931 3 года назад

    Amazing... Good learning... And what do you make to excel?

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

    Great video thanks 🙂

  • @schalkvanheerden6151
    @schalkvanheerden6151 3 года назад

    Thank you so much for your videos. You have been an immense help!

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

    Amazing video Leila😊

  • @MominHashir
    @MominHashir 3 года назад

    OMG, I didn't knew the true worth of me. Almost all the tips I knew. You are awesome. Thank you

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

    Really helpful... Now I look at google sheets as a step up from excel except keyboard shortcuts to use menu functions like Alt + H + H = Color
    Basically it's like while using Google spreadsheets I am again back to using mouse alot ! Which I believe affects overall time taken to complete a task :p

  • @anthonysais2580
    @anthonysais2580 3 года назад +1

    Excellent and informative Leila. And always beautiful to watch🙂!

  • @benyameenperikala6932
    @benyameenperikala6932 3 года назад

    Very good explanation and very useful to me. I am new to google sheet but you made easy to understand. Thank you very much

  • @AJ-et3vf
    @AJ-et3vf Год назад

    Awesome video! Thank you!

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

    Yes osm features, i learnt some tricks its amazing thnks laila

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

    Awesome. Love it!

  • @jean-francoisregnard4889
    @jean-francoisregnard4889 3 года назад

    Ms Gharani is just fantastic !

  • @stevew4079
    @stevew4079 3 года назад +4

    Leila, re: embedding a sheet to a web page...can this be embedded into a members site behind a log in? That way it’s still private except to those with the log in? Is that correct?

  • @ricardoelizondocr
    @ricardoelizondocr 3 года назад +1

    Wooow this content is amazing🤩! I just came to your channel, and I'm already a loyal follower, thanks a lot! 🙌

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

    Thank you 💕

  • @shadrackawunyo7786
    @shadrackawunyo7786 3 года назад

    Very wonderful. I hardly use google sheets but you are making me take a 2nd look. It's potentials are amazing. Thanks for sharing this

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

    Thank you for showing us these hacks! It's going to be very helpful in my law firm and other organizations.

  • @amitvijayan7949
    @amitvijayan7949 3 года назад

    Amazzzing..! your videos are really good

  • @2000sunsunny
    @2000sunsunny 2 года назад

    Thank you for great video. We have started to use in our hotel finance department . We dont send daily excel files/reports anymore :)

  • @jonathanprunier2368
    @jonathanprunier2368 3 года назад

    Super helpful a specific, well done and thank you :)

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

    Thank you... This was quite informative. I will watch few more videos about google sheets on your channel... #Quality_Content

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

    I would have added the QUERY function too. I use it all the time, even over Filter quite often. So much moree versatile, and powerful.

    • @YasmeenKhan-lu2pl
      @YasmeenKhan-lu2pl 2 года назад

      I

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

      That if thou shalt confess with thy mouth the Lord Jesus, and shalt believe in thine heart that God hath raised him from the dead, thou shalt be saved. 10 For with the aheart man bbelieveth unto righteousness; and with the mouth confession is made unto csalvation.

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

    Great info!

  • @Vlad-ld9cu
    @Vlad-ld9cu 3 года назад

    Great tutorial, thank you !

  • @pmnarayan
    @pmnarayan 3 года назад

    fantastic presentation

  • @PhG1961
    @PhG1961 3 года назад

    Excellent tutorial !

  • @williamkiarie
    @williamkiarie 3 года назад

    That first tip was exciting. Thanks Leila

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

    the data validation - getting a calendar to display helped me fix this so I can do equivalent of the CTRL+; on Android mobile ... which is very helpful for one sheet ...

  • @LED_74Fly
    @LED_74Fly 3 года назад

    Pretty good. Thanks

  • @darrengrosch573
    @darrengrosch573 3 года назад

    Loved the video but not practical for personal use. I’m not saying anything bad, you are great at explaining. I just wish I knew formulas so I could make my own spreadsheet. Thank you.

  • @drloftus
    @drloftus 3 года назад

    This is amazing! Thanks so much for sharing!

  • @measmusings
    @measmusings 3 года назад

    This is incredible, Leila! Thank you so much!

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

    Always thought Google sheets inferior to Excel, but now I can give it a try 👍

  • @lbath76
    @lbath76 3 года назад

    Excellent, thanks ma'am

  • @izzatisydina2890
    @izzatisydina2890 3 года назад

    Thank you su much for this excellent tips

  • @murleevijay428
    @murleevijay428 3 года назад

    Excellent tips 💡🔥

  • @PoeticJusticeSC
    @PoeticJusticeSC 3 года назад

    You are a genius. So many useful tips with perfect explanations. Thank you!

  • @NitinKUMAR-qf9il
    @NitinKUMAR-qf9il 2 года назад

    Thanks for making this video

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

    How do i "importhtml" from live or dynamic multiple pages?

  • @jorgelara3116
    @jorgelara3116 3 года назад

    Thanks a lot for the video !! Looks easier when you explains it . I love it

  • @lpanebr
    @lpanebr 3 года назад

    I need to use the table graph more ahem m often. It really is very useful for the user and keeps the data protected. Thanks!

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

    This is awesome!!!!

  • @elmehdinoureddine9240
    @elmehdinoureddine9240 3 года назад

    Thanks Leila for sharing, keep it up!

  • @yellowgreenman6615
    @yellowgreenman6615 3 года назад

    Very helpful tips

  • @Wagner_Gilberto
    @Wagner_Gilberto 3 года назад +3

    Essas dicas são fantasticas e serão muito uteis no dia a dia com minhas tarefas no trabalho.

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

    Great list.