Google Sheets BEATS Excel with THESE 10 Features!
Go to https://expressvpn.com/xelplus and find out how you can get 3 months free.
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.
My complete Google Sheets course: https://courses.xelplus.com/p/google-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
Видео Google Sheets BEATS Excel with THESE 10 Features! канала Leila Gharani
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.
My complete Google Sheets course: https://courses.xelplus.com/p/google-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
Видео Google Sheets BEATS Excel with THESE 10 Features! канала Leila Gharani
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
10 Google Sheets Tips You DON'T Want to Miss (2021)Excel BEATS Google Sheets with THESE 10 Features!Windows 11 - What You NEED To Know! TPM, Features and What's NOT So Great.Answering Your Questions: My Age, Nose, Marriage, Background (1 Million Subscriber Milestone)TOO MANY EMAILS? Use THESE Proven Techniques | Outlook tips includedFREE Windows Apps You Should be Using (who thought these are ACTUALLY FREE?!)10 USEFUL Websites You Wish You Knew Earlier!Excel for Accounting - 10 Excel Functions You NEED to KNOW!6 FREE Add-Ins for Excel to Start Using NowGoogle Sheets Beginner Tutorial4 SMART Ways to use Custom Formatting instead of Conditional Formatting in Excel - Part 1Do you know these 5 PowerPoint Hacks?Top Features of EDGE! (You've GOT to KNOW these!)Excel Pivot Tables EXPLAINED in 10 Minutes (Productivity tips included!)5 Google Sheets Tips Every User Should Know!15 Functions in Google Sheets You NEED to know!Automate Document Workflow with Google Docs, Gmail, Google Forms, and SheetsHow to Create & Use Excel Macros (Real world example)☑️ Top 30 Advanced Excel Tips and Tricks