The most amazing thing about you is that you take time to acknowledge each comment either by responding or liking. Humility and expert knowledge is a deadly combo,. Hats off.. 👏👏👏
Please use the timestamps below 👇 to see a specific tip (or watch them all): 0:00 - Introduction 0:55 - New FILTER function * 1:51 - CHAR(10) Trick 2:46 - CTRL SHIFT 4 - quick currency format 3:06 - Using SUBTOTAL function 3:34 - Slicers on Table 4:25 - Mini charts with REPT() trick 5:19 - Finding 2nd largest value 5:58 - CTRL SHIFT 3 - quick date format 6:17 - Quick number formats in pivots 6:46 - Easy interactive chart trick 7:20 - ☝ Slicer ✌ Charts 7:57 - Year to date totals in Pivots 8:45 - CTRL F1 - Collapse / expand ribbon 9:06 - Adding subtitle (caption) to charts 9:52 - NEW Treemap chart * 10:37 - Tiny charts, big impact 11:24 - Free ICONS to spice up your reports * 11:51 - Lookup from bottom * 12:45 - CTRL G - Go anywhere 13:28 - Quick Age grouping in pivots 14:18 - Rearrange pivot row labels in any order 14:46 - Make sense of large pivots easily 15:45 - Fix date formats with this trick 16:38 - Emojis in your formulas 😀😂🤩 17:30 - Get live stock (share) prices in Excel * 18:36 - Printing trick 🖨📰⚡ 19:24 - Databars, but not too long 20:24 - F7 - Sepllcehck 20:43 - Smart chart titles 21:19 - Hide away charts temporarily
Hello bhaiya kya aap mujhe bta sakte h ki apne Data Analysis kaise aur kaha se sikhi h . Mujhe Data Analysis sikhna h par sahi platform k bare m nhi pta h . Please btao do
I just came across your channel. I'm an average Excel user with a moderate amount of advanced skills. Yet, watching your videos, I realize how much I don't know. I am an avid user/seeker of tips and tricks and I LOVE your videos. Your explanations are crystal clear. I can't thank you enough for posting such excellent info!
Wow.. Always a pleasure to hear from long time followers like you. I am humbled to have you by my side all this while. Thanks for loving my work and being awesome :)
@@chandoo_ I started following you from this moment as i found you as my mentor. I want to be Business Intelligence person. Hope your videos will help me chase my dream career. I just started learning powerbi. ❤️
Hi Chandoo.. My question is about the 18th trick of this tutorial. What should i do if i want to all the results at a time. .. i mean to say all the three values of the example comes together in seperate cells..?? Hope you get my question..
@@saumyagajjar8047 You can use helper column by using countif function. Once you select the name by data validation it will show as below. Eg: Saumya|1 4500 Saumya|2 5000 Saumya|3 4800
@@samfredy5881 But adding helper columns and then apply row formula bla bla... It is quite clumsy. I have it my friend. But may be someone have some better way then i have.. thanks Sam.
Hello Chandoo. I have been using excel for 15 years. What a great surprise your channel, since I found it I am a fan!! I learned a lot of new things and you explain them in a very simple way. Greetings and respects from Argentina (South America).
Your first video that I came across in my youtube study items, " my boss used to do like this", called my attention to your simple and easy but effective way of teaching things you grasped well through your work. Congratulations!
Hi, you always post very informative videos. I have an Excel365 file which data from the odbc table which updates automatically in scheduled intervals, how can I sync that Excel data into Google Sheets with auto updates?
thank you very much for your tutorial videos. Can you please help me with this, i have office 365 in my organization for last few months, but i still dont see xlookup, filter, unique etc functions. how do i get them ? thanks
Hai sir.... I was recently watching your video about learning excel. Where I could see it many tips and advanced features which is useful..... If it comes to basic or for beginners could u suggest something that will be useful for us... thank you..
Thanks GD... I don't have any on the analysis pack yet. But I suggest watching my Data Analysis course video. It should give you a good head start - ua-cam.com/video/v2oNWja7M2E/v-deo.html
Thank you Chandoo. Liked the thumbs up trick. And as asked, here it is thumbs 👍 I was also keen to see some statistics and the application of Monte Carlo simulation...
when I first came across your tutorials years ago I found it difficult to understand due to the indian accent. Either I have adjusted, or with so many videos you have reduced your indian accent. Now you quote forrest gump and instantly become a Hero!!! Bravo :)
Welcome back Shaun. Just as my Excel skills changed over time, so did my English speaking. I now live in NZ, so naturally have high degree of all my interactions in English, which translates to my videos too.
I just started to watch your Excel learning videos. It is really amazing. It would be fine if I would have seen your Excel videos earlier. Anyway, I am satisfied by better late than never !!! Great
Hi Chandoo ! Love your style of instruction .. Do you also conduct online classes .. I would like to receive few VBA and excel training from you and i am at a beginner level
Thanks you. Yes, I do. Please see chandoo.org/wp/excel-school-program/ This week, I am running a holiday sale (happens once a year) too. You get 20% discount too.
Chandoo, you are AWESOME!!! I've watched this one particular video 7 seven times and still can't keep up with you....I, also still can't get the FILTER function to work! YES, I have Office 365.
Thanks Don.... You are awesome too!!! Sorry about the frustration with FILTER. May I know what you are doing? Do you see FILTER as one of the available functions? If not, you may have to go to File > Account and check if there any pending Office update. If you have FILTER() but the results are not what you are expecting, let me know how your data is shaped and what you are trying to do? I will try & help you. Also check my tutorial on FILTER & other new functions for some leg-up. Here - chandoo.org/wp/dynamic-array-functions/
Awesome Chandoo! Thanks for the quick spin through 30 tips and tricks. Always useful and informative information at your channel! Thanks for sharing :)) Thumbs up!!
Hi, I am learning MS Excel now, which exam i need to take firstly on excel to get certificate from microsoft since there are multiple excel courses with same code, could you please suggest me which exam(2013/2016/2019) I need to take firstly on excel since I am a beginner
The most amazing thing about you is that you take time to acknowledge each comment either by responding or liking. Humility and expert knowledge is a deadly combo,. Hats off.. 👏👏👏
Please use the timestamps below 👇 to see a specific tip (or watch them all):
0:00 - Introduction
0:55 - New FILTER function *
1:51 - CHAR(10) Trick
2:46 - CTRL SHIFT 4 - quick currency format
3:06 - Using SUBTOTAL function
3:34 - Slicers on Table
4:25 - Mini charts with REPT() trick
5:19 - Finding 2nd largest value
5:58 - CTRL SHIFT 3 - quick date format
6:17 - Quick number formats in pivots
6:46 - Easy interactive chart trick
7:20 - ☝ Slicer ✌ Charts
7:57 - Year to date totals in Pivots
8:45 - CTRL F1 - Collapse / expand ribbon
9:06 - Adding subtitle (caption) to charts
9:52 - NEW Treemap chart *
10:37 - Tiny charts, big impact
11:24 - Free ICONS to spice up your reports *
11:51 - Lookup from bottom *
12:45 - CTRL G - Go anywhere
13:28 - Quick Age grouping in pivots
14:18 - Rearrange pivot row labels in any order
14:46 - Make sense of large pivots easily
15:45 - Fix date formats with this trick
16:38 - Emojis in your formulas 😀😂🤩
17:30 - Get live stock (share) prices in Excel *
18:36 - Printing trick 🖨📰⚡
19:24 - Databars, but not too long
20:24 - F7 - Sepllcehck
20:43 - Smart chart titles
21:19 - Hide away charts temporarily
Please share the practice file.
Thanks for sure.
I loved the subtotal function, thanks for sharing superb tips
It is a treasure. It is simple and keeping the pace. It has 30 gems, which are completed within 22 minutes. I am obliged. God bless you.
Thanks Sanjay... :)
You are the life saver of my Data Analyst interview, thank you so much for the nice and easy explanation.
Hello bhaiya kya aap mujhe bta sakte h ki apne Data Analysis kaise aur kaha se sikhi h . Mujhe Data Analysis sikhna h par sahi platform k bare m nhi pta h . Please btao do
I just came across your channel. I'm an average Excel user with a moderate amount of advanced skills. Yet, watching your videos, I realize how much I don't know. I am an avid user/seeker of tips and tricks and I LOVE your videos. Your explanations are crystal clear. I can't thank you enough for posting such excellent info!
Thanks Paddy. More Power to you brother... 😀
I have been following you for about 15 years and always still learn so much from you , thank you for what you do for the community :)
Wow.. Always a pleasure to hear from long time followers like you. I am humbled to have you by my side all this while. Thanks for loving my work and being awesome :)
@@chandoo_ I started following you from this moment as i found you as my mentor. I want to be Business Intelligence person. Hope your videos will help me chase my dream career. I just started learning powerbi. ❤️
I have learnt a very impressive excel tricks I have never idea with. Thank you very much
Impressed my boss today after watching your Index/Match video!!! Thank you soo much Chandoo 🙏
Hi Chandoo..
My question is about the 18th trick of this tutorial. What should i do if i want to all the results at a time. .. i mean to say all the three values of the example comes together in seperate cells..?? Hope you get my question..
@@saumyagajjar8047 You can use helper column by using countif function. Once you select the name by data validation it will show as below.
Eg:
Saumya|1 4500
Saumya|2 5000
Saumya|3 4800
@@samfredy5881 But adding helper columns and then apply row formula bla bla... It is quite clumsy. I have it my friend.
But may be someone have some better way then i have.. thanks Sam.
You can also use the new FILTER function to do it.
I'm fairly advanced but you always have some nice tips I didn't know. Excellent channel Chandoo!
What I liked the most is that you really shown amazing stuff, instead of saying general stuff as amazing, apart from it, I liked last tip the most
Hello Chandoo. I have been using excel for 15 years. What a great surprise your channel, since I found it I am a fan!! I learned a lot of new things and you explain them in a very simple way. Greetings and respects from Argentina (South America).
Thank you Cesar... I am so glad I could teach & inspire long-time users like you. More power to you.
You are AMAZING and I love your videos - I learn so much from you. THANK YOU
I love it, I love it, I love it..........................Completely in love with your content. Thank You!
You are so welcome!
That was very powerful....I'm always learning new tricks from you
Fantastic!
I always learn something new and unexpected…keep them coming!
Thanks Robert... :)
Nice of you to share your knowledge !
I am habituated to liking your videos right at the start of it, because I know one like is not even close to how amazing content you present.
Informative and great teaching and confidence style.
Glad you liked it!
Great....expecting more & more advanced tips....will be really helpful
Sure 😊
Your first video that I came across in my youtube study items, " my boss used to do like this", called my attention to your simple and easy but effective way of teaching things you grasped well through your work. Congratulations!
Awesome video.Thanks for sharing all these useful tips!
The data slicer is something new to me and it is wonderful.
Some of the tricks were really awesome. Thank you for sharing with us.
Glad you like them!
Ohh my god, I had never seen such a smart guy in excel. Thank you brother.
Thank you sir for such a wonderful and knowledgeable session on advance Excel. Got to know new tricks.❤
Fantastic tips sir! You are absolutely the BEST! Thank you for sharing.
The best thing I liked about your video is, you are straight to the point, no bakwaas.............
Loved these tricks.
before watching your video i hit the like button, you are the best ! I truly follow you.
😍
Hi, you always post very informative videos. I have an Excel365 file which data from the odbc table which updates automatically in scheduled intervals, how can I sync that Excel data into Google Sheets with auto updates?
Thanks a lot, especially for the printing trick n°26 !
You are welcome...
Wow! Learning these tricks will surely make you productive and AWESOME in your job. Thanks Chandoo. ❤
Thank you Vinod....
Thank you Chandoo sir , your videos are really helping me a lot 👍
Thank you for d well explanatory of excel tricks and tips. Areas of interest capture, Many thanks
Very Helpful and awesome tricks,
It is a very useful videos which is useful to use all the trips in my profession while doing my financial report thanks a lot
so many good tips, thanks Chandoo!
My pleasure!
very helpful tips, Chandoo
Fabulous as ever. Several of those are going to be applied to some data sheets on Monday at work. Thanks
Wonderful!
thank you very much for your tutorial videos. Can you please help me with this, i have office 365 in my organization for last few months, but i still dont see xlookup, filter, unique etc functions. how do i get them ? thanks
Excellent! Thanks Chadoo!!
Glad you liked it!
Amazing...I have surely learnt some tips I didn't know. Thank You
Man, day by day you are amusing me. Thumps up
Thanks Bala...
I like the way u explain everything in smoother way
Thanks Nagaraj...
Great tips, many thanks for sharing, Chandoo. 😎
You are welcome Kim...
Mr. Chandoo
Your works are really really awesome
Thank you... 😍
I love the way you explain. Thanks for that. And also can you explain about PowerBI
Love from Pakistan, Thanks for this valuable knowledge.❣
Very useful tips and tricks. Learned something new today. Thanks Chandoo
You are welcome Rama...
Chandoo Man you are an XL GOD !, all the best and we need more !
Thanks 😊 it's really Awesome.
Excel = Chandoo = Awesome
Maasha Allaah, Super Informative. Brother
😀 Thank you.
Thank you. wonderful & very useful videos. Pls keep doing such videos
Hi Mr. chandoo i really like the way of your teaching. Thank you so much for spreading knowledge.
You are very fun to watch. Keep it up!
Cool tricks chandoo as you are
Thanks for sharing !!!
This is pure gold!
You know our rules. If I find gold, I must share it. 😀
Nice tips. First time on this channel and gladly subscribing
Good training video, cleanly presented with excellent pace.
Selection of charts the last trick was cool.
Thanks Ramesh...
Really amazing tricks . Thanks a lot..
Thanks Shoba. :)
I enjoyed watching your videos, sir. Thank you!
Thanks for watching!
WOW the stock API is just legendary THANK YOU CHANDOO! :D
Glad you like it!
Thanks Chandoo for this amazing tips.
Hai sir.... I was recently watching your video about learning excel. Where I could see it many tips and advanced features which is useful..... If it comes to basic or for beginners could u suggest something that will be useful for us... thank you..
Thank you sir for this effort for us
Awesome video, thank you so much👏
Really enjoy this tricks, Do you have any tutorial anout analysis package.
Thanks GD... I don't have any on the analysis pack yet. But I suggest watching my Data Analysis course video. It should give you a good head start - ua-cam.com/video/v2oNWja7M2E/v-deo.html
Amazing tricks, easy to follow! I enjoyed watching the video
great video! thanks a lot!
Very useful one Sirji … As usual thanks a lot 🙏
Great video. Thanks :)
Wowwwwwwwwwwwwww Next Level Of teaching.................
Thank you for the knowledge.
Awesome tips Chadoo! Love the way you explain and present real life examples to help understand! 😊👍
Glad it was helpful!
Dear Chandoo excellent video
Thanks Moni...
Thank you Chandoo.
Liked the thumbs up trick.
And as asked, here it is thumbs 👍
I was also keen to see some statistics and the application of Monte Carlo simulation...
This is a gold mine.👌😀
😍😊
Chando! wonderful!!!! show some basic DAX and PowerBi sometimes
Amazing.. as usual, thanks a lot. I have gained immensely. Notable is the nice audio quality, please keep it up.
when I first came across your tutorials years ago I found it difficult to understand due to the indian accent. Either I have adjusted, or with so many videos you have reduced your indian accent. Now you quote forrest gump and instantly become a Hero!!! Bravo :)
Welcome back Shaun. Just as my Excel skills changed over time, so did my English speaking. I now live in NZ, so naturally have high degree of all my interactions in English, which translates to my videos too.
I enjoy your videos! Thanks for making them!
I learned more about Excel in 20 minutes than I learned in 20 years. Thank you.
Then i guess you should do something else rather than work on excel
I just started to watch your Excel learning videos. It is really amazing. It would be fine if I would have seen your Excel videos earlier. Anyway, I am satisfied by better late than never !!! Great
Nice Chandoo!!
Can you share the excel file which used in above video.
Thanks
Thanks Muhammad. There is no sample file for this video. Just take a note of the tips and practice them on any file you have.
Nice and useful thank you
Hi Chandoo ! Love your style of instruction .. Do you also conduct online classes .. I would like to receive few VBA and excel training from you and i am at a beginner level
Thanks you. Yes, I do. Please see chandoo.org/wp/excel-school-program/
This week, I am running a holiday sale (happens once a year) too. You get 20% discount too.
its currently december 2021. i am make use of ur videos to become an analyst. thanks for the support i will keep u updated on my growth ))
Awesome news CY. I am eager to hear about your progress. Keep us posted.
More POWER ⚡ to you.
I enjoyed all tips....
@Chandoo Is there an Excel practice sheet for this video?
Thanks a lot Sir for sharing such type of information. Great work.
Great! your voice remembered me of my spiritual giant "Sri Satya Sai Baba".
In a way he has a resemblance too
He is Sai baba of excel tool
Right👍
Shridi Sai Baba is the only true Sai Baba.
Chandoo, you are AWESOME!!! I've watched this one particular video 7 seven times and still can't keep up with you....I, also still can't get the FILTER function to work! YES, I have Office 365.
Thanks Don.... You are awesome too!!!
Sorry about the frustration with FILTER. May I know what you are doing? Do you see FILTER as one of the available functions? If not, you may have to go to File > Account and check if there any pending Office update.
If you have FILTER() but the results are not what you are expecting, let me know how your data is shaped and what you are trying to do? I will try & help you.
Also check my tutorial on FILTER & other new functions for some leg-up. Here - chandoo.org/wp/dynamic-array-functions/
Thank you so much Sir.. 🙏
Awesome Chandoo! Thanks for the quick spin through 30 tips and tricks. Always useful and informative information at your channel! Thanks for sharing :)) Thumbs up!!
My pleasure Wayne. I wanted to create something epic to celebrate the 100k milestone. Hence this 😀
@@chandoo_ Excellent! Congrats on the subscriber milestone :))
Hi, I am learning MS Excel now, which exam i need to take firstly on excel to get certificate from microsoft since there are multiple excel courses with same code, could you please suggest me which exam(2013/2016/2019) I need to take firstly on excel since I am a beginner
I had recently started viewing your videos, which helping a lot and amazed me by the way of your explanation. Thank you for your informative videos🙂
You're very welcome!
Dear Chandoo Awesome Video...Kindly Share the Awesome data set....
chandu garu, superb andi, loved it, thank you so much, so many useful tricks ,thank you very much andi!!
Thanks for the lovely comment Salauddin... :)
chandoo bhai dil jit liya apne!!