Тёмный

Google Sheets BEATS Excel with THESE 10 Features! 

Leila Gharani
Подписаться 2,6 млн
Просмотров 512 тыс.
50% 1

Go to expressvpn.com/xelplus and find out how you can get 3 months free.
This video is perfect for those curious about Google Sheets, especially Excel users looking to explore alternative spreadsheet programs. The creator, an avid Excel user, dives into Google Sheets by switching most of their work from Excel to Sheets for a few months. The result is an insightful head-to-head comparison, highlighting areas where Google Sheets outshines Excel.
🏫 Get access to the complete Google Sheets masterclass here 👉 www.xelplus.com/course/google...
Key Google Sheets Features Covered:
▪️ Searchable Dropdown Lists: An intuitive feature where dropdown lists in Google Sheets are automatically searchable, making data selection more efficient.
▪️ The SPLIT Function: A dynamic function that effortlessly splits text into multiple columns without needing complex formulas.
▪️ Automatic Refresh for Pivot Tables: Pivot tables in Google Sheets update instantly with any change in source data.
▪️ IMPORTXML and IMPORTHTML Functions: Powerful tools for importing data from websites, including non-table data.
▪️ Lookup on Images: Unique capability of Google Sheets to perform lookups on images within cells.
▪️ Search and Replace with REGEX: Advanced searching and replacing text patterns using regular expressions.
▪️ Insert QR-Codes with IMAGE Function: Easily generate QR codes within a spreadsheet.
▪️ Translate with a Function (GOOGLETRANSLATE): Built-in translation feature to create multilingual spreadsheets.
▪️ Chat Inside Your Spreadsheet: Collaborate efficiently with integrated chat and comment features.
▪️ The All-Powerful QUERY Function: A single formula in Google Sheets can be used for complex data analysis, similar to SQL queries.
▪️ Additional Features Like GOOGLEFINANCE and SPARKLINE: Flexibility in retrieving stock information and creating sparklines directly using functions.
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.
00:00 Amazing Features Only Available in 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: • Why Excel BEATS Google...
⯆ Check out the complete blog post about Google sheets vs. Excel: www.xelplus.com/google-sheets...
★ My Online Excel Courses ► www.xelplus.com/courses/
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
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 #excel

Опубликовано:

 

27 июн 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 1,2 тыс.   
@LeilaGharani
@LeilaGharani 3 года назад
Discover more practical Google Sheets tricks by joining our full "Google Sheets Masterclass" here 👉 www.xelplus.com/course/google-sheets/ To watch Excel Vs. Sheets, check out this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-yXMo9sj0Y2Y.html
@AK-ox3mv
@AK-ox3mv 3 года назад
Tashakor 🙏
@markbrad123
@markbrad123 3 года назад
Bet Microsoft staff are watching this and planning some upgrades. Healthy competition.
@bunkin13
@bunkin13 3 года назад
Hello. The course you are offering for google sheets is it live, recording and is there a limit to finish it? Can it be access anytime? Thank you.
@agnesng6265
@agnesng6265 2 года назад
Very good video. Thank you! Looking forward to more Google courses.
@abdulhafeezchandio
@abdulhafeezchandio 2 года назад
I need this sheet for formula can you share with me plz
@WarhavenSC
@WarhavenSC 3 года назад
Google Sheets has the advantage of working on leap year, since Office is only 365 days of the year.
@MrBadapau
@MrBadapau 3 года назад
🤣
@himeshnagar707
@himeshnagar707 3 года назад
😂😂
@angninong5572
@angninong5572 3 года назад
😁
@TonyMilanoOfficial
@TonyMilanoOfficial 3 года назад
OMG. You Win!
@Hercules_tootoo
@Hercules_tootoo 3 года назад
😭😂🤣🤣
@LeilaGharani
@LeilaGharani 3 года назад
Next week Oct 1st Excel with fight back! Who will win? The more experienced superhero or the younger but faster one? (Thank you for liking and commenting on this video. I wasn't sure how you'd like this topic on the channel.)
@MarwanAShareef
@MarwanAShareef 3 года назад
Go ahead, we still following you
@p5gBand
@p5gBand 3 года назад
I love it. My company uses Google suite almost exclusively and fortunately, I've been able to replicate many Excel functions in Sheets but it does not always work. I would love to see more on Sheets please. Love your content in general Leila. Thank you.
@venkatiyer7459
@venkatiyer7459 3 года назад
Is there an alternative for Ctrl+g / F5 in Excel with Sheets .... Looking forward for your reply
@maofa1234
@maofa1234 3 года назад
Google Sheets is very powerful in comparison with Excel online.
@samiijsph87
@samiijsph87 3 года назад
Can't wait. I want MS Excel to win. Really loved the way you explain. I am learning VBA from Xelplus. I hope Excel is better, and thank you for explaining it so brilliantly.
@CarlLindeberg
@CarlLindeberg 3 года назад
In data validation (1:50) you can actually leave the column reference open (B3:B) to prepare for extra rows.
@doktorexcel8603
@doktorexcel8603 3 года назад
Every time I watch a new video of you, I realize how much I still have to learn.
@mqhuynh2006
@mqhuynh2006 3 года назад
Thank you so much for a very good presentation. In a short time, you covered many interesting tips. To help others to look up the content of the presentation, I included the time markers as follows: Excellent advanced features from Sheet 1:25 Drop down 3:01 Split 4:10 Pivot table 5:08 Import data (XML) 6:39 Images in cells 7:44 Find and replace 8:52 Insert QR Code 9:55 Translate function 11:05 Chat inside Sheet 11:48 Query function 13:41 Advanced finance functions 14:35 End.
@mattjoy4588
@mattjoy4588 Год назад
Thank you for sharing the time markers for the different features discussed in the video. It's great to see that you found the presentation informative and useful. The features you listed are indeed some of the advanced features that Google Sheets has over Excel, and it's great to see that you found them interesting. I hope you found the video helpful in learning more about Google Sheets. ru-vid.com/show-UCqPtlFvnP_7XJuAJik-rsnA
@kerronduncan6697
@kerronduncan6697 3 года назад
Thank you for this comparison Leila! My favorites: Flexibility of the drop down list Automatic refresh with the pivot tables Translate function Impressive!
@sureshJayaraman85
@sureshJayaraman85 3 года назад
Wow. I just realized, I have underestimated sheets till now!
@ryanmurphy249
@ryanmurphy249 3 года назад
Same! I really didn't realize that much could be done in Sheets. I'm interested to learn more now!
@basilhorace
@basilhorace 3 года назад
Likewise me. Quite enlightening from Leila. Got my learning hat on again.
@tonycstech
@tonycstech 3 года назад
Thats because you dont use it on a more advanced level.
@danielk.2663
@danielk.2663 3 года назад
Thank you, great video. It's always good to know the alternatives to the software you are using. As an advanced Excel user, I would love to see more stuff on Google Sheets formulas.
@DarshanShah10
@DarshanShah10 3 года назад
I've been a long-time user of Google Sheets, but I never knew it was this powerful! Thanks for this video, and I hope you make more videos about Google Sheets!
@pandyapritesh2000
@pandyapritesh2000 3 года назад
Thank you so much...Please continue this. I was considering google sheets as preview my xls contents....this is very informative
@ErosLuciano
@ErosLuciano 3 года назад
A professional and no-frills video, you hit the target as always Leila. Congratulations and thank you for your valuable teachings.
@johnfromireland7551
@johnfromireland7551 3 года назад
I like the ability to use images as values. Cool. The chatting feature when sharing workbooks is already possible in Microsoft Teams.
@olukunleakinola7133
@olukunleakinola7133 3 года назад
I have always underrated Google sheets. This is mind blowing.
@SMARTproAcademy
@SMARTproAcademy 3 года назад
Thanks a lot, great information 👍, looking forward the excel advantages 😎
@LeilaGharani
@LeilaGharani 3 года назад
Coming up next week :)
@ThepExcel
@ThepExcel 3 года назад
Great Summary! Waiting for the fight back of Excel next week
@imranbhatti8580
@imranbhatti8580 3 года назад
Yes mam , many GS functions are really worth using in daily tasks at office. Nicely explained like always.
@rakimhaqverdiyev
@rakimhaqverdiyev 2 года назад
Some additions: 11. Clicking on date formatted cell opens a calendar and easier to pick one. 12. Real time updates from other Spreadsheets via Importrange function 13. Insertion all matches into one cell via Join & Filter fx combination 14. Beating Excel Tables with a single Arrayformula function 15. Many add-ins like date reminders, auto mail sending etc.
@usbills6582
@usbills6582 3 года назад
Great Video. I'd love looking further into query formulas. Thanks!
@w6263
@w6263 Год назад
learnt something new today ''split'' function. Will come in handy. I appreciate all the videos you do.
@jacquelines3093
@jacquelines3093 3 года назад
This was amazing, thank you. I would like to learn more about the Sheets features you covered here, like the stocks, the query function, the org chart, etc.
@LeilaGharani
@LeilaGharani 3 года назад
Noted!
@aperkinsvt
@aperkinsvt 3 года назад
Thank you! I use both every day and can say at a basic level they are almost identical in functionality. At the advanced level there are differences - and I love that you’ve highlighted some very important ones. Looking forward to the Excel video!
@LeilaGharani
@LeilaGharani 3 года назад
Glad it was helpful! See you next week :)
@DeniseVajdak
@DeniseVajdak 2 года назад
Some of these are really high-level tips, but WOW! Didn't think it could do all that. Good job! One of my favorite Sheets functions is simply the Checkboxes. I use them in several spreadsheets.
@markparry1922
@markparry1922 3 года назад
Definitely interested to explore sheets some more. Thanks for this insightful video.
@johnphilippatos
@johnphilippatos 3 года назад
Ok, now I'm waiting for the video named "Excel BEATS Google Sheets with these 10 features!" Great Job Leila. As always.
@HP-om8cu
@HP-om8cu 3 года назад
Excel is long runner
@johnphilippatos
@johnphilippatos 3 года назад
@@HP-om8cu Yeah, tell me about it. When I started using Excel, the default background colour of the cells was green, not white. Talk about 25 years now...
@LeilaGharani
@LeilaGharani 3 года назад
Coming up next Thursday. Stay tuned :)
@sanjaysrivastava1100
@sanjaysrivastava1100 3 года назад
@@LeilaGharani Good will wait for it but you must do a whole lot of videos on Sheets like you have done on Excel. There are a large number of "Sheets" fan too!
@thiago713
@thiago713 3 года назад
YAAAAAAAAS!!! I put my money on Excel. I still liked this video. Good stuff!👍
@VivekSNarayan1
@VivekSNarayan1 3 года назад
There's another great advantage of getting median values in pivot tables without much efforts which is often better than averages.
@ben-uy1ud
@ben-uy1ud 3 года назад
You are the only teacher I would want to learn excel from, your calm composed voice lets stuff sink in for a user, making him understand better. Please continue making such informative videos (even basic ones) Leila.... Forever fan and all the best!!!
@LeilaGharani
@LeilaGharani 3 года назад
Wow, thanks!
@sharifalhumaid8537
@sharifalhumaid8537 3 года назад
Thank you for highlighting these cool features. It's nice to have options.
@excelisfun
@excelisfun 3 года назад
Awesome Video!!!! I Love Leila Super Hero to the rescue : ) : )
@LeilaGharani
@LeilaGharani 3 года назад
Your friendly neighborhood Super Nerd :)
@krn14242
@krn14242 3 года назад
@@LeilaGharani Never a "nerd".
@LotfyKozman
@LotfyKozman 3 года назад
Both of you may make a big revolution in the world of Google Sheets. I'm a big fan to you since ages but I stopped watching your videos after practicing Google sheets rigorously and can see how big is Google sheets. Good bye MS Excel. Good luck Google Sheets
@AlThePal78
@AlThePal78 3 года назад
@@LeilaGharani I don't care if your a nerd or super nerd your a beautiful super nerd with a heart of gold. :) and being a nerd is not a bad thing like the 90s its amazing :)
@rogerhendriks999
@rogerhendriks999 3 года назад
Awesome video! Thanks a lot, Leila. I have a question. What are your experiences with the calculation power of Sheet vs Excel? I have this huge file with over 25,000 records for my administration since 2012 and have linked it with filters, pivot tables, power queries (thanks to your excellent course on that topic), tons of formulas (some of them are array formulas), named ranges and what have you more. In Excel I have switched to "calculate manually" and in that way, I can work with this big file of 139MB. Since I understood that Sheets only loads what it needs for its calculations, and that Sheets has a lot of advances over Excel, I started to rebuild the file in Sheets. (Importing didn't work since not all formulas could be transformed, like the filter formula or xlookup formula; and I use them a lot). But unfortunately, after putting in a lot of time, I got stuck in a situation that Sheets isn't able to load or reload some of the sheets! So basically I can't open the file any longer. Do you have similar experiences with Sheets? What would you advise? Looking forward to your video of next week!
@00dfm00
@00dfm00 Год назад
Google's Connected Sheets?
@ekskfamily7932
@ekskfamily7932 3 года назад
Just when you think your videos can’t get any better, you take it to a new level. Thank you, a true credit to your commitment
@LeilaGharani
@LeilaGharani 3 года назад
Wow, thank you!
@johnfromireland7551
@johnfromireland7551 3 года назад
I do wonder how Leila finds the time (and the money) to obtain a super girl outfit JUST for this video.
@akarmdit2267
@akarmdit2267 3 года назад
Pretty well summarized indeed ... awesome kudos to all
@roBLINDhood
@roBLINDhood 3 года назад
All good examples. I LOVE sheets and really can’t stand Using excel. One of my favorite sheets features is moving rows and columns with drag and drop.
@paulo.galvao
@paulo.galvao 3 года назад
LivreOffice Calc also do it.
@Sengenda
@Sengenda 3 года назад
Great video but I disagree regarding Unique Count: That does actually exist in Excel Pivots! When creating a pivot table, you have to add the Pivot to the Data Model. That way you get to Distinct Count, which is the same as Unique Count. Other than that: Thank you so much for your fantastic videos!
@chaitanyalodha3948
@chaitanyalodha3948 3 года назад
WOAH! i want to see a whole new series on just Google sheets now! those seems some really nice flexible formulas
@denverp1912
@denverp1912 3 года назад
This is awesone! Looking forward for the SQL matters in Google Sheets
@TylerStanczak
@TylerStanczak 3 года назад
I love the thumbnail! 😊
@armanke13
@armanke13 3 года назад
Microsoft be like.. "Write that down! Write that down! We should steal those features!"
@LeilaGharani
@LeilaGharani 3 года назад
😁
@kal_jorEl
@kal_jorEl 3 года назад
Quite honestly, Google copied exact features from Excel when they made it for public use. Excel is way way way older than sheets. The only reason Google Sheet became useful was their ability to work in browser which Microsoft at the time did not allow but by the time they realised or gave attention, people had already started using Google Sheets. Google made it free while Microsoft could not. Saying Microsoft copies Google Sheets, is ignorant.
@Mabeylater293
@Mabeylater293 3 года назад
@@kal_jorEl common u gotta have a funny bone somewhere 😂
@augustodemelo915
@augustodemelo915 3 года назад
I had no idea that Sheets would be so advanced! It is very important to open the mind for other things and other possibilities. It is more than I ever expected to get from your already great and professional RU-vid channel! I am your fan.
@LeilaGharani
@LeilaGharani 3 года назад
Glad to hear Augusto! And yes, it's always good to keep an open mind.
@kurdirama
@kurdirama Год назад
I am a power user and for years I used Excel. Now I am 100% a Sheets convert. Honestly it is so much more powerful I was taken by surprise.
@MarwanAShareef
@MarwanAShareef 3 года назад
Leila, I wish everyday is Thursday!
@LeilaGharani
@LeilaGharani 3 года назад
🤗
@virajwaghmare4488
@virajwaghmare4488 3 года назад
Functions like Filter and Unique are available in Google sheets whereas these are only available in latest Excel versions.
@wakelingchicken
@wakelingchicken 3 года назад
OMG, I never thought I'd read that headline from you Leila, but I've checked the first minute of your video and so understand where you're coming from. I'll view the rest later. Thank you for the great work you do :)
@LeilaGharani
@LeilaGharani 3 года назад
Thanks Andy!
@analirpisani4824
@analirpisani4824 3 года назад
You are amazing. I don't know how you find the time to put this stuff together. Your explanations are so clear quick to the point.
@LeilaGharani
@LeilaGharani 3 года назад
Wow, thank you Analir!
@chh8860
@chh8860 3 года назад
I still struggle mastering the 12,357 commands in Excel … don't really see myself changing to Sheets for these 10 Features. The comparison reminds me of those people who tout that BMW is better than Lexus (or vice versa) … both programs are extraordinarily powerful and more than capable for my purposes. I cannot even think of a reason to entertain a change.
@PaulRoneClarke
@PaulRoneClarke 3 года назад
I actually use both. 95% Excel but these and a couple of other features I transfer to Sheets. Sometimes - you can do something in Sheets - save as Excel and it manages to transfer the process to Excel somehow. Try doing an image lookup simply in Sheets (function is not available in Excel), then from within Sheets "save as Excel", then load in Excel.
@chh8860
@chh8860 3 года назад
@@PaulRoneClarke That is good to know … you've piqued my interest (but just a wee bit) … thank you for taking the time to comment.
@SoulTrain101
@SoulTrain101 3 года назад
Almost all of your Excel commands are in Sheets! Think of Excel like a Swiss Army knife, and Sheets like a Screwdriver. The former can do almost everything, but in many cases, you just need a simpler option that does some things best.
@netboy1102
@netboy1102 3 года назад
please trust me, Google Sheets is much more advanced, and it is the future. watch this tutorials, then you decide by urself ru-vid.com/group/PLv9Pf9aNgemt82hBENyneRyHnD-zORB3l
@johnfromireland7551
@johnfromireland7551 3 года назад
@@PaulRoneClarke This might be possible because under the hood both applications are using Javascript? I wonder.
@charlitocamacho1290
@charlitocamacho1290 3 года назад
3 of my favorite gsheet advantage: 1. anyone can access/change the file simultaneously 2. it doesn't freeze (freeze-i mean crash or hang) 3. file version and tracker (you can see who changes what, down to cell level)
@brianjames6394
@brianjames6394 3 года назад
And excel does this everyday for me and has done this for since 2010 so what's the issue? Simpletons who cant code correctly use sheets!
@Welter87
@Welter87 3 года назад
I have been using excel files on MS Teams that allows you to collaborate with someone else in contemporaneity (is it the right word? 😂) It freezes only if you are not running it with a NASA pc 🤣
@johnfromireland7551
@johnfromireland7551 3 года назад
Freezing in Excel-on-the-web? I haven't noticed that. When does this" freezing" occur? Please give an example. Thank you.
@HashimMehmoodAhmed
@HashimMehmoodAhmed 3 года назад
You explain it well.. bless you..
@MichaelGoldner
@MichaelGoldner 3 года назад
Thank you again for this excellent comparison. I use both tools for quite a long time but you really showed me something new. With sheets I faced problems with dynamic linking of images. That also includes the QR Code generation. It seems that sometimes sheets does not update. There are open threads in the support forum about this. BTW: nice wonderwoman suit 😀👍
@rafaher94
@rafaher94 3 года назад
Another important attribute for users to consider is that with Google Sheets you don't have to pay or download updates. you can count on the latest version as long as you have an internet connection. And like everything in Google, they are always doing very functional updates. This is the future!
@ridley68
@ridley68 3 года назад
@@bobtahoma of course Microsoft would never do that.
@JamesRodriguez10783
@JamesRodriguez10783 Год назад
There is a reason MS Office is paid and Google office is free.
@BF_official_my
@BF_official_my Год назад
Yess, I use sheets for personal due to its free. Excel for work as it's the company's software.
@ruzaqir354
@ruzaqir354 3 года назад
Damn u look awesome with wonderwoman and supergirl coslay
@baphnie
@baphnie 3 года назад
Been watching you for a few years now, love your content!
@LeilaGharani
@LeilaGharani 3 года назад
Awesome! Thank you!
@ShakeelAhmed-ez8yw
@ShakeelAhmed-ez8yw 3 года назад
Lovely Video Leila! I have been delivering Excel Trainings to big corporates over two decades, and of course a big Fan of Excel. Never thought Google Sheets is so Powerful and can beat Excel with the great Features which you took us through in this Video. Now I think its time for me to venture google sheets and introduce this in all my new trainings... And Leila your videos are Super Awesome and whenever I face challenges to find some logic in Excel I first prefer your videos to find the solution... Great efforts... Keep it up!!!
@LeilaGharani
@LeilaGharani 3 года назад
Thank you for the kind feedback!
@ExcelUpNorth
@ExcelUpNorth 3 года назад
The GOOGLEFINANCE function is my favorite! Being able to have a single list of companies and then pull almost every attribute associated with it is a game-changer.
@LeilaGharani
@LeilaGharani 3 года назад
I also really like it. But Excel will have StockHistory at some point.
@ExcelUpNorth
@ExcelUpNorth 3 года назад
Leila Gharani That will be a great addition. I’m looking forward to watching your next video to see how Excel comes back!
@russellericorticio5787
@russellericorticio5787 3 года назад
Can you do a simple and quick tutorial for QUERY?
@LeilaGharani
@LeilaGharani 3 года назад
Noted!
@Rice0987
@Rice0987 8 месяцев назад
Incredible! Yesterday i was watching this video about google sheets and already TODAY i've helped to my colleague to use it!😮😄😋 THANK YOU LEILA!🤗😘
@rc.9764
@rc.9764 3 года назад
Great video as usual....Useful!...Good comparison...
@yogeish
@yogeish 3 года назад
Please say "X" in each video just like that. I love the way tou say it 😁
@LeilaGharani
@LeilaGharani 3 года назад
I'll try :)
@eltonm.t.873
@eltonm.t.873 2 года назад
I love Excel as an long time user, however, I have to be honest that the greatest advantage of Sheets over Excel is about future proof by being more online capable. Yes we've got Office online but Sheets uses a script language which is better the Office's. Moreover, Google's ecosystem is much broader and present on the internet, in other words, people are much more tied to Google services than Microsoft's .
@mokka61
@mokka61 3 года назад
Great Mrs , appreciate your honesty and best know how
@SwissPGO
@SwissPGO Год назад
Sheets rocks indeed. As a university program manager, I ran almost everything using many of the tools you showed (and more custom functions written in javascript). From exam scheduling to running multiple choice tests using google forms, and running anonymous grading of student written works by multiple faculty, including emailing the results to the students: google sheets allows it all. Only difficulty is reading and understanding your formulas the next semester ... documenting formulas (and debugging errors) is quite impossible on spreadsheets.
@vishyoutubevideos
@vishyoutubevideos 3 года назад
Google sheets is amazing. At this point, I only use Excel when absolutely necessary
@Pharaoh-99
@Pharaoh-99 3 года назад
ONLY THING keeping me from using Google Sheets is the fact that it doesn't have an offline version on windows
@paulo.galvao
@paulo.galvao 3 года назад
You can use LibreOffice in Linux, Mac and ...BadWindows, and save the documents directly into cloud if you want. And you dont need any login (spy you)
@prasadmhatre3877
@prasadmhatre3877 3 года назад
It has offline version, right click the sheet in your drive and turn offline or turn offline mode in Google drive settings
@Pharaoh-99
@Pharaoh-99 3 года назад
@@paulo.galvao libreOffice is amazing but doesn't have good RTL support
@wilsonjoshua6209
@wilsonjoshua6209 3 года назад
Prasad Mhatre
@ridley68
@ridley68 3 года назад
Except it does
@mvvassy
@mvvassy 7 месяцев назад
Impressive features. and Well presented. Thank you!
@saadelias7987
@saadelias7987 3 года назад
While setting up "Data Validation" for Dropdown List, instead of selecting Range manually you can mention the "Named Range" (if you have any) in "Criteria Range Box". Eg. in the video at 1:35 in column B there are various positions mentioned...... we can create "Named Range" for that data and name it as "Positions". Now, whenever you need a "Dropdown List" of "Positions" you can just write "Positions" in "Criteria Range Box" and it will list down the data and moreover it is dynamic.
@iiianniii
@iiianniii 3 года назад
Be careful if you intend to make a very large Google Sheet. The constant saving can make it very slow and if the document is too large you can't use offline mode to get around this.
@00dfm00
@00dfm00 Год назад
Use Google Connected Sheets to handle billions of rows.
@Steve211Ucdhihifvshi
@Steve211Ucdhihifvshi Год назад
it still cannot handle decent data. Your kidding yourself if you think its anywhere near as good as excel. Its akin to a chinese pirate version or microspft windows XP. sure it looks similar but what do they have access to and things just dont work right. But sure keep fanboying for google. lol
@00dfm00
@00dfm00 Год назад
@@Steve211Ucdhihifvshi Google Sheets has a rather powerful scripting engine based off Javascript - think VBA. Out of the box Sheets looks Mickey Mouse. However, what you can do with it is rather surprising. It's enough to handle 99% of user's needs. If your needs are in that last 1% then good for you. But to shit all over it screams Excel fanboy in a way that would make Excel MVPs cringe.
@rajesh0506
@rajesh0506 3 года назад
QUERY function alone is enough to rate sheets over excel
@yash1152
@yash1152 3 года назад
timestamp? okay 11:46
@helmanfrow
@helmanfrow Год назад
Good video. You covered nearly everything I like better about Sheets than Excel (which I hate using after switching to Sheets). There's also an excellent function called FLATTEN() which is incredibly useful in many tasks including unpivoting tables.
@joseantonioperez8273
@joseantonioperez8273 3 года назад
Awesome Thanks Leila excelent video I will turn my spreadsheets development focused in taking advance of both Google Sheets and Excel features Saludos desde Ciudad de México
@Remars808
@Remars808 3 года назад
I'll wait for "Power Query beats everything". I miss being a Google investor though 😔
@LeilaGharani
@LeilaGharani 3 года назад
I missed that boat too :) Excel fights back next week!
@jesse6327
@jesse6327 3 года назад
Here is one thing you CAN NOT do in Sheets : Create a Table.
@AlThePal78
@AlThePal78 3 года назад
Technically, you don't need too. Did you see the fact it already acts like it is in a table by adding the information into the pivot table. Meaning it performs like excel tables without going the extra distance of making a table.
@zstanojevic9574
@zstanojevic9574 3 года назад
It's a bit of a curse NOT seeing it as - a feature actually, in Googles favor..
@joshau2346
@joshau2346 3 года назад
great effort for the cover image! thumbs up for your creativity and humour!!!
@LeilaGharani
@LeilaGharani 3 года назад
Thank you so much 😀
@venkatiyer7459
@venkatiyer7459 3 года назад
Kudos to you ... whatever you do, you do it in a style .... thanks for the video ...
@LeilaGharani
@LeilaGharani 3 года назад
I appreciate that!
@radu_sirbu
@radu_sirbu 3 года назад
Leila, you forgot one important feature: Google Sheets costs nothing :)
@zedmagdy
@zedmagdy 3 года назад
costs ur data
@jasonluong3862
@jasonluong3862 3 года назад
Hint: I would not use Sheets to manage the books of my cannabis business.
@Sidman723
@Sidman723 3 года назад
I'm starting to like Google Sheets. Does that make me a bad person?
@ConsulthinkProgrammer
@ConsulthinkProgrammer 3 года назад
Google Sheets are awesome. Imagine someday you could make something like this feature :) docs.google.com/spreadsheets/d/1J6RuqgrTgN5k_W-P4_Zy3OIwLUpM9sL3kUVKpeM9cZ4/edit?usp=sharing
@johnfromireland7551
@johnfromireland7551 3 года назад
Stick with Excel-on-the-web. You aren't restricted to using just Google Services like Google Translate. Excel on the web is more open in that sense.
@JeffPeebles
@JeffPeebles 3 года назад
Yes. Yes it does.
@HeyEveryoneHi
@HeyEveryoneHi 3 года назад
Yes
@sunilpant2339
@sunilpant2339 Год назад
Thanks for this informative video...
@accountingindex5471
@accountingindex5471 3 года назад
The functionality is very dynamic. Thank you for sharing.
@LeilaGharani
@LeilaGharani 3 года назад
You are welcome!
@sofusaxelsen4029
@sofusaxelsen4029 3 года назад
I can't lie the main reason I'm here is because the instructor is damn beautiful LOL
@damodarbangalore7003
@damodarbangalore7003 3 года назад
Thanks for Sharing your Knowledge Mam.
@ldmlhome
@ldmlhome 3 года назад
WOWOWOW!!! This video is truly a keeper! THANK YOU!!!
@LeilaGharani
@LeilaGharani 3 года назад
Glad you like it :)
@najlas.3847
@najlas.3847 3 года назад
Very useful!! Thanks
@thebachelorsays1499
@thebachelorsays1499 3 года назад
Hey Leila, Fantastic & marvelous research on both excel & sheet. Kudos. keep it on.
@LeilaGharani
@LeilaGharani 3 года назад
Thank you! 😃
@DRC764
@DRC764 3 года назад
This is great!! I wasn't aware that Google Sheets was that powerful. Thanks Leila!!
@maks_zbogar
@maks_zbogar 2 года назад
Great video! Thank you!
@gladiadordoexcel2358
@gladiadordoexcel2358 3 года назад
Fantastic! I can't wait for next video. Thanks!
@georgeyoung7248
@georgeyoung7248 2 года назад
One feature I like a lot is being able to easily target a whole column minus the top row by just doing A2:A, for example.
@muhammadyousef6261
@muhammadyousef6261 3 года назад
Leila!! I love you, you have no idea how informative this video is to me.
@LeilaGharani
@LeilaGharani 3 года назад
Glad it was helpful!
@Naiemaa
@Naiemaa 3 года назад
and you are now my new superhero, for real, I like the initiative, and creativity you are showing in this video, on top of the usual clear and useful content.
@brahmmamb24
@brahmmamb24 3 года назад
Amazing tips.. thanks
@alokkumar1189
@alokkumar1189 3 года назад
Personally I was waiting for your lucid video on Google Sheets!!! Thank you very much. Hope see more videos in Google sheets
@LeilaGharani
@LeilaGharani 3 года назад
More to come!
@ajexcel
@ajexcel 3 года назад
Very much enjoyed...and learnt something new..gr8
@LeilaGharani
@LeilaGharani 3 года назад
Glad to hear that.
@ketandave3273
@ketandave3273 3 года назад
I haven't seen any function you have taught in this video! Thank you very much. Now I'll use Google sheet more regularly!
@LeilaGharani
@LeilaGharani 3 года назад
Glad you found it useful.
@at-excel
@at-excel 3 года назад
These are great functions and features. Thank you Leila ;-) Excel should catch up here "for reasons of compatibility".
@LeilaGharani
@LeilaGharani 3 года назад
Hi Andreas! Yes - Excel does have some catching up to do. Sheets also has to do some improvements though. More on that next week :)
@ajitmohanty1114
@ajitmohanty1114 3 года назад
Really very helpful while split...the address with mess up
@rajeshparkar5683
@rajeshparkar5683 3 года назад
Wow, was unaware about these features. Thank you Leila.
@LeilaGharani
@LeilaGharani 3 года назад
My pleasure.
@nadia.chuagoy
@nadia.chuagoy 3 года назад
Really appreciate your videos!
@michaeltheunissen609
@michaeltheunissen609 3 года назад
Mind blown...again . another great video! Thank you so much!
@LeilaGharani
@LeilaGharani 3 года назад
My pleasure!
@ataurrahman2819
@ataurrahman2819 3 года назад
Just Wow!!!!! Love each and every topic of this video. Please share more tips and tricks on google sheet.
@LeilaGharani
@LeilaGharani 3 года назад
Thank you! Will do!
@reng7777
@reng7777 3 года назад
This is just amazing i will start to test Google sheets vs excel as well and exploit its benefits!!!!
@michaeltoscano2296
@michaeltoscano2296 3 года назад
Amazing video! Thank you for sharing spreading knowledge!
@LeilaGharani
@LeilaGharani 3 года назад
My pleasure!
@robertovelicaz7719
@robertovelicaz7719 3 года назад
Very informative Leila! I did'nt know the versatility of Google Sheets. Thank you!
@LeilaGharani
@LeilaGharani 3 года назад
Glad you like it Roberto!
Далее
Google Sheets Query Function Explained
12:35
Просмотров 292 тыс.
Properly Convert PDF to Excel
11:28
Просмотров 1 млн
Excel Shortcuts You SHOULD Know!
8:48
Просмотров 2,1 млн
Excel LAMBDA - HOW & WHEN you Should use it
16:02
Просмотров 427 тыс.
Web Scraping in Google Sheets! (IMPORTXML FUNCTION)
7:32
Power Query Replaces XLOOKUP?!
1:00
Просмотров 27 тыс.
XLOOKUP function in #excel better than VLOOKUP
0:41
Просмотров 206 тыс.