7 Google Sheets Tips Every User Should Know!

Simpletivity β€’ February 24, 2022
Video Thumbnail

About

No channel description available.

Video Description

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 - https://www.simpletivity.com/free RESET PRODUCTIVITY MASTERCLASS: πŸ’» My 4-week live online course - https://www.simpletivity.com/reset MY FAVORITE SOFTWARE: πŸ“… Easy meeting scheduling (Calendly) - https://calendly.grsm.io/simpletivity πŸ‘© CRM for Gmail (NetHunt) - https://bit.ly/nethunt πŸ“š Best book summaries (Shortform) - http://shortform.com/simpletivity πŸ“„ Powerful form builder (Jotform) - http://bit.ly/createjotform πŸ“ Secure backups for Trello (Rewind) - https://rewind.com/scott-friesen CONNECT WITH ME: πŸ“§ Sign up to my weekly email newsletter - https://www.simpletivity.com/free 🌎 My website - https://www.simpletivity.com πŸ‘¨ Facebook: https://www.facebook.com/simpletivity πŸ“· Instagram: https://www.instagram.com/scottdfriesen πŸ”— LinkedIn: https://www.linkedin.com/company/simpletivity 🐦 Twitter: https://twitter.com/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 (http://www.youtube.com/channel/UCAp3b6zIvS8ct4yci-GwxIg?sub_confirmation=1). ​​Icons made by Freepik from www.flaticon.com #simpletivity #googlesheets #sheets

Boost Productivity with These Google Sheets Must-Haves

AI-recommended products based on this video

Loading...
(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(3,057)
$15.99
Prime
200+ bought in past month
Loading...
Kasa Smart Outdoor Smart Plug by TP-Link (KP400) - Smart WiFi Outlet with 2 Sockets, IP64 Waterproof, Works with Alexa and Google Home, 2.4GHz WiFi Required, No Hub Required, Sunset & Sunrise Offset

Kasa Smart Outdoor Smart Plug by TP-Link (KP400) - Smart WiFi Outlet with 2 Sockets, IP64 Waterproof, Works with Alexa and Google Home, 2.4GHz WiFi Required, No Hub Required, Sunset & Sunrise Offset

(28,846)
$21.99$17.99
FREE delivery Wed, Aug 20 on your first order
1K+ bought in past month
Loading...
Wyze Cam v3 with Color Night Vision, Wired 1080p HD Indoor/Outdoor Security Camera, 2-Way Audio, Works with Alexa, Google Assistant, and IFTTT, 2-Pack

Wyze Cam v3 with Color Night Vision, Wired 1080p HD Indoor/Outdoor Security Camera, 2-Way Audio, Works with Alexa, Google Assistant, and IFTTT, 2-Pack

(91,276)
$80.36$63.48
FREE delivery Thu, Sep 4
400+ bought in past month
Loading...
100W USB C Universal Laptop Charger Fit for Lenovo MacBook HP Dell Acer Asus Thinkpad Google MSI LG Samsung Huawei, ROG Ally, Steam Deck, Chromebook Computer and All USB-C Devices

100W USB C Universal Laptop Charger Fit for Lenovo MacBook HP Dell Acer Asus Thinkpad Google MSI LG Samsung Huawei, ROG Ally, Steam Deck, Chromebook Computer and All USB-C Devices

(19)
$25.99$24.69
FREE delivery Tue, Jun 17 on your first order
100+ bought in past month
Loading...
(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(2 Pack) Outlet Wall Mount Holder for Google Home Mini and Google Nest Mini, A Space-Saving Accessories with Cord Management for Google Mini Smart Speaker, No Messy Wires or Screws

(3,057)
$15.99
Prime
200+ bought in past month
Loading...
INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

(520)
$41.42
PrimeFREE delivery Sat, Jun 14
500+ bought in past month
Loading...
INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

(79,368)
$25.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month
Loading...
Google Pixel Buds Pro 2 - Noise Canceling Earbuds - Up to 31 Hour Battery Life with Charging Case - Bluetooth Headphones - Compatible with Android - Hazel

Google Pixel Buds Pro 2 - Noise Canceling Earbuds - Up to 31 Hour Battery Life with Charging Case - Bluetooth Headphones - Compatible with Android - Hazel

(183)
199.99
PrimeFREE delivery Saturday, June 14
400+ bought in past month
Loading...
Deeyaple USB C to Aux, 4FT/1.2M, Type C to 3.5mm Audio Cable Headphone Jack Cable for Car Mobile Phone, iPhone 16 15, iPad Pro, Samsung Galaxy S24 S23 S2010, Google Pixel,Oneplus Grey (1)
Best Seller

Deeyaple USB C to Aux, 4FT/1.2M, Type C to 3.5mm Audio Cable Headphone Jack Cable for Car Mobile Phone, iPhone 16 15, iPad Pro, Samsung Galaxy S24 S23 S2010, Google Pixel,Oneplus Grey (1)

(78)
$6.99
FREE delivery Fri, Sep 5 on your first order
1K+ bought in past month
Loading...
Car Carplay Woven Cable for iPhone 16 15 3.3FT USB A to USB C 3.2 Gen 2 Carplay Adapter Wire for iPhone 16 15 Pro Max, iPad Pro/Air, Samsung Galaxy S25/S24/S23/S22/S21 Google Pixel, Car Charger Cable

Car Carplay Woven Cable for iPhone 16 15 3.3FT USB A to USB C 3.2 Gen 2 Carplay Adapter Wire for iPhone 16 15 Pro Max, iPad Pro/Air, Samsung Galaxy S25/S24/S23/S22/S21 Google Pixel, Car Charger Cable

(213)
$12.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

INIU 45W Power Bank, Ultra Small 10000mAh Portable Charger, USB C in&Out Fast Charging Battery Pack, Travel External Phone Powerbank Compatible with iPhone 16 15 Samsung S25 S24 Google Pixel iPad etc

(520)
$41.42
PrimeFREE delivery Sat, Jun 14
500+ bought in past month
Loading...
INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

INIU Power Bank, USB C in&Out Slimmest 10000mAh Portable Charger, Triple 3A High-Speed Charge External Battery Pack, Flashlight Phone Charger for iPhone 16 15 14 13 12 Samsung S22 S21 Google LG iPad

(79,368)
$25.99
FREE delivery Wed, Aug 20 on your first order
5K+ bought in past month