Excel BEATS Google Sheets with THESE 10 Features!
October 1, 2020 #MsExcel
In this video we'll explore 10 features of Excel where Google Sheets doesn’t compete (yet).
This is also a quick tutorial about Excel's best features. It's filled with Excel tips. Did you know all of them?
This covers the Excel Vs Google Sheets debate. Whereas in the previous video we looked at Google Sheets vs Excel. Check it out here in case you missed it: https://rumble.com/v2v92bq
With Google Sheets becoming a popular alternative to Excel, it’s important to recognize the strengths and weaknesses of each application. This also gives you an idea of what Sheets and Excel are used for and are capable of.
LINKS to related XLOOKUP videos:
https://rumble.com/v2usebg
https://rumble.com/v2us6fy
https://rumble.com/v2uqp14
Power Query: https://rumble.com/v2v8y8w
Check Out the Complete Excel Power Query course: https://courses.xelplus.com/p/excel-power-query
⯆ Check out the complete blog post about Excel vs. Google Sheets: https://www.xelplus.com/excel-vs-google-sheets
★ 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
Time Stamps:
00:00 Microsoft Excel versus Google Sheets
00:33 XLOOKUP
01:53 Excel Tables
03:30 Power Query
04:17 3D Formulas
05:36 Flash Fill
06:38 Excel's Data Model
07:44 Hash References for Dynamic Ranges
10:03 Charts with Conditional Formatting
12:06 Go To Special
13:17 Set Print Area
14:22 Pivot Slicers and Linked Shapes
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!
#MsExcel #Excel #LeilaGharani #GoogleSheets
-
2:43:11
Matt Kohrs
12 hours agoGameStop Is Squeezing, China on Tilt & The Week Ahead || The MK Show
32.2K7 -
1:02:42
Rethinking the Dollar
2 hours agoThe Next Banking Event Will Be Off The Charts | Monday Morning Check-In: A Quick Glance IN The News
9.85K4 -
1:37:00
The Podcast of the Lotus Eaters
8 hours agoThe Podcast of the Lotus Eaters #913
50.2K26 -
6:37
Chris Jericho
23 hours agoThe Unsolved Mystery & Murder of Rachel Morin
32.2K1 -
20:17
PARAGRAPHIC
1 day agoLeading the Way in Costa Rica's Culinary Scene | PARAGRAPHIC
37.9K2 -
9:00
Bearing
1 day agoMeet the Woman Trying Censor the WORLD! Australia's E-Safety Commissioner Mad with Power
30K28 -
9:10
DepressedGinger
16 hours ago7 MLB teams that are STRUGGLING with Attendance in 2024
32K10 -
3:32:48
Due Dissidence
22 hours agoMorning Joe and Hillary SMEAR Students, DNC Fears CONVENTION CHAOS, Carville MELTS DOWN Again
56.1K161 -
1:22:39
The Late Kick with Josh Pate
19 hours agoLate Kick Live Ep 512: Portal Winners & Losers | SEC Truths + Questions | Portal Winners & Losers
67.3K6 -
1:50:27
vivafrei
1 day agoEp. 210: Stormy Gags on Lies! Hunter Not Immune! AstraZeneca Pulled & MORE! Viva & Barnes
198K311