10 Google Sheets Tips You DON’T Want to Miss (2021)

10 Google Sheets Tips You DON’T Want to Miss (2021)

Both beginner and advanced google sheets users will learn something in this comprehensive Google Sheets tutorial. I’ll share my favorite tips & tricks with you. It’s a combination of useful google sheets functions and features that will really help you working with data in spreadsheets. It’s great for Google Sheets beginners to get an idea of what sheets can do. Some of these include: scrolling data tables in sheets, google sheets chart tips, publishing your sheets to the web & embedding sheets in websites. In addition we’ll cover Google sheets pivot tables, how to use checkboxes together with conditional formatting. How to use the date picker in Google sheets on empty cells. How to use column stats to get a good idea about your data. Use the web functions like Importhtml to import tables from the web and use functions like filter, unique and sort.

_________
Join My Google Sheets Comprehensive Masterclass: https://courses.xelplus.com/p/google-sheets
*** Additional Bonuses are ONLY available on XelPlus.
________

Timestamps
00:00 Most Useful Tips for Google Sheets
00:26 Scrolling Tables in Google Sheets
01:56 Aggregate Chart Values in Google Sheets
03:08 Publish to the Web with Google Sheets
04:25 Column Stats in Google Sheets
05:10 Open-Ended Cell References in Google Sheets
06:05 Insert Date From a Calendar in Google Sheets
06:50 Insert Checkboxes in Google Sheets
08:31 Pivot Tables in Google Sheets
10:08 How to Use IMPORTHTML in Google Sheets
11:33 Filter Functions in Google Sheets
13:29 Wrap Up

Link to complete article for Top 10 tips for Google Sheets: https://www.xelplus.com/top-10-tips-for-google-sheets

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#googlesheets

Leave a Reply

Close Menu