No video :(

8 Things Excel Should Copy from Google Sheets

Подписаться 375 тыс.

Просмотров 4,7 тыс.

50% 1

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: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial

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

7 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 40

@trumpexcel 5 месяцев назад

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 5 месяцев назад

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

@trumpexcel 5 месяцев назад

Hoping the same

@PaulasPicks 5 месяцев назад

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 5 месяцев назад

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

@jhankhanajani9314 5 месяцев назад

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 5 месяцев назад

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

@azeezwahab5188 5 месяцев назад

Another good one from TrumpExcel.

@npc2856 5 месяцев назад

You always teach me something useful. Thanks!

@trumpexcel 5 месяцев назад

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

@pancux670 5 месяцев назад

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

@kraftedhomes8846 5 месяцев назад

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

@trumpexcel 5 месяцев назад

Agreed, some of these features would make Excel even better

@2ru2pacFan 5 месяцев назад

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 5 месяцев назад

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 5 месяцев назад

@@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 😆

@shiffamohammed5818 5 месяцев назад

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 5 месяцев назад

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

@dakshbhatnagar 5 месяцев назад

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 5 месяцев назад

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.

@Satwant2463 5 месяцев назад

Thank you.

@bbcang9865 5 месяцев назад

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

@trumpexcel 5 месяцев назад

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 🙂

@clevercitychick 2 месяца назад

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

@trumpexcel 2 месяца назад

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

@jonminer9891 5 месяцев назад

Thanks!

@alexg.889 5 месяцев назад

Thanks

@leebecker8255 5 месяцев назад

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 5 месяцев назад

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 5 месяцев назад

@@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 :)

@botchedup 5 месяцев назад

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 4 месяца назад

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

@vikaasb2016 5 месяцев назад

Good one ❤!

@salmaalaa6158 5 месяцев назад

🏉very uniqe video thank you

@trumpexcel 5 месяцев назад

Glad you liked the video 🙂

@toptechkit 5 месяцев назад

Query function in Google Sheets. I like it

@gandhisunil3 5 месяцев назад

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 5 месяцев назад

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