Google Sheets Tips for Productivity
ฝัง
- เผยแพร่เมื่อ 3 ก.ค. 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...
📷 TH-cam 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 TH-cam Channel. Learn more:
www.Tubebuddy.com/tasiacustode
🖼I use Canva to create all my TH-cam 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. - วิทยาศาสตร์และเทคโนโลยี
![ช่วยพาฉันผ่านเวลา - วสันต์17 [Official MV]](http://i.ytimg.com/vi/HFnntWoqc54/mqdefault.jpg)
Hey friends! What do you think of these Google Sheets tips for productivity? What are your favorites? Comment below! ⬇️
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.
@@fxnoob it really is such a powerful tool! Glad you find the videos helpful!
Love you so much can i get your whatsapp number
etet 63 :-
Love it! Thank you, my favourite one is the colours for tabs.
As a fellow google sheets lover/expert, I learned some new things, thank you! That "link straight to range" trick is clutch :)
Have used excel for years and really helpful information so i can now move on to G spreadsheets. Thank you 😊
Very helpful! Thanks for sharing!
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
Great video , what I love about Google Sheet is its simplicity the ribbons are not cluttered ....
awesome. short and sweet
Thank you for the tips.
You're welcome!
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!
data import ftw!
Love the background music
This was sooooo helpful thank you.
You’re most welcome!
Thank you! :)
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
very help full
amazing tips.. just what I needed
Glad it was helpful!
Awesome 👍
Very nice. Quick question. How can you add multiple tabs to a drop down on 1 page?
your voice is very crisp and clear and pronunciation amazing, I have become addicted to your voice
Very creepy dude
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
Love it!
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 !
Thanks Tasia, great tips. Carey Price? Goalie fan? 😁
haha, I'm a big Habs fan. I stopped short of listing their entire roster 😂
@@TasiaCustode 🤣
hi
colored my tabs... :)
Good
Thanks
hi im fida hussain
Paci sa mi
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
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.
Boy, this seems to be a complete copy cat video from Jeff sushi. All his Tipps in the similar order…