@WarhavenSC
Google Sheets has the advantage of working on leap year, since Office is only 365 days of the year.
@mqhuynh2006
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.
@LeilaGharani
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.)
@CarlLindeberg
In data validation (1:50) you can actually leave the column reference open (B3:B) to prepare for extra rows.
@doktorexcel8603
Every time I watch a new video of you, I realize how much I still have to learn.
@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.
@rakimhaqverdiyev
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.
@kerronduncan6697
Thank you for this comparison Leila! My favorites: Flexibility of the drop down list Automatic refresh with the pivot tables Translate function Impressive!
@DarshanShah10
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!
@drewg2403
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.
@Suresh_Jayaraman
Wow. I just realized, I have underestimated sheets till now!
@ValorHeroics
Its been a while since I have learned something new about google sheets, and you have opened my eyes to a few more tools that I can utilize! Thanks!
@aperkinsvt
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!
@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.
@johnphilippatos
Ok, now I'm waiting for the video named "Excel BEATS Google Sheets with these 10 features!" Great Job Leila. As always.
@w6263
learnt something new today ''split'' function. Will come in handy. I appreciate all the videos you do.
@johnfromireland7551
I like the ability to use images as values. Cool. The chatting feature when sharing workbooks is already possible in Microsoft Teams.
@Rice0987
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!🤗😘
@danielk.2663
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.
@LeilaGharani