Это видео недоступно.
Сожалеем об этом.
7 Google Sheets Tips Every User Should Know!
HTML-код
- Опубликовано: 9 авг 2024
- Want to save time and edit Google Sheets like a pro? Well, then this list of tips is for you! In this video, Scott Friesen shares 7 different ways to get the most out of Google Sheets. From quick charts and dropdown menus to currency exchange and date formatting, you'll learn something new, guaranteed!
00:00 Adding dropdown menu or checkbox
02:41 Apply alternating colors
03:57 Sum up new rows
05:20 Dynamic currency exchange
07:02 Sparkline mini graph
08:14 Pick date from a calendar pop-up
09:37 View column stats
MY FREE GUIDE:
✅ The 2-Do List Method - Build a better task list - www.simpletivity.com/free
RESET PRODUCTIVITY MASTERCLASS:
💻 My 4-week live online course - www.simpletivity.com/reset
MY FAVORITE SOFTWARE:
📅 Easy meeting scheduling (Calendly) - calendly.grsm.io/simpletivity
👩 CRM for Gmail (NetHunt) - bit.ly/nethunt
📚 Best book summaries (Shortform) - shortform.com/simpletivity
📄 Powerful form builder (Jotform) - bit.ly/createjotform
📁 Secure backups for Trello (Rewind) - rewind.com/scott-friesen
CONNECT WITH ME:
📧 Sign up to my weekly email newsletter - www.simpletivity.com/free
🌎 My website - www.simpletivity.com
👨 Facebook: / simpletivity
📷 Instagram: / scottdfriesen
🔗 LinkedIn: / simpletivity
🐦 Twitter: / simpletivity
ABOUT ME:
Scott Friesen is a productivity specialist and founder of Simpletivity Training Inc.. He is also a prolific public speaker, workshop leader, and time management coach. Scott helps people to focus more time on what they want to get done and to experience less stress by simplifying their technology.
Simpletivity shares productivity tips, technology apps, time management ideas, and more to help you get more done and enjoy less stress at the same time. If you’re an entrepreneur, business owner, or professional who wants to get more out of your day, make sure to subscribe for helpful training videos ( / @simpletivity .
Icons made by Freepik from www.flaticon.com
#simpletivity #googlesheets #sheets
I am adding the calendar trick right now!!!!
Awesome, Sam. Thanks for watching and sharing!
Love the dropdown menu bit. God bless u!
Glad you like it!
As always ... Some really good tips Scott. I've started using Google sheets more to get svle to share easily with my team. These will really come in handy!
Wow! Those are some great tips! Thank you for putting this together!
You are most welcome, James.
Thank you. Good tips, and useful. There was one I didn't know about and will start using.
Thanks for watching, Robert.
Really great video, a 100% recommended
Love your tips and tricks, keep them coming 😉
Love your comment!
Wow, I learned a lot of useful tips. Thank you for that video.
You are very welcome, Biff.
Outstanding, very helpful.. thank you
You're very welcome, Frank!
Thank you for sharing. Good ideas !
Thanks for watching, Lina!
GENIUS.
Thanks!
Thanks for your information.its really helpful
Glad it was helpful! What was your favorite tip?
Thank you 💛🥳
You’re welcome 😊
I feel QUERY and FILTER functions are absolutely great to get more done with the data
I like the tip about summing a growing column 👍
So glad you enjoyed that one!
Exchange function I like
Yes, that's a great one!
Nice 🙂
Thankx. Have you Any video of how to’ copy Gmails ( from one receiver ) to Google sheets automatically ? Thank you
Hi , I work with an export house in India, I want to make a conditional formatting time and action table, where if I miss my sample submission date, production start date and shipment it should be highlighted. If over 3 days due , color 1 , if over 7 days due color 2. Pls.can you help me?
Absolutely, you can create a conditional formatting time and action table in Google Sheets to highlight missed deadlines. Here's how:
1. Set up your data:
Create columns for:
Order ID (or any unique identifier)
Sample Submission Date
Production Start Date
Shipment Date
"Days Overdue" (formula-generated)
2. Calculate "Days Overdue" for each deadline:
In the "Days Overdue" column (let's say column E), enter the following formula for the first row (E2):
=IF(TODAY()>C2, TODAY()-C2, 0)
Replace C2 with the cell reference containing the Sample Submission Date for that order.
Copy the formula down to all other rows in the "Days Overdue" column.
This formula checks if the current date (TODAY()) is past the Sample Submission Date (C2). If so, it calculates the difference in days. Otherwise, it shows 0.
3. Apply conditional formatting:
Select the entire "Days Overdue" column (column E).
Go to Format > Conditional formatting.
Under "Format cells if...", choose Custom formula is.
In the formula field, enter the following formula:
=$E2>3
Click Format and choose the desired color for highlighting overdue items (color 1).
Click Done.
Repeat steps 4-6 but with a different formula and color:
Formula: =$E2>7
Color: Color 2 (for items overdue by more than 7 days)
Now, your table will automatically highlight cells in the "Days Overdue" column based on the number of days past the deadlines.
Actually those tips are not new ones, there are many other videos showing them. But the examples are good and easy to understand for those who haven't noticed these hints yet.
Google sheet full tutorial