Great tips Chandoo... I've one to share. At 10:16 we can tick "Match entire cell contents" option in the search box to limit our search to 600 or whatever value we want 😉
Thank you, Chandoo! I learnt a lot from your video today, as usual, and each time I watch one of your videos, I am reminded about how little I know about these Excel tricks. Looking forward to more of these.👏
Mind blown ! Thank you for all those tips ! You made this video so fun that my colleagues sitting next beside me in the bus is starting to think I’m bizarre smiling over an excel sheet
At your 6:40 you do a sub-sort. I discovered the other day if you do it from the right to the left, you can just click in your Sales column and click AtoZ and then click in the Sales Person column and click AtoZ. For some or other reason if you do it from the left, the one sort just replaces the previous, but in reverse, no need for the Sort Button and adding levels!!
Well, sorting with multiple levels can always be done manually by sorting column by column in reverse order from the last to the first criterion, as the sorting in Excel always retains the current order of the other columns. So for example if you have columns Name County Age, if you want a sorted list of all counties and all persons of a county sorted by age (and then persons of same age should be in alphabetical order), sorting level 1 is County, sorting level 2 is Age, sorting level 3 is Name. Manually you can do that by 1st sorting column Name, then sort column Age, the sort column County (i.e. in reverse order of sorting level). Advantage of using the sort button and multiple levels is, that (e.g. after adding more data records) you can repeat this multi-level-sort with a single click on the (Filter) Reapply button: it also does repeat the sorting!
OMG! Tip 31 getting data from pictures is going to be such a time saver for me. I get so many e-mails with screenshots of data I have to put into Excel to work with. I didn't know this trick. Thanks for saving a bit of my sanity.
Love the video Chandoo! Particularly like the part about the Invert if Negative function, it's a great tool for improving the optics of you Excel Bar Chart!
Chandoo - I've always landed on your solutions for complex Excel tricks... you are one of the best! I should of hit that Subscribed a long time ago! -Done!
Hi chandoo I am a chartered accountant by profession. I love your videos and had learnt so much from your channel. But nowadays thanks to AI i had lost all the interest on learning new skills and has fall into a pit hole where everyday all I think of is I will lose my job soon. With so many course's out there and so much of misinformation, it would be great if you can come out with a course for people like us.
Thanks Vidhi for your comments. I know this can be concerning but AI still has a long way to go. So, focus on things you can control and enjoy most. I do have a few videos on how to harness AI to do your work well. As the technology evolves I will add more information and resources on this. Stay calm my friend.
Excellent video. I've learned so much from it. I didn't know about the formulatext function. I always have trouble when I try to copy a formula and make it a text format. The formulatext function works great. Thanks.✅
The Alt key shortcut is something that I'm always confused as to why nobody does this in their Excel videos. After you use it a few times it becomes really easy to use and get things done quickly.
hey Chandoo Thanks For this awesome video, I have one question in the paste function (Clipboard tool, 3:15 min ) I am facing a problem here I have a lot of columns that I need to copy as you copied particular chocolate here the same way, but the problem is that the clipboard only takes 24 values and my column name count is 49 so how can I do that
NICE...1:50..ANY OPTION TO SHOW CURRECTLY AVAILABLE CUSTOMS LISTS INSTEAD OF EVEN TYPING FIRST FEW ITEMS,SO THAT ONE MAY READILY CHOOSE AMONGST THE LISTS OPTIONS...??
hey Chandoo Thanks For this awesome video, I have one question in the paste function (Clipboard tool, 3:15 min ) I am facing a problem here I have a lot of columns that I need to copy as you copied particular chocolate here the same way, but the problem is that the clipboard only takes 24 values and my column name count is 49 so how can I do that hey candoo can you plz explain how we can increase clipboard copy count , it only copied 24 value ???
To watch your videos on excel have been a wonderful experience always. The way you explain the ideas is awesome. I never feel that I am learning instead it is always an entertainment without losing the aspect of learning. Great work indeed.
thank you Sir , your easy and clear style makes it a pleasure to learn . I have a problem , I have Office 2021 , but could not locate Navigation pane in it , yes its not there in either the View tab or in any tab .. if its hidden somewhere ..can you help locate it ... again I have office 2021
Hi Chandoo. First question after binge watching your videos over the weekend. Please take a look. I have developed a stock value calculator that has 6000 stocks. I have 6 methods and created a dashboard for summary. But I want to get the results for 40 stocks (can get ticker in text file) and it should be printed to another excel tab or PDF. I can just print one row or two rows of summary for each ticket (no need of fancy dashboard). Meaning -I need to run the excel dashboard (or file) repeatedly 40 times (40 stock tickers with 2 inputs -ticker and market price) and get the valuation summary. What is the trick to do ? Kindly suggest a method. I think I can do this in Python by accessing Excel repeatedly. But do not want to go there yet. How do do in excel is the question.
Thanks for the love. You can use VBA for this sort of thing. Just maintain the 40 ticker codes in a list and set one at a time to the input cell using VBA loop. Then copy the portion you want to another file. When done, save the new file as PDF.
Great tips Chandoo... I've one to share. At 10:16 we can tick "Match entire cell contents" option in the search box to limit our search to 600 or whatever value we want 😉
That is a great suggestion. It occurred to me only after I finished the recording. 😀
Good call👍
@@chandoo_what was the difference between count and distinct count? Thank you :)
@@periwinkletinkle7371Count will count every instance added together. Distinct Count only counts things 1 time.
😅😂😂😅😅
¡Gracias!
Thank you @Joanmty for the love and super.
Wow, that was powerful! I thought I was a geek in Excel, but I am humbled with this tutorial. That was eye opening!
Thank you, Chandoo! I learnt a lot from your video today, as usual, and each time I watch one of your videos, I am reminded about how little I know about these Excel tricks. Looking forward to more of these.👏
Thanks Chandoo. I work on a lot of data and charts for reporting and I particularly liked that we can insert images and emojis in charts. Thank you.
Learned a lot, thank you!
Chandoo is very smart!
Great video Chandoo!
The Only RUclipsr who gives real value inputs to us.
Eres genial, saludos desde Venezuela
Chandoo is still the best!
Very useful Chandoo, this was great!
Thanks for making this video GOAT 😎😎😎
Chandoo is the best in the business ❤❤❤
You are Very Smart, Chandoo Jee We want like u...
Thank you @chandoo your tricks are super helpful❤
Thanks a lot Chandoo! So many years of your help has made me good with Excel.
You are most welcome
Thank you 🙏 sir .... sincerely appreciated 🙏.God bless you 😊
🤓Thanks Chandoo
Thank you for amazing tips
Good examples and excel tricks 😊
GPS! Very funny. Great video as usual. Thank you. Loved the photo of you and Leila together at some conference.
Glad you enjoyed it
Loved the "Like" and "Subscribe" pitch 🙂
Thanks Chandoo. I really love this especially the custom sort function
Great! Thank you so much! You are Blessed to Bless Others to "Become Awesome!"🤗🙏
Mind blown ! Thank you for all those tips ! You made this video so fun that my colleagues sitting next beside me in the bus is starting to think I’m bizarre smiling over an excel sheet
These are all great tips.
I need this is written format for reference.
Thank you for sharing this video
Thank you so much , your videos are really helpful always !!
At your 6:40 you do a sub-sort. I discovered the other day if you do it from the right to the left, you can just click in your Sales column and click AtoZ and then click in the Sales Person column and click AtoZ. For some or other reason if you do it from the left, the one sort just replaces the previous, but in reverse, no need for the Sort Button and adding levels!!
Well, sorting with multiple levels can always be done manually by sorting column by column in reverse order from the last to the first criterion, as the sorting in Excel always retains the current order of the other columns.
So for example if you have columns Name County Age, if you want a sorted list of all counties and all persons of a county sorted by age (and then persons of same age should be in alphabetical order), sorting level 1 is County, sorting level 2 is Age, sorting level 3 is Name. Manually you can do that by 1st sorting column Name, then sort column Age, the sort column County (i.e. in reverse order of sorting level).
Advantage of using the sort button and multiple levels is, that (e.g. after adding more data records) you can repeat this multi-level-sort with a single click on the (Filter) Reapply button: it also does repeat the sorting!
Amazing,mind blowing, excellent, awesome. Thanks Sir
Amazing and Helpful ❤
Those were useful tricks, i appreciate.
Gr8 change in your presentation Sir. I liked it so much as it's engaging till the end of Video !! Thanks🤝
superb one, thanks for sharing
OMG! Tip 31 getting data from pictures is going to be such a time saver for me. I get so many e-mails with screenshots of data I have to put into Excel to work with. I didn't know this trick. Thanks for saving a bit of my sanity.
You have really added value to my life with theses great knowledge acquired from from various teachings. God bless you.
Many thanks for these tricks
Love the video Chandoo! Particularly like the part about the Invert if Negative function, it's a great tool for improving the optics of you Excel Bar Chart!
Simple superb your video's more helpful and easy to understand, thanks
Thank you chandoo sir. Well spent half an hour.😀
Thanks 👍👍👍👍
OMG #45 is awesome! 🎉
I'm subscriber, thanks for your lecture, it helps me to update my skills in excel with the updated new commands
Chandoo - I've always landed on your solutions for complex Excel tricks... you are one of the best! I should of hit that Subscribed a long time ago! -Done!
Very Nice video, and very useful 🥰
Amazing!!! Thank you so much!!! You definitely made our lives easier!!! #excellovers
Great video, man!
I found this to be very helpful!
Thank you, my teacher. I have learnt a lots under your tutelage
Awsomw Chandoo ji.
thanks 🎉
Sir thanks for this video I have learnd so many things thankyou 🎉
This is really amazing
NOOOOOOOOOOICE , Love it !
You always Amazing ❤
Oh WOW, #41 is sensational too! 🤩
Thanks i learnt a lot of from this video.
Your videos are always awesome
We have a winner! #22 🏆 👏 🥂 🍾
Chandoo, I enjoy your videos and I have subscribed too! Also, sending this video to my brother who might find loads of these things useful too.
Thank you sir, you're explanation was good, please upload more and more videos of trending courses.
This dude is the god,u earned a sub!
thank you chandu anna
Happy Independence day. Its very useful one.
And finally i recognize that your a really Chandoo
Thanks
u r amzing like videos inside making learning a real joy
thanks a lot for sharing your brilliance with all of us chandoo ji
your trick worked and now i m your subscriber 😅
Subscribed....!!
😀
I thought I knew excel very well....!!!
Worth subscribing
Welcome aboard. :)
Very useful video thanks sir
Sir make a video on how to pick a chart according to data.
Excellent and a very useful tutorial 👌
About 39 (sort multiple key) I suggest a faster way: sort on reverse order. E.g. to order by Person and Sales, just order by Sales THEN by Person.
The Median function in Pivot table is very helpful, of course along with other tips; thank you!
These excel. Videos show why excel is incomparable. Word and ppt have decent alternatives but excel is miles ahead.
Just subscribed to your channel.
It was a very interesting one, I loved it🎉
Hi Sir your 50 Excel Tips is Amazing... But I have Subscribed your Channel and comes under the 24% subscriber list..😀😀
this is really great/ On a lighter note, remembering all the 50 and recollecting the right one at the right time is a challenge 🙂
Thank you. Of course, that is why you can rewatch the video sometime later to cement the ideas.
I love when we go back to basics, it's the stuff which is v important and often forgotten
😍 Thank you.
Hi chandoo
I am a chartered accountant by profession. I love your videos and had learnt so much from your channel. But nowadays thanks to AI i had lost all the interest on learning new skills and has fall into a pit hole where everyday all I think of is I will lose my job soon. With so many course's out there and so much of misinformation, it would be great if you can come out with a course for people like us.
Thanks Vidhi for your comments. I know this can be concerning but AI still has a long way to go. So, focus on things you can control and enjoy most. I do have a few videos on how to harness AI to do your work well. As the technology evolves I will add more information and resources on this. Stay calm my friend.
Awesome Mr Chandoo! But can you attached this data set for easy practice pls? It's beautiful presentation.
2:14 use custom list
Excellent video. I've learned so much from it. I didn't know about the formulatext function. I always have trouble when I try to copy a formula and make it a text format. The formulatext function works great. Thanks.✅
Glad it was helpful!
The Alt key shortcut is something that I'm always confused as to why nobody does this in their Excel videos. After you use it a few times it becomes really easy to use and get things done quickly.
Alt a + v + v use this for data validation
hey Chandoo Thanks For this awesome video,
I have one question in the paste function (Clipboard tool, 3:15 min )
I am facing a problem here I have a lot of columns that I need to copy as you copied particular chocolate here the same way, but the problem is that the clipboard only takes 24 values and my column name count is 49 so how can I do that
NICE...1:50..ANY OPTION TO SHOW CURRECTLY AVAILABLE CUSTOMS LISTS INSTEAD OF EVEN TYPING FIRST FEW ITEMS,SO THAT ONE MAY READILY CHOOSE AMONGST THE LISTS OPTIONS...??
Nice
hey Chandoo Thanks For this awesome video,
I have one question in the paste function (Clipboard tool, 3:15 min )
I am facing a problem here I have a lot of columns that I need to copy as you copied particular chocolate here the same way, but the problem is that the clipboard only takes 24 values and my column name count is 49 so how can I do that
hey candoo can you plz explain how we can increase clipboard copy count , it only copied 24 value ???
Chandoo Happy Independence day🇮🇳🇮🇳🇮🇳🇮🇳
subscribed post paste from picture tip 😊
To watch your videos on excel have been a wonderful experience always. The way you explain the ideas is awesome. I never feel that I am learning instead it is always an entertainment without losing the aspect of learning. Great work indeed.
For 18th trick we can type the name in top cell or copy the name in top cell. It help to create list in multiple row scenario.
Subscribed at 12:19 ! 🤣
thank you Sir , your easy and clear style makes it a pleasure to learn . I have a problem , I have Office 2021 , but could not locate Navigation pane in it , yes its not there in either the View tab or in any tab .. if its hidden somewhere ..can you help locate it ... again I have office 2021
Hi Chandoo. First question after binge watching your videos over the weekend. Please take a look. I have developed a stock value calculator that has 6000 stocks. I have 6 methods and created a dashboard for summary. But I want to get the results for 40 stocks (can get ticker in text file) and it should be printed to another excel tab or PDF. I can just print one row or two rows of summary for each ticket (no need of fancy dashboard). Meaning -I need to run the excel dashboard (or file) repeatedly 40 times (40 stock tickers with 2 inputs -ticker and market price) and get the valuation summary. What is the trick to do ? Kindly suggest a method. I think I can do this in Python by accessing Excel repeatedly. But do not want to go there yet. How do do in excel is the question.
Thanks for the love. You can use VBA for this sort of thing. Just maintain the 40 ticker codes in a list and set one at a time to the input cell using VBA loop. Then copy the portion you want to another file. When done, save the new file as PDF.
How to do add calculate pivot table using formula sumproduct?
Sir, 14:55 image in cell feature is not available in Excel 365 yet.
This is in the "Beta" version as of now and will be available in public versions very soon.
Intelligent chando