Google Sheets Tips for Productivity

Поделиться
HTML-код
  • Опубликовано: 9 авг 2024
  • Master Google Sheets in record time! In this video I’m sharing the best Google Sheets tips for productivity.
    Hey friends, I’m Tasia Custode, and in this video, I’m sharing my favorite Google Sheets tips for productivity. Believe it or not, you don’t have to know advanced cell formulas in order to take advantage of the best that Google Sheets has to offer. Learn how to create dropdown menus and checkboxes within cells, easily duplicate and copy tabs, see a complete revision and edit history and so much more. Plus, I’ll share my favorite Google Sheets formatting tips.
    ⏰ TIMECODES:
    00:00 - Intro
    00:38 - Google Sheets Formatting Tips
    02:49 - Link to a Custom Range
    03:25 - Protect and Lock Ranges
    04:29 - Duplicate and Copy Tabs
    05:37 - Remove Duplicate Entries
    06:22 - See a Revision and Edit History
    👀 WATCH OTHER GOOGLE SHEETS VIDEOS:
    📹 Google Sheets Keyboard Shortcuts: • The Best Google Sheets...
    📷 RUclips CAMERA GEAR:
    Panasonic GH5 Lumix Kit: geni.us/teLeWzz
    Sony ZV1 Camera & Vlogging Kit: geni.us/B6pj
    Rode VideoMic Pro+: geni.us/yfXsy
    Vanguard Alta Pro Tripod: geni.us/3Ougb
    Sony E Series SD Card: geni.us/BBi1Yxd
    Neewer Ring Light Kit: geni.us/3ho03WZ
    Neewer Desktop Ring Light: geni.us/quBpGZ
    Neewer Camera Light: geni.us/RyRTA
    ✅ RECOMMENDATIONS:
    🎦 I use Tubebuddy to grow my RUclips Channel. Learn more:
    www.Tubebuddy.com/tasiacustode
    🖼I use Canva to create all my RUclips thumbnails. Learn more: partner.canva.com/jWXqOv
    🎞 I use Camtasia for all my screencasting needs: techsmith.z6rjha.net/2rrRvG
    ⚙️ DOWNLOAD MY DIGITAL TOOLKIT:
    www.tasiacustode.com/digitalt...
    🤝 CONNECT WITH ME:
    📸 Instagram - / tasiacustode
    👍🏻 Facebook - / tasiacustode
    🖥 Website: www.tasiacustode.com/
    *Some of these links are affiliate links, meaning I may make a small commission if you sign up or purchase a product using these links. Don’t worry, this is at no extra cost to you! Thank you so much!
    Did you find this video helpful? Have questions or comments? Leave your thoughts in the comment section below.
    #GoogleSheets #ProductivityTips
    If you like this video, give a like, a share, or subscribe for more tech tips and app reviews.
  • НаукаНаука

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

  • @TasiaCustode
    @TasiaCustode  3 года назад +9

    Hey friends! What do you think of these Google Sheets tips for productivity? What are your favorites? Comment below! ⬇️

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

      google spreadsheets is powerful and advanced tool and yet simple to use. Being a dev I like how its easy and free to link external forms data with spreadsheets. So basically Personal blogging and small ERP softwares can be built on top google spreadsheets and google docs.
      I watch your videos to learn how to explain the softwares and tools and it helps a lot. thank you. I will be using the learned lessons when i update my old demo videos. Thank you.

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

      @@fxnoob it really is such a powerful tool! Glad you find the videos helpful!

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

      Love you so much can i get your whatsapp number

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

      etet 63 :-

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

    As a fellow google sheets lover/expert, I learned some new things, thank you! That "link straight to range" trick is clutch :)

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

    Love it! Thank you, my favourite one is the colours for tabs.

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

    Have used excel for years and really helpful information so i can now move on to G spreadsheets. Thank you 😊

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

    Great list, One thing I have recently found is you can replace characters within a formula in a sheet or the whole worksheet using Find and Replace. You need to mention this sheet in dropdown and check the option that says find within formulae. This will be helpful when you have got a lot of instances where the formula needs to be changed because of say range has changed or some coworker added a column or the business logic has changed

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

    I can’t wait to use the productivity tips in my life! 💫 Keep rising to be who you want to be! 💫 #keeprising #risingtobe #aswerise #riser

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

    Great tips, necessary for sure. I think auto API calls and data import has been the biggest production boost for me. Hundreds of hours saved!

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

    Very helpful! Thanks for sharing!

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

    awesome. short and sweet

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

    Thank you! :)

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

    Thank you for the tips.

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

    This was sooooo helpful thank you.

  • @MichaelRoode-MindEntry
    @MichaelRoode-MindEntry 4 месяца назад

    Great video , what I love about Google Sheet is its simplicity the ribbons are not cluttered ....

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

    very help full

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

    amazing tips.. just what I needed

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

    Love the background music

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

    Awesome 👍

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

    Very nice. Quick question. How can you add multiple tabs to a drop down on 1 page?

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

    Is there a way I can change the highlight colour and line thickness to show the current cell.
    The current blue outline is proving quite hard for me to see.
    thanks !

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

    I was desperate to watch this video. Im looking if i can substitute Excel. and with this video i see i can, thanks Tasia as always . im a Custodian lol

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

    your voice is very crisp and clear and pronunciation amazing, I have become addicted to your voice

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

    Thanks Tasia, great tips. Carey Price? Goalie fan? 😁

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

      haha, I'm a big Habs fan. I stopped short of listing their entire roster 😂

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

      @@TasiaCustode 🤣

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

      hi

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

    colored my tabs... :)

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

    Good

  • @user-ju5qp1ii6d
    @user-ju5qp1ii6d 7 месяцев назад +1

    Paci sa mi

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

    Hello tasia and have you thought about live streaming on twitch and starting your own podcasts and starting your own patreon account or onlyfans account in the future

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

    Tasia, loved your shortcut tips for Google sheets, however I would appreciate if you would slow down your examples ie, cut back on your RPMs Girl! Maybe it is me but to speak too FAST for a novice like me to follow your examples.

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

    Boy, this seems to be a complete copy cat video from Jeff sushi. All his Tipps in the similar order…