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: th-cam.com/video/yXMo9sj0Y2Y/w-d-xo.html
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.)
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.
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.
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.
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. th-cam.com/channels/qPtlFvnP_7XJuAJik-rsnA.html
Thank you for this comparison Leila! My favorites: Flexibility of the drop down list Automatic refresh with the pivot tables Translate function Impressive!
at 13:10 Totals on the bottom of a table are a thing of the paper-era. We used to sum all the rows, and write the next figure down at the bottom. Nowadays it makes more sense to put the totals above the column names. That way you don't have to look all the way up to know what a number means, and you never have to scroll down a tab to know the summary in totals. When a table doesn't need a fancy presentation, you can double the rows of table headers, and put a summary of the larger table in between. Like in year totals - headers - monthly total rows - headers (fixated) - dayly rows.
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!
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!!!
@@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 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!
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.
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.
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.
Auto refreshing pivots and query are so powerful when combined. I work with inventory valuations and I make one sheet specifically to import data, then another to query the import and a bunch of added columns with formulas that clean some data or do calculations. Then I run multiple pivots on the query to have different data sets. Then I can create multiple dashboards with dropdowns by querying the different pivots. Total game changer for repeat reports.
Hi Leila! These tips are amazing. It would be interesting as well if you could share the activity spreadsheets so we could practice while watching the video tutorials. Thanks!
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!
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 TH-cam channel! I am your fan.
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
@@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 :)
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!!!
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!
1:50 can't you just leave the bottom cell undefined (C4:C) and capture everything in the row? Does it capture everything, or just to the first empty cell?
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.
This is simply stunning. As a power user of both Excel and Sheets, I myself had found the latter winning on some fronts but I was simply stunned by this excellent video. I have learnt so much from you in the past on Excel and now I know where to look to learn more about Sheets.
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.
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.
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.
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.
please trust me, Google Sheets is much more advanced, and it is the future. watch this tutorials, then you decide by urself th-cam.com/play/PLv9Pf9aNgemt82hBENyneRyHnD-zORB3l.html
An eye opener. I have never thought of Google Sheets having all these functionalities. Great video. You have given me something to explore. Nice video, nice furniture, nice background, nice apparel.
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
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!
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.
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)
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 🤣
Great overview of the distinctive powers of Sheets. One other really powerful feature is the integration of Forms. This enables you to collect data into your spreadsheet without giving others access to view a sheet. It's a great way to create a data input endpoint that can be used as the form itself or as a collection endpoint for a web application. Including a web application that you build in Google Sheets. Yes! You can build a web app in Google Sheets. That's another powerful aspect. Apps Script is a lot like VBA in Excel. Modification of multiple files across the file system, making copies from templates, sending emails, etc.. All the stuff you can do with VBA if you have the wizard's touch. I find it's easier in Apps Script and a lot more fun! Since it's on the web and has features for capturing who visited the document and when, there are some great analytics for who viewed your sheet built right in. Add in the ability to subscribe to changes AND edit the document at the same time and it's a collaboration powerhouse. Cell history is another feature that I love. Saving your work as you go is really handy and having multiple ways to audit your document history is dynamite. Where it starts to wear a little thin is in performance with large datasets. For larger scale stuff, Excel packs the horsepower.
I love your thumbnail. You are a wonder woman. Not all heroines wear capes or the like. Thanks for your invaluable Excel lessons/tutorials. I appreciate you, Leila.
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!
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.
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 .
Hi Leila, Once again I see a solution to one my very big problems in this video. Searchable Drop Down list is a bit difficult in Excel where it is built-in Google Sheets. I always wanted to maintain an inventory of articles that I use for my production and the list is pretty long and repetitive. I think now I can solve this problem with sheets. I will definitely update when I succeed. Thanks again for this wonderful video. Have a great day.
Very good feedback for Google-sheet compare to Microsoft-excel 365 limitation .I used window7 more than 10 years ! Every software there are Good/Bad limitations. And every software company will continuosly update their software ! Thus when your hands-on job requires Latest facilities, the expert users will refer to your recommentations . Thanks .
I never thought Google sheets had all these features, thanks to you leila, you have really enlighten me. Would be possible to make more detail video on the 2 items I like most.. Query function, import/export to html Many many thanks Leila, you are a life saver
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.
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.
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
@@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.
10:50, what is the formula you used to change the all the words based off the dropdown language? Thank you. Never mind! I think I got it!!! I used the IFS function. It was hard to understand, but here's my formula: =IFS(J2="Español",GOOGLETRANSLATE("Resident Name:", "auto", "es"), J2="English", GOOGLETRANSLATE("Resident Name:", "auto", "en")) If there's an easier way, please let me know. Thanks!
you just made have second thoughts about using excel or start using google sheets now. As always your tutorials are great. Thank you for teaching us so much Leila!!!
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.
Huge fan of Google sheets here but equally an Excel lover. Here are a few i. The validated cells are clearly visible in Google Sheets but in excel you have to either click to know them or use Go To special. ii. with Google Forms in place, the data collection is a cake walk. iii. Trimming functionality is amazing in sheets(Data
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
This is amazing. Subscribed. I use google sheets across all my devices for the quick access it affords me. I learned so many new things from this one video.
@vaxadiem since you have you have used google sheets extensively across all devices you said please how does it feel compare to excel, will like to take advantage to start using it , just want to get your feedback on this thanks
@@ayencoscolfield3312 in a nutshell, google office is "simpler" which is all I need, frankly. There are some features available only to the desktop browser that you can't use on mobile such as the match properties and alt+enter for a new line. Although excel and other ms siblings now have cloud sync, i still prefer google's real-time syncing. I cannot remember specifically which, but excel has some formulas that sheets does not. downside of sheets on desktop is if you dont have internet, you're out of luck. but mobile has a "make available offline" option which is convenient. also, google drive allows you to make homescreen shortcuts directly to a google drive folder or file. google office formatting is a little limited compared to ms office, but more efficient.
Thank you so much for this video & so many more. I'm wondering if maybe I missed it, would love the link if so :) My question is can google sheets importrange from sheets in different folders?
Thanks Leila! You did a wonderful job highlighting the Google Sheets features against MS Excel. I am honestly amazed that you did this video; I thought you might be focused wholly on MS Excel. I was wrong! Thank you again, and I look forward to the next installment!
I think you could also look at the edge of the sheets over coding. Google Script is more lexically comfortable than VBA. For example. GS: "my_variable += 10" against VBA: "my_variable = my_variable + 10".
Wonderful! I am learning about pivot tables.... curious about the double query you used in curly brackets {QUERY for pivot; QUERY for total}.... intersting.. learned soooo much THANK YOU!
Thank you Leila, the Excel develloper team has a lot of work to do, not to mention the enormous list of issues on "Uservoice Excel". Another difference is Google Forms vs Excel Forms. I really appreciated this video, maybe there is a simple way that Excel and Google sheets can interact. I saw some on the internet but they were not that easy to set up. Looking forward to see this kind of video's every year....
Thanks Bart. Google has implemented an "Excel view" so you can easily collaborate between GS and Excel. I tested it and it works well to an extent (Hyperlinks and shapes are a problem).
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.
I have just started using Google Sheets about a month ago. Reason is not all of our employees have Microsoft Excel. I am surprised of the similarities of the two. Great video to promote Google Sheets.
I have used Libre office in the past to do some functions that Excel couldn't do. Thank you for showing me some of these so that I can do the same with sheets. I really like the split function
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: th-cam.com/video/yXMo9sj0Y2Y/w-d-xo.html
Tashakor 🙏
Bet Microsoft staff are watching this and planning some upgrades. Healthy competition.
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.
Very good video. Thank you!
Looking forward to more Google courses.
I need this sheet for formula can you share with me plz
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.)
Go ahead, we still following you
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.
Is there an alternative for Ctrl+g / F5 in Excel with Sheets .... Looking forward for your reply
Google Sheets is very powerful in comparison with Excel online.
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.
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.
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. th-cam.com/channels/qPtlFvnP_7XJuAJik-rsnA.html
In data validation (1:50) you can actually leave the column reference open (B3:B) to prepare for extra rows.
Actually just left a comment asking if you could do that. Will it capture everything in the row, or just to the first blank?
@@samueldeter9735 It will capture everything in column B, from B3 and down, regardless of blank rows.
Google Sheets has the advantage of working on leap year, since Office is only 365 days of the year.
🤣
😂😂
😁
OMG. You Win!
😭😂🤣🤣
Every time I watch a new video of you, I realize how much I still have to learn.
Thanks a lot, great information 👍, looking forward the excel advantages 😎
Coming up next week :)
Thank you for this comparison Leila!
My favorites:
Flexibility of the drop down list
Automatic refresh with the pivot tables
Translate function
Impressive!
at 13:10 Totals on the bottom of a table are a thing of the paper-era. We used to sum all the rows, and write the next figure down at the bottom. Nowadays it makes more sense to put the totals above the column names. That way you don't have to look all the way up to know what a number means, and you never have to scroll down a tab to know the summary in totals. When a table doesn't need a fancy presentation, you can double the rows of table headers, and put a summary of the larger table in between. Like in year totals - headers - monthly total rows - headers (fixated) - dayly rows.
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!
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!!!
Thank you for the kind feedback!
Ok, now I'm waiting for the video named "Excel BEATS Google Sheets with these 10 features!"
Great Job Leila. As always.
Excel is long runner
@@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...
Coming up next Thursday. Stay tuned :)
@@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!
YAAAAAAAAS!!! I put my money on Excel. I still liked this video. Good stuff!👍
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.
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.
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.
Wow. I just realized, I have underestimated sheets till now!
Same! I really didn't realize that much could be done in Sheets. I'm interested to learn more now!
Likewise me. Quite enlightening from Leila. Got my learning hat on again.
Thats because you dont use it on a more advanced level.
Auto refreshing pivots and query are so powerful when combined. I work with inventory valuations and I make one sheet specifically to import data, then another to query the import and a bunch of added columns with formulas that clean some data or do calculations. Then I run multiple pivots on the query to have different data sets. Then I can create multiple dashboards with dropdowns by querying the different pivots. Total game changer for repeat reports.
Hi Leila! These tips are amazing. It would be interesting as well if you could share the activity spreadsheets so we could practice while watching the video tutorials. Thanks!
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!
Glad it was helpful! See you next week :)
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 TH-cam channel!
I am your fan.
Glad to hear Augusto! And yes, it's always good to keep an open mind.
Awesome Video!!!! I Love Leila Super Hero to the rescue : ) : )
Your friendly neighborhood Super Nerd :)
@@LeilaGharani Never a "nerd".
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
@@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 :)
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!!!
Wow, thanks!
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!
Google's Connected Sheets?
Hi Leila
Thanks for sharing. Very insightful.
Could you explore further in Google Sheet QUERY function? especially the advance functions.
Thanks.
I like the ability to use images as values. Cool. The chatting feature when sharing workbooks is already possible in Microsoft Teams.
1:50 can't you just leave the bottom cell undefined (C4:C) and capture everything in the row? Does it capture everything, or just to the first empty cell?
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.
This is simply stunning. As a power user of both Excel and Sheets, I myself had found the latter winning on some fronts but I was simply stunned by this excellent video.
I have learnt so much from you in the past on Excel and now I know where to look to learn more about Sheets.
Great to hear!
@@LeilaGharani take care and stay safe.
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.
Noted!
wow, that Query function is just super useful. As someone very comfortable with SQL it's a gamechanger. Your videos are always super helpful.
Glad to hear that!
Yes mam , many GS functions are really worth using in daily tasks at office. Nicely explained like always.
Leila!!
I love you, you have no idea how informative this video is to me.
Glad it was helpful!
I have always underrated Google sheets. This is mind blowing.
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!🤗😘
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.
LivreOffice Calc also do it.
Hello..thank u for your review the difference between both of them, can u share another video about WPS Sheets too?
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.
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.
@@PaulRoneClarke That is good to know … you've piqued my interest (but just a wee bit) … thank you for taking the time to comment.
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.
please trust me, Google Sheets is much more advanced, and it is the future. watch this tutorials, then you decide by urself th-cam.com/play/PLv9Pf9aNgemt82hBENyneRyHnD-zORB3l.html
@@PaulRoneClarke This might be possible because under the hood both applications are using Javascript? I wonder.
An eye opener. I have never thought of Google Sheets having all these functionalities. Great video. You have given me something to explore. Nice video, nice furniture, nice background, nice apparel.
Thanks Shadrack for dropping by :)
I love the thumbnail! 😊
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
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!
You are simply very dedicated to excel.....I fully admire you.......Thank you for this head to head comparison .
Microsoft be like..
"Write that down! Write that down! We should steal those features!"
😁
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.
@@kal_jorEl common u gotta have a funny bone somewhere 😂
Been watching you for a few years now, love your content!
Awesome! Thank you!
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)
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!
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 🤣
Freezing in Excel-on-the-web? I haven't noticed that. When does this" freezing" occur? Please give an example. Thank you.
Great overview of the distinctive powers of Sheets. One other really powerful feature is the integration of Forms. This enables you to collect data into your spreadsheet without giving others access to view a sheet. It's a great way to create a data input endpoint that can be used as the form itself or as a collection endpoint for a web application. Including a web application that you build in Google Sheets. Yes! You can build a web app in Google Sheets. That's another powerful aspect. Apps Script is a lot like VBA in Excel. Modification of multiple files across the file system, making copies from templates, sending emails, etc.. All the stuff you can do with VBA if you have the wizard's touch. I find it's easier in Apps Script and a lot more fun!
Since it's on the web and has features for capturing who visited the document and when, there are some great analytics for who viewed your sheet built right in. Add in the ability to subscribe to changes AND edit the document at the same time and it's a collaboration powerhouse. Cell history is another feature that I love. Saving your work as you go is really handy and having multiple ways to audit your document history is dynamite.
Where it starts to wear a little thin is in performance with large datasets. For larger scale stuff, Excel packs the horsepower.
Many thanks Steve for the detailed comment! Agree on all points.
There's another great advantage of getting median values in pivot tables without much efforts which is often better than averages.
I love your thumbnail. You are a wonder woman. Not all heroines wear capes or the like. Thanks for your invaluable Excel lessons/tutorials. I appreciate you, Leila.
Leila, I wish everyday is Thursday!
🤗
Hey Leila,
Fantastic & marvelous research on both excel & sheet. Kudos. keep it on.
Thank you! 😃
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!
@@bobtahoma of course Microsoft would never do that.
There is a reason MS Office is paid and Google office is free.
Yess, I use sheets for personal due to its free. Excel for work as it's the company's software.
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.
Can you do a simple and quick tutorial for QUERY?
Noted!
I love excel and even didn't consider sheets as its alternative, but your video have changed my mind and now I'm interested in this.
Thank you Leila!🤗
Great to hear!
Functions like Filter and Unique are available in Google sheets whereas these are only available in latest Excel versions.
learnt something new today ''split'' function. Will come in handy. I appreciate all the videos you do.
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.
I also really like it. But Excel will have StockHistory at some point.
Leila Gharani That will be a great addition. I’m looking forward to watching your next video to see how Excel comes back!
Thank you for the useful video! How do we create the dropdown feature with automatic language translation? Video Reference: 10:51
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
.
Hi Leila,
Once again I see a solution to one my very big problems in this video. Searchable Drop Down list is a bit difficult in Excel where it is built-in Google Sheets. I always wanted to maintain an inventory of articles that I use for my production and the list is pretty long and repetitive. I think now I can solve this problem with sheets. I will definitely update when I succeed.
Thanks again for this wonderful video.
Have a great day.
Searchable lists are in Excel online already th-cam.com/video/nGYrzXKVaII/w-d-xo.html
Damn u look awesome with wonderwoman and supergirl coslay
Very good feedback for Google-sheet compare to Microsoft-excel 365 limitation .I used window7 more than 10 years ! Every software there are Good/Bad limitations. And every software company will continuosly update their software ! Thus when your hands-on job requires Latest facilities, the expert users will refer to your
recommentations . Thanks .
Please say "X" in each video just like that. I love the way tou say it 😁
I'll try :)
I never thought Google sheets had all these features, thanks to you leila, you have really enlighten me. Would be possible to make more detail video on the 2 items I like most.. Query function, import/export to html
Many many thanks Leila, you are a life saver
Glad you like the video. I made a note about your topics.
Google sheets is amazing. At this point, I only use Excel when absolutely necessary
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.
ONLY THING keeping me from using Google Sheets is the fact that it doesn't have an offline version on windows
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)
It has offline version, right click the sheet in your drive and turn offline or turn offline mode in Google drive settings
@@paulo.galvao libreOffice is amazing but doesn't have good RTL support
Prasad Mhatre
Except it does
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
Wow, thank you!
I do wonder how Leila finds the time (and the money) to obtain a super girl outfit JUST for this video.
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.
Use Google Connected Sheets to handle billions of rows.
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
@@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.
10:50, what is the formula you used to change the all the words based off the dropdown language? Thank you.
Never mind! I think I got it!!! I used the IFS function. It was hard to understand, but here's my formula:
=IFS(J2="Español",GOOGLETRANSLATE("Resident Name:", "auto", "es"), J2="English", GOOGLETRANSLATE("Resident Name:", "auto", "en"))
If there's an easier way, please let me know. Thanks!
QUERY function alone is enough to rate sheets over excel
timestamp?
okay 11:46
you just made have second thoughts about using excel or start using google sheets now. As always your tutorials are great. Thank you for teaching us so much Leila!!!
You're very welcome, Giancarlo!
Here is one thing you CAN NOT do in Sheets : Create a Table.
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.
It's a bit of a curse NOT seeing it as - a feature actually, in Googles favor..
Huge fan of Google sheets here but equally an Excel lover. Here are a few
i. The validated cells are clearly visible in Google Sheets but in excel you have to either click to know them or use Go To special.
ii. with Google Forms in place, the data collection is a cake walk.
iii. Trimming functionality is amazing in sheets(Data
Thanks for sharing your tips!
Leila, you forgot one important feature: Google Sheets costs nothing :)
costs ur data
Hint: I would not use Sheets to manage the books of my cannabis business.
Personally I was waiting for your lucid video on Google Sheets!!! Thank you very much. Hope see more videos in Google sheets
More to come!
I'll wait for "Power Query beats everything". I miss being a Google investor though 😔
I missed that boat too :) Excel fights back next week!
Hi,
Leila, You are Fab!
I am addicted to your videos.
Stay Blessed and Stay Safe.
Thank you! You too!
I'm starting to like Google Sheets. Does that make me a bad person?
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
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.
Yes. Yes it does.
Yes
This is amazing. Subscribed. I use google sheets across all my devices for the quick access it affords me. I learned so many new things from this one video.
Thanks for the sub!
@vaxadiem since you have you have used google sheets extensively across all devices you said please how does it feel compare to excel, will like to take advantage to start using it , just want to get your feedback on this thanks
@@ayencoscolfield3312 in a nutshell, google office is "simpler" which is all I need, frankly. There are some features available only to the desktop browser that you can't use on mobile such as the match properties and alt+enter for a new line. Although excel and other ms siblings now have cloud sync, i still prefer google's real-time syncing. I cannot remember specifically which, but excel has some formulas that sheets does not. downside of sheets on desktop is if you dont have internet, you're out of luck. but mobile has a "make available offline" option which is convenient. also, google drive allows you to make homescreen shortcuts directly to a google drive folder or file. google office formatting is a little limited compared to ms office, but more efficient.
I can't lie the main reason I'm here is because the instructor is damn beautiful LOL
I had always looked down on G Sheets.. But this is just crazy stuff. Need to delve deeper in G Sheets.
As always, no words to thank you ..
Leila please make a full series on Google sheets
It's looking really amazing
Noted!
Would really appreciate it.
Thank you so much for this video & so many more. I'm wondering if maybe I missed it, would love the link if so :) My question is can google sheets importrange from sheets in different folders?
Thanks Leila! You did a wonderful job highlighting the Google Sheets features against MS Excel. I am honestly amazed that you did this video; I thought you might be focused wholly on MS Excel. I was wrong! Thank you again, and I look forward to the next installment!
One has to keep an open mind. Next week Excel fights back though :)
Great Summary! Waiting for the fight back of Excel next week
I think you could also look at the edge of the sheets over coding. Google Script is more lexically comfortable than VBA. For example. GS: "my_variable += 10" against VBA: "my_variable = my_variable + 10".
Wonderful! I am learning about pivot tables.... curious about the double query you used in curly brackets {QUERY for pivot; QUERY for total}.... intersting.. learned soooo much THANK YOU!
Glad you enjoyed it, Steve!
Thank you so much...Please continue this. I was considering google sheets as preview my xls contents....this is very informative
These are great functions and features.
Thank you Leila ;-)
Excel should catch up here "for reasons of compatibility".
Hi Andreas! Yes - Excel does have some catching up to do. Sheets also has to do some improvements though. More on that next week :)
Thank you Leila, the Excel develloper team has a lot of work to do, not to mention the enormous list of issues on "Uservoice Excel". Another difference is Google Forms vs Excel Forms. I really appreciated this video, maybe there is a simple way that Excel and Google sheets can interact. I saw some on the internet but they were not that easy to set up. Looking forward to see this kind of video's every year....
Thanks Bart. Google has implemented an "Excel view" so you can easily collaborate between GS and Excel. I tested it and it works well to an extent (Hyperlinks and shapes are a problem).
Excellent overview, thanks!
Just Wow!!!!! Love each and every topic of this video. Please share more tips and tricks on google sheet.
Thank you! Will do!
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.
I have just started using Google Sheets about a month ago. Reason is not all of our employees have Microsoft Excel. I am surprised of the similarities of the two. Great video to promote Google Sheets.
Thanks for sharing Mark.
You're such a fine teacher. You made me realize that teaching is a calling, some people are called to do it and so they do it better.
Wow, thank you!
great effort for the cover image! thumbs up for your creativity and humour!!!
Thank you so much 😀
I have used Libre office in the past to do some functions that Excel couldn't do. Thank you for showing me some of these so that I can do the same with sheets. I really like the split function
Split is really great!
I'm curious to know what is your formula for that bar chart using sparkline @ timestamp 14:15 . That is very useful for quick analysis
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.