Looking forward to chatting tomorrow when this premiers. In case you haven't watched the previous video, watch it before this one: ua-cam.com/video/n2DxXffRxBM/v-deo.html. Curious which application will be the winner for YOU.
It's Always Excel. Google sheets were not user-friendly to use comparing to Excel. It's like Even though IPhone Might makes us curious, but not user-friendly and most like Android!
Excellent video. Can you do one where Excel or sheets connect to MSSQL or other databases with realtime updating? Or non realtime if realtime is not possible? Many thanks.
@LeilaGharani - do you know, if all things are equal, does using a table format increase file size? I work in huge files, and try to shave off file size wherever I can. So, assuming 2 files, same data in both files.... 1 is formatted as a Table, the other is a Range. Should these files be the same sizes?
Love the tables, had no idea, just wanted to note that in Google Sheets you can "D2:D" to select the entire column without needing to type it out. Still nowhere near as clean as the Excel tables, but worth knowing maybe
I'm so glad that I found your channel 2 years ago. In this 2 years, I've learned so much from all of your videos. I can say that I started with 0 in excel, but now I'm a data analysis! That makes you also a great teacher. (Sorry for my bad English, buy yeah, you know what I mean). 😉
As an hr practitioner who needs to do employee profiling, one of the most important features for me is the image lookup which i've tried so hard to do in excel but i just failed. Now that i've learned that g sheets has that image lookup (thanks to ms. Leila's channel), i think i'd transfer my data to g sheets, especially that i needed others to help me with the file now. i'd like the xlookup, format as table and set print area for g shheets too so that my experience will be completely satisfying
Great video. Obviously Power Query and Power Pivot are quite key. It would have been interesting to see a comparison in how you could get data from an external source in Sheets vs Excel to illustrate this difference though. For example, how would you go about extracting data from a series of text files in Sheets for use in a pivot table with an element of relationship modelling. Whether there is anything even close to a substitute in Sheets.
You are indeed the Excel Wonder Woman Leila! Thank you for making these comparisons. One comment I would add is the serious Google Sheets limitation with the maximum number of cells of a worksheet and the long processing time when working with a 15-20 Mb file. For example Google Sheets is not able to handle analyzing work orders with tens of thousands lines of labor and parts costs which is not an uncommon feast for a medium size service company. There is no debate for a Power User which is the better application as shown by your demonstrations.
I love your videos Leila, and thanks for the comparison. The contest though is an unfair one because you compare Google Sheets that runs online versus a fully featured Excel. A fair boxing match would have been Google Sheets versus Excel Online. My thoughts.
@ Leila - 3D Formulas and Hash References are Leila's Highlights in this video. All other options looks normal. But, understood that it relates to Heading! Thanx for Sharing.
A big fan for long!! Your way of explaining and showing examples are super. Also the title pictures of your video's are very clear and handy! Many greetings from Amsterdam!!!
This was super comprehensive and really amazing. I think I am going to stick to excel for now. Plus can't wait for your course on DAX/Excel data modelling. Loved the Power Query course.
Long-time Watcher, first time commenter. You forgot muscle memory. I have 25 years of using Excel. Every time I go to Sheets I am so much slower with everything. A couple of years ago sitting with a client, who grew up using Sheetes, building a spreadsheet and they could not believe how quickly I could build a spreadsheet.
@@LeilaGharani Leila. I thought I was a SS expert as I had been using them since 1980 with VISICALC on an Apple then Lotus 1-2-3 on a PC and then Excel since the early 90's. I actually worked for both Lotus and Microsoft in management from the late 80's and 90's and I passed the Excel certification testing that MS had at the time. Since 2000, I have built lots of spreadsheets for my companies and others. Then I started watching your videos and realized I had missed many, many amazing features. We did a study at Lotus and discovered that average users only used 5-10% of the available features. I never thought I would would fall into that category. But I did over time. Yes I used multi nested if statements and pivot tables. but I had got lazy. I started watching your videos when I had a complex table based SS to build and I learned so much very quickly and easily. Your style is great. You are my go to when I want to learn a new feature. Thanks for making these videos accessible to everyone. Cheers...K
I love your efforts on not only sharing knowledge free of charge(which is amazing, and I wholeheartedly appreciate you for that) but you also upped your thumbnail game! LOVE IT! keep up the amazing work, and I truly thank you for your time and effort for preparing these incredible videos.
Once again, a great video. I didn't know about GO TO SPECIAL. I have spent so much time dragging down values from spreadsheets which are set up in groupings. This is a great Tip!!
One more point in MS Excel's favour: Excel doesn't use floating point math (as long as I've noticed), which is something that Google Sheets does. Had to learn about this "feature" the hard way. :D
Xlookup seem interesting, but whenever I need to look for data on the right-hand side of the index, I just create a range with the {} operator =Vlookup(A2, {Table!E:E,Table!A:A }, 2, 0)
As always, these videos are insanely well done. Very insightful and the explanations are clear enough for a commoner like me to understand. I just learned how to solve a problem I didn't know I had until I saw the Hash section. Amazing
I selected Excel over Sheets specifically for the column (horizontal) sort function, it is absent from Sheets. My application is an oddity in that it has a crucial visual component that relies on column reordering. But bravo to Sheets for bringing competition back to the spreadsheet arena.
OOPs, missed the premier as I got late, but no regret! 😁 Watched it again all over and it's 10/10 for the 10 features of Excel you explained in that "Leila Style" we have come to love! Cheers! 😊👍
The amount of work put into these videos is a lot. This was highly edutaining. Thanks! Choice of super heroes is meh though. Jean gray for excel and hawk girl for sheets is more like it...for me Wait you know VBA? Small wonder you can simplify many of these features. You were born to teach!
Overall, Excel on the top but "sheets" should be also in a toolbar for quick access and solving some "ad-hoc" things when necessary. I am sure on long term "sheets" will be as good as Excel.
You forgot to compare the "Goal Seek" function and the "Solver" Add-in in both applications (very important Excel functions in engineering). I have a question for you: is it possible to use LaTex code to type text inside a cell in Excel or Sheets? Thank you very much for your videos, they are very helpful.
Leila Gharani thanks for your reply 😁😁! I didn’t know about that, does it include user forms too? I guess excel still has the advantage because we have your VBA course to help us learn 😉
Set Print Area has been in Excel since at least v4 in 1992. I don't remember it in v2 (1987) and I never used v3. I am amazed that Google Sheets doesn't have it.
I think it would be cool if you compared Power Query with Google Query Language in a dedicated video just for the topic. While they are syntacticallty different, they perform similar roles. Google`s Importrange() references other sheets, while power query can reference other documents in different sources as well. Google Sheets have permalinks, even if the file moves or is renamed, the formulas will not break (this is important)
the way to write spilled ranges or hash reference like you said in the video in google sheets is to drop the range reference at the end like instead of writing a2:c10 you can do =ArrayFormula(A2:C) , its pretty old in google sheets , i don't know how u didn't find out about it.
I use that, but that's not spilled ranges like in Excel. They include any other data that might be on that column. Spilled ranges are restricted to the specified range but they grow as the range grows. They don't include data from other tables that might be below the first one.
I was missing two fuctions: 3D Formulas and Hash References. The first one, probably, because I have never had a use case. The second one, because my italian enterprise 360 version doesn't have it (like xlookup and other new functions that I know thanks to your videos XD ). And this lead me to another point in favor of google sheets: just one version, global upgrades release, and so on. Anyway, pros and cons of both. Depends on the purpose, e.g. now I want to try sync Google Calendar with Google Sheets. I still keep thinking that Excel is generally better than sheets, but it is even much older. Sheets, otherwise, is not a mere copy of Excel like others (has google's touch) and it has great potential Awesome video :) keep it up :D
Awesome Video as usual! Is it possible to colorize cells with comments automatically? "Go To Special" is awesome but this step needs to be repeated in order to be up-to-date. I can't find a conditional formatting for this task.
Hi Leila, I've learned a lot from you. Thank you for providing these videos. I have a question regarding Go to Special. If I want to select all blanks in a column but copy the values below each blank cell, what should I do? Thank you very much!
XLOOKUP() is cool, but Google sheets lets you create on-the-fly arrays in curly brackets so you can use VLOOKUP() and order the columns any way you need within your array brackets.
Yes, Excel is impressive in many ways. The features that were presented here are the ones that are really useful especially in data arrangements. The fact that Google Sheet is a web-based app makes it more of an app than a stand-alone software. While Excel can work with or without internet.
Yes my Ctrl+g [Go to Special] figured in your list ...An awesome one in excel .... I am referring both your videos to my friends .... as usual you are too good in your lectures .... thanks
Looking forward to chatting tomorrow when this premiers. In case you haven't watched the previous video, watch it before this one: ua-cam.com/video/n2DxXffRxBM/v-deo.html.
Curious which application will be the winner for YOU.
It's Always Excel. Google sheets were not user-friendly to use comparing to Excel.
It's like Even though IPhone Might makes us curious, but not user-friendly and most like Android!
Excellent video. Can you do one where Excel or sheets connect to MSSQL or other databases with realtime updating? Or non realtime if realtime is not possible? Many thanks.
@LeilaGharani - do you know, if all things are equal, does using a table format increase file size? I work in huge files, and try to shave off file size wherever I can. So, assuming 2 files, same data in both files.... 1 is formatted as a Table, the other is a Range. Should these files be the same sizes?
Google Sheets has "Image in Cell."
So freaking useful for pumping out visual reports, signage, POPs, promotional material, etc.
Excel is insanely powerful and I love how you demonstrate this in such a cool way. Again amazing thumbnails as always :)
Glad you think so! 😁
Love the tables, had no idea, just wanted to note that in Google Sheets you can "D2:D" to select the entire column without needing to type it out. Still nowhere near as clean as the Excel tables, but worth knowing maybe
I'm so glad that I found your channel 2 years ago. In this 2 years, I've learned so much from all of your videos. I can say that I started with 0 in excel, but now I'm a data analysis! That makes you also a great teacher. (Sorry for my bad English, buy yeah, you know what I mean). 😉
Wow, thank you!
@@LeilaGharani I agree, you are amazing Leila, I learned all from your video only. Thank you so much..
As an hr practitioner who needs to do employee profiling, one of the most important features for me is the image lookup which i've tried so hard to do in excel but i just failed. Now that i've learned that g sheets has that image lookup (thanks to ms. Leila's channel), i think i'd transfer my data to g sheets, especially that i needed others to help me with the file now. i'd like the xlookup, format as table and set print area for g shheets too so that my experience will be completely satisfying
Sounds great!
Your series on the features of Microsoft Excel and how it differs from Google Sheets was excellent and well presented.
Where have you been all my excel life. Thanks for giving me wings.
Great video. Obviously Power Query and Power Pivot are quite key. It would have been interesting to see a comparison in how you could get data from an external source in Sheets vs Excel to illustrate this difference though. For example, how would you go about extracting data from a series of text files in Sheets for use in a pivot table with an element of relationship modelling. Whether there is anything even close to a substitute in Sheets.
You are the best ! Your teaching skills are more powerful than these excellent excel tools.
Wow, thanks!
Cool series, Leila!!!!!!!
Thanks Mike!
In short: It's better in any way that matters if you want to do serious work / data wrangling. Excel is a much deeper rabbit hole.
You are indeed the Excel Wonder Woman Leila! Thank you for making these comparisons. One comment I would add is the serious Google Sheets limitation with the maximum number of cells of a worksheet and the long processing time when working with a 15-20 Mb file. For example Google Sheets is not able to handle analyzing work orders with tens of thousands lines of labor and parts costs which is not an uncommon feast for a medium size service company. There is no debate for a Power User which is the better application as shown by your demonstrations.
This is a really, REALLY useful video... thank you 👍👍👍
Glad it was helpful!
I love your videos Leila, and thanks for the comparison. The contest though is an unfair one because you compare Google Sheets that runs online versus a fully featured Excel. A fair boxing match would have been Google Sheets versus Excel Online. My thoughts.
For me, the best of Excel features (comparing with Google sheets) is Power Query!
True, Power Query is great!
THANKS, Ienjoy these two videos, really interesting,I always wondered the differences between one and the other
Glad you like them!
@ Leila - 3D Formulas and Hash References are Leila's Highlights in this video. All other options looks normal. But, understood that it relates to Heading! Thanx for Sharing.
Power Query really is the best highlight and if you learn it you will be able to see that its so powerful
A big fan for long!! Your way of explaining and showing examples are super. Also the title pictures of your video's are very clear and handy! Many greetings from Amsterdam!!!
Great information, as usual... always same expectations and same result got from your side...Thanks
This was super comprehensive and really amazing. I think I am going to stick to excel for now. Plus can't wait for your course on DAX/Excel data modelling. Loved the Power Query course.
Same. The power query course has been life changing.
Awesome, thank you!
Long-time Watcher, first time commenter. You forgot muscle memory. I have 25 years of using Excel. Every time I go to Sheets I am so much slower with everything. A couple of years ago sitting with a client, who grew up using Sheetes, building a spreadsheet and they could not believe how quickly I could build a spreadsheet.
Good point, thanks Karl.
@@LeilaGharani Leila. I thought I was a SS expert as I had been using them since 1980 with VISICALC on an Apple then Lotus 1-2-3 on a PC and then Excel since the early 90's. I actually worked for both Lotus and Microsoft in management from the late 80's and 90's and I passed the Excel certification testing that MS had at the time. Since 2000, I have built lots of spreadsheets for my companies and others. Then I started watching your videos and realized I had missed many, many amazing features. We did a study at Lotus and discovered that average users only used 5-10% of the available features. I never thought I would would fall into that category. But I did over time. Yes I used multi nested if statements and pivot tables. but I had got lazy. I started watching your videos when I had a complex table based SS to build and I learned so much very quickly and easily. Your style is great. You are my go to when I want to learn a new feature. Thanks for making these videos accessible to everyone. Cheers...K
A great pair of videos! I hope the product managers of both Excel and Sheets watch these.
I love your efforts on not only sharing knowledge free of charge(which is amazing, and I wholeheartedly appreciate you for that) but you also upped your thumbnail game! LOVE IT! keep up the amazing work, and I truly thank you for your time and effort for preparing these incredible videos.
The amazing Leila, your skills are incredible! take care.
Once again, a great video. I didn't know about GO TO SPECIAL. I have spent so much time dragging down values from spreadsheets which are set up in groupings. This is a great Tip!!
Glad it was helpful!
Very comprehensive Leila! Great video. Excel is the winner in my book. PQ puts it over the top
Power Query is hard to beat :)
One more point in MS Excel's favour: Excel doesn't use floating point math (as long as I've noticed), which is something that Google Sheets does. Had to learn about this "feature" the hard way. :D
Xlookup seem interesting, but whenever I need to look for data on the right-hand side of the index, I just create a range with the {} operator
=Vlookup(A2, {Table!E:E,Table!A:A }, 2, 0)
The fill blanks example at 12:40 needs more attention... great trick!
As always, these videos are insanely well done. Very insightful and the explanations are clear enough for a commoner like me to understand. I just learned how to solve a problem I didn't know I had until I saw the Hash section. Amazing
Much appreciated!
You in a superheroine's outfit. How fitting! I enjoy your videos... you have excellent diction and are very informative.
You are awesome ma’am... excellent teacher 👍🙏
I selected Excel over Sheets specifically for the column (horizontal) sort function, it is absent from Sheets. My application is an oddity in that it has a crucial visual component that relies on column reordering.
But bravo to Sheets for bringing competition back to the spreadsheet arena.
I have been working with Excel for a while now but I am always surprised how little I know. Thanks for the video. As always just great.
Great to hear!
You are a real life Superhero...
Great video. I think that the overall vba(script)/macro functionality is miles ahead in excel (buttons, shortcuts, custom menus, references in vba).
I like your way of teaching, do you have any power query video on excel for mac ?
Unfortunately, there really isn't much Power Query functionality in Excel for Mac (yet).
OOPs, missed the premier as I got late, but no regret! 😁 Watched it again all over and it's 10/10 for the 10 features of Excel you explained in that "Leila Style" we have come to love! Cheers! 😊👍
Glad you enjoyed it!
The ability to link a number to a shape is great!
Excel never ceases to amaze
The question is, who will be faster to upgrade and include the other features? Microsoft or Google?
I'd put my money on Google sheets. They've been adding new capability weekly. Excel is famous for very old errors that have never been fixed.
I hope it's google because they're free to use and i hope it continues to be free. HAHAH
I'd really love to have that program where all of the advantages of g sheets and excel is fused into one
Thank you Leila. Excel is much better than Google Sheets!
Hi Leila. Great summary of 10 superior EXCEL features. Thanks for sharing them :)) Thumbs up!!
The amount of work put into these videos is a lot. This was highly edutaining. Thanks! Choice of super heroes is meh though. Jean gray for excel and hawk girl for sheets is more like it...for me
Wait you know VBA? Small wonder you can simplify many of these features. You were born to teach!
Much appreciated!
awesome video! Thank you!
Glad you liked it!
Please do Numbers vs Excel, I have MacBook Pro but never used Numbers
Overall, Excel on the top but "sheets" should be also in a toolbar for quick access and solving some "ad-hoc" things when necessary. I am sure on long term "sheets" will be as good as Excel.
Wow. I love your explanations. Thanks for sharing
My pleasure!
Well Done,, google sheet have also flash fill
You forgot to compare the "Goal Seek" function and the "Solver" Add-in in both applications (very important Excel functions in engineering).
I have a question for you: is it possible to use LaTex code to type text inside a cell in Excel or Sheets?
Thank you very much for your videos, they are very helpful.
OpenSolver is much better than Excel native Solver cause it's not limited.
Thank you for another awesome video. I learned so much.
You are so welcome!
The winner is... Leila!!
Thanks for sharing your knowledge 👍🏻
I thought I’d see something about VBA in here 🤔
Thanks 😊 I left out VBA because in sheets you also have macros (apps script based on Javascript)
Leila Gharani thanks for your reply 😁😁! I didn’t know about that, does it include user forms too? I guess excel still has the advantage because we have your VBA course to help us learn 😉
But soon I'll launch my Google Sheets course 😉
I think one of the biggest pluses for Excel is being able to edit multiple tabs at once where you cannot do that on Sheets without a code.
Set Print Area has been in Excel since at least v4 in 1992. I don't remember it in v2 (1987) and I never used v3. I am amazed that Google Sheets doesn't have it.
Me too Katrina :)
Even without watching i know its a great video with amazing content.
Wow, thanks!
@@LeilaGharani we shall be thankful to you for all your videos.
Now it's so fair, honestly, I was upset with the previous video when Google Sheets beat Excel.
Thank you Leila.
I think it would be cool if you compared Power Query with Google Query Language in a dedicated video just for the topic.
While they are syntacticallty different, they perform similar roles.
Google`s Importrange() references other sheets, while power query can reference other documents in different sources as well.
Google Sheets have permalinks, even if the file moves or is renamed, the formulas will not break (this is important)
power query and power pivot are superior, so im sticking to excel
the way to write spilled ranges or hash reference like you said in the video in google sheets is to drop the range reference at the end like instead of writing a2:c10 you can do =ArrayFormula(A2:C) , its pretty old in google sheets , i don't know how u didn't find out about it.
I use that, but that's not spilled ranges like in Excel. They include any other data that might be on that column. Spilled ranges are restricted to the specified range but they grow as the range grows. They don't include data from other tables that might be below the first one.
Queen of excel with another great comparison between google sheet and excel...
I know excel is way better then google sheets.
i will follow your videos thank you so much
Great as always! Thanks Leila!
Glad you liked it, Peter!
Thanks Leila, great comparison. Sticking with Excel...
My usual Thursday night excel date with Leila. Great video as always. Shall we do it again next week? 😁
Definitely!! :)
05:36 Flash Fill Very nice example
Very good video. Gracias amiga. Saludos desde Venezuela.
I was missing two fuctions: 3D Formulas and Hash References. The first one, probably, because I have never had a use case. The second one, because my italian enterprise 360 version doesn't have it (like xlookup and other new functions that I know thanks to your videos XD ). And this lead me to another point in favor of google sheets: just one version, global upgrades release, and so on.
Anyway, pros and cons of both. Depends on the purpose, e.g. now I want to try sync Google Calendar with Google Sheets.
I still keep thinking that Excel is generally better than sheets, but it is even much older. Sheets, otherwise, is not a mere copy of Excel like others (has google's touch) and it has great potential
Awesome video :) keep it up :D
Thanks for your feedback Giuseppe!
You are the best on all UA-cam
Wow, thanks Ali!
You hit all the good ones!
XLOOKUP, Data Models, Power Query.
Excel is the tool for adults who work with data. 🔥🔥🔥
😁
Thanks
Awesome Video as usual! Is it possible to colorize cells with comments automatically? "Go To Special" is awesome but this step needs to be repeated in order to be up-to-date. I can't find a conditional formatting for this task.
I wish Google sheets team sees your comparison videos and make it better! Thanks!
Power Query and Data Models makes it so much more superior to Sheets. Once an Excel fan, ALWAYS one!
Can you help how to compere program language evolution using excel chart please
Congratulations very good video 😚
Thank you! Cheers!
Another great video Leila, thank you. I eagerly look forward to Microsoft making Power Query available to Mac users (hopefully soon!).
I hope so too!
Sounds like the best choice is using both! Sheets for the things excel can't do. Pull that in with PQ and enjoy the rest of the day!
That's a good plan 😁
Nice video! I hope the critics will be nice on you. :-)
I hope so too 😁
Thanks so much !
This was AMAZING!!
god bless you . thanks a lot
Is Xlookup similar to the Filter Function?
Hi Leila, I've learned a lot from you. Thank you for providing these videos. I have a question regarding Go to Special. If I want to select all blanks in a column but copy the values below each blank cell, what should I do? Thank you very much!
It helps to use a helper column. Check if the cell on the same row is empty and with an IF get the value of the next cell.
Hi! Can you plz make a video related to manage personal finance in excel?
Great videos. About feature number one, Google Sheets has DGET function, wich do the same and more than XLOOKUP, because is able to work with arrays.
I love the Wonder Woman cosplay ❤️❤️❤️
😊
XLOOKUP() is cool, but Google sheets lets you create on-the-fly arrays in curly brackets so you can use VLOOKUP() and order the columns any way you need within your array brackets.
En espera del video, gracias por compartir!! 👍
Yes, Excel is impressive in many ways. The features that were presented here are the ones that are really useful especially in data arrangements. The fact that Google Sheet is a web-based app makes it more of an app than a stand-alone software. While Excel can work with or without internet.
What a great video and I know your an excel master but do you see yourself converting or just using both of them equally?
Thanks!
Thank you!
would love to see a jupyter notebook vs excel breakdown
Wonderwoman always over Superwoman etc.
Hi, there. It was super. Many thanks.
Hopefully the costumes will see the light of day at least once a year for an update!
...aaand the number one - pressing Enter to Paste
Yes my Ctrl+g [Go to Special] figured in your list ...An awesome one in excel .... I am referring both your videos to my friends .... as usual you are too good in your lectures .... thanks
I always used F5 and Alt+S or click on Special.
Well explained love from India #5itfindit
Thank you!
Hello madam how to become excel hero and please tell me what is maine topic of excel which is useful getting job in market please rep me