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
-
3:27:42
Tate Speech by Andrew Tate
4 hours agoEMERGENCY MEETING EPISODE 78 - OVERTON WINDOW
129K237 -
14:49
Colion Noir
7 hours agoTim Walz Says I’ve Become Friends With School Shooters During Vice President Debate
38.3K38 -
1:22:45
Kim Iversen
10 hours agoIsraeli Hasbara Or Iranian Propaganda, Who Is Telling The Truth?
104K178 -
1:55:23
Glenn Greenwald
11 hours agoTim Walz Again Defends State Sponsored Censorship; Julian Assange Recognized As Political Prisoner; Post-VP Debate Interviews | SYSTEM UPDATE #345
105K238 -
40:50
Candace Show Podcast
11 hours agoKamala’s Family Reaches Out! | Candace Ep 77
217K864 -
57:49
Man in America
14 hours agoWEAPONIZED Disasters & LAND GRABS: the Blueprint Exposed by the MAUI FIRES
53.9K45 -
1:14:51
Flyover Conservatives
1 day agoDinesh D’Souza’s Shocking Film: Exposing the Real Threats to Trump and America; Will America be Saved or Destroyed? - Drew Allen | FOC Show
74.6K12 -
7:52
Price of Reason
16 hours agoJoker 2 Review - Folie A Doo Doo! (No Spoilers)
48.7K16 -
54:52
LFA TV
22 hours agoElon Musk: This Could Be America’s Last Election | Trumpet Daily 10.2.24 9PM EST
71.1K14 -
3:11:23
Mostly Sports With Mark Titus and Brandon Walker
13 hours agoMostly Sports College Football Dynasty League | Week 12 Session 1
84.8K1