8 Things Excel Should Copy from Google Sheets

I am a heavy user of both Excel and Google Sheets, and I love both (with a bias towards Excel).
Excel has tons of amazing features, and it would be amazing if they also get some additional useful features that Google Sheets has.
In today's video, I cover eight things I wish Excel copies from Google Sheets.
00:00 Intro
00:47 Freeze Panes
02:41 Trim Whitespaces
03:50 Randomize Range
04:34 Custom Date Formatting Interface
06:30 Color in Drop-Down Lists
08:40 Highlight Alternate Rows
09:40 Sparkline Formula
11:50 Clear Format Shortcut
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzbin.info...
#Excel #ExcelTips #ExcelTutorial

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos. Also, I have made all of my Excel courses available for free. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

[@andrewcharlesmoss]

I didn't realise that freezing panes in Sheets is as easy as that. Definitely needs to come to Excel!

[@trumpexcel]

Hoping the same

[@PaulasPicks]

I always prefer using Excel, but I also didn't know how to easily do some of these things using your tips, Sumit! Well done! Now I agree with you that I want Excel to be able to do all of these. 😂

[@trumpexcel]

I also prefer Excel most of the times, but the collaboration features in Google Sheets are just amazing. I am hopeful Excel will get some (if not all) of these features. The way Excel is releasing new features is insane

[@azeezwahab5188]

Another good one from TrumpExcel.

[@jhankhanajani9314]

Thank you Sumit, Very Sharp Observations between Excel and Google Sheets. Hope Excel will adapt the features soon and this enahncements will create an enriched experience for Excel users.

[@trumpexcel]

Thanks for commenting Jhankhana... I hope the same 🙂

[@2ru2pacFan]

Don't forget arrayformula function, one of the biggest reasons why I changed from excel to Google sheets. Also when you have a filter on and then tried copying the column, it doesn't let you because there are hidden rows in Excel where in Google sheets they let you.

[@trumpexcel]

True, copying and pasting data when there are filtered rows is irritating in Excel. I didn't know Google Sheets doesn't have this issue 👍

[@2ru2pacFan]

@@trumpexcel yeah it was nightmare every time so I always uploaded the same document onto Google sheets, made the amendments then continued with the work but luckily I don't need to work with Excel anymore lol. Also thank you for the alternative formatting and the trimmed whitespace, I didn't know you could do that without the trim function 😆

[@pancux670]

Very useful as always. Array Formula, Importrange and Query are some other functions which Excel should have.

[@npc2856]

You always teach me something useful. Thanks!

[@trumpexcel]

Thank you for the kind words... I am glad the video was useful 🙂

[@kraftedhomes8846]

YAAASSS! I don't use Google Sheets, but I know Excel would be better with these functions! Thank you for everything you do!

[@trumpexcel]

Agreed, some of these features would make Excel even better

[@Satwant2463]

Thank you.

[@jonminer9891]

Thanks!

[@bbcang9865]

Love all the ideas!! always learn something new watching your videos, thank you..

[@trumpexcel]

This is a bit different than the usual Excel tips videos I do, so I wasn't sure if it would be well received or not. Glad to see that it's useful 🙂

[@shiffamohammed5818]

Great idea, great video Sumit. Making the enhancements you just said will make Excel more user friendly and that means more excel users. I believe your idea will have multiple benefits. Many thanks Sumit.

[@trumpexcel]

Thanks Shiffa... With the speed Excel is releasing new features, I am hopeful some of these will be in Excel soon 🙂

[@dakshbhatnagar]

Google Sheets Uses Google Appscript and in there they have written a class that allows users to send mail. If someone is working as an analyst they wil be required to send reports, adding the functionality of sending mail from within Excel would serve great

[@trumpexcel]

Office scripts have come to Excel (in a new Automate tab), but I am not sure about the class you're referring to. The idea seems to be to move away from VBA to office scripts.

[@clevercitychick]

I like the Date selection (through Data Validation) that pulls up a calendar on Google Sheets

[@trumpexcel]

Excel Online (on the web) already has this feature. I am hopeful it will come to Excel Desktop as well

[@vikaasb2016]

Good one ❤!

[@alexg.889]

Thanks

[@leebecker8255]

Great video! I've been thinking about the Freeze panes one for a long time. It's so nice in Google Sheets. Also, the Query function which a few people have mentioned. So powerful to be able to write SQL in a formula.

[@trumpexcel]

Thanks for commenting Lee... I hope Excel gets a similar drag and drop Freeze pane. I haven't used the Query function much, but multiple comments have mentioned it, so will check it out 🙂

[@leebecker8255]

@@trumpexcel Actually neither have I! I just saw it is possible, and it's been on my to do list for a while :D I know exactly where I want to do it too. I use Google Sheets to manage looking after second hand uniforms at my kids' school. At the moment I manually remove the 'sold' items, but it would be much better if I write a query to do it for me :)

[@botchedup7828]

Excel actually had something like the drag function to split the view which you could then fixate but they removed it for some reason

[@trumpexcel]

Split the view feature is still in Excel (if that is what you're talking about), but that's a bit different as it splits the worksheet into two sections, both of which you can scroll separately

[@salmaalaa6158]

🏉very uniqe video thank you

[@trumpexcel]

Glad you liked the video 🙂

[@toptechkit]

Query function in Google Sheets. I like it

[@kaesuma]

I like how Smart Fill automatically converts into a formula. That's yet to happen with Flash Fill.

[@trumpexcel]

I think that's in the testing phase and will soon be in Excel too

[@gandhisunil3]

Hello Sumit Any guess by when excel will. Have check list box in insert menu, till now it is limited to beta version only, we have been listening it will come to all..but by when it is uncertain

[@trumpexcel]

I am not sure when they will roll it out to everyone. My guess would be not more than a few months. It's been tested well enough to be rolled out I believe. Hopefully soon