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
-
58:35
The Dan Bongino Show
6 hours agoA Terrifying Scene For The Democrats (Ep. 2248) - 05/13/2024
462K958 -
2:23:56
Spittin' Chiclets
4 hours agoSpittin’ Chiclets Episode 499: Playoff Madness
36.6K5 -
1:30:35
Benny Johnson
4 hours agoHISTORY! Trump DOMINATES New Polls After +100,000 Patriot MAGA Rally | DNC in PANIC, Swap Biden? 🚨
73.5K122 -
1:35:28
jeffahern
4 hours agoMonday Madness with Jeff Ahern (9AM Pacific)
17.3K2 -
1:10:34
Steven Crowder
5 hours agoMake Afroman Great Again: Afroman Sits Down For a ONE-OF-A-KIND Interview
125K398 -
1:20:37
Graham Allen
6 hours agoBiden Camp PANICS After 100k+ Show Up For Surging Trump!
66.4K152 -
2:43:11
Matt Kohrs
15 hours agoGameStop Is Squeezing, China on Tilt & The Week Ahead || The MK Show
48K8 -
1:02:42
Rethinking the Dollar
4 hours agoThe Next Banking Event Will Be Off The Charts | Monday Morning Check-In: A Quick Glance IN The News
41.8K7 -
1:37:00
The Podcast of the Lotus Eaters
10 hours agoThe Podcast of the Lotus Eaters #913
62.3K35 -
6:37
Chris Jericho
1 day agoThe Unsolved Mystery & Murder of Rachel Morin
39.5K3