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
-
DVR
The Michelle Moore Show
6 hours ago(Tues, May 28 @ 3p CST/4p EST) Guests, Jack and Margy Flynn: The Michelle Moore Show (May 28, 2024)
7.2K8 -
21:30
Stephen Gardner
2 hours agoEx-CIA just SHOCKED the world with TERRIFYING new Trump prediction!
13.4K13 -
13:31
Breaking Points
5 hours agoSouth Park EXPOSES US Healthcare DISASTER
15.7K26 -
4:39
Standpoint with Gabe Groisman
4 hours agoClip: Amb Bolton on Isolationism - Protecting America's Interests Does Not End at Our Borders
16.2K6 -
LIVE
ItsMossy
3 hours ago🍀MULTIVERSUS IS BACK🍀!MENU !DISCORD !CLIP🍀
77 watching -
2:38:30
Matt Kim
19 hours agoThat DIDN'T go as planned...
25.1K14 -
43:05
Kimberly Guilfoyle
6 hours agoSPECIAL COVERAGE OF CLOSING ARGUMENTS, Live with Lawyer Mark Paoletta
37K33 -
2:46:24
Spittin' Chiclets
7 hours agoSpittin' Chiclets Episode 503: Featuring Special Guests
27.5K1 -
1:55:53
vivafrei
7 hours agoTrump Trial Closing Arguments! E. Jean Carroll to Sue AGAIN? Libertarian BABIES! & MORE! Viva Frei
78.1K61 -
32:28
TudorDixon
5 hours agoHonoring the Sacrifice: The True Meaning of Memorial Day | The Tudor Dixon Podcast
21.7K4