Google Sheets BEATS Excel with THESE 10 Features!

September 24, 2020 Google Sheets Tips, Tricks & Functions

Go to https://expressvpn.com/xelplus and find out how you can get 3 months free.

🏫 My complete Google Sheets course: https://courses.xelplus.com/p/google-sheets

Excel has been around for decades and has been largely considered the King of all spreadsheet applications. When Google Sheets first launched in 2006, it was nowhere near dethroning Excel.

But since then it improved significantly and today the functionality between Excel and Google Sheets is very similar. In fact, it has useful features which Excel either completely lacks or hasn't implemented as neatly as Sheets.

In this video we'll explore 10 features of Google Sheets where Excel doesn’t compete (yet).

Time Stamps
00:00 The Superpowers of Google Sheets
01:22 Searchable Drop-Down Lists in Google Sheets
02:58 The SPLIT Function
04:08 Automatic Refresh for Pivot Tables
05:08 IMPORTXML and IMPORTHTML to Import Data from Websites
06:38 Lookup on Images in Sheets
07:42 Search and Replace with REGEX
08:51 Insert QR-Codes with IMAGE Function in Sheets
09:54 Translate with a Function (GOOGLETRANSLATE)
11:04 Chat Inside Your Spreadsheet
11:46 The All-Powerful QUERY Function
13:36 The GOOGLEFINANCE and SPARKLINE Function in Sheets

If you want to find out how Excel fights back check out this video: https://youtu.be/yXMo9sj0Y2Y

⯆ Check out the complete blog post about Google sheets vs. Excel: https://www.xelplus.com/google-sheets-vs-excel

★ 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!

This video was sponsored by ExpressVPN.

#googlesheets
#MsExcel #Exce; #LeilaGharani