Top 30 *Advanced* Excel Tips to make you awesome ⚡💡

Поділитися
Вставка
  • Опубліковано 6 лис 2024

КОМЕНТАРІ • 397

  • @pritikane4448
    @pritikane4448 3 роки тому +70

    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.. 👏👏👏

  • @chandoo_
    @chandoo_  3 роки тому +40

    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

  • @SanjayGore
    @SanjayGore 3 роки тому +4

    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.

    • @chandoo_
      @chandoo_  3 роки тому

      Thanks Sanjay... :)

  • @sominramchiary5880
    @sominramchiary5880 Місяць тому +1

    You are the life saver of my Data Analyst interview, thank you so much for the nice and easy explanation.

    • @Poonamsahani817
      @Poonamsahani817 Місяць тому

      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

  • @PSMMOORE
    @PSMMOORE 2 роки тому +4

    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!

    • @chandoo_
      @chandoo_  2 роки тому

      Thanks Paddy. More Power to you brother... 😀

  • @kita3752
    @kita3752 3 роки тому +13

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

    • @chandoo_
      @chandoo_  3 роки тому

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

    • @iamamaan07
      @iamamaan07 3 роки тому +1

      @@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. ❤️

  • @frankmgecha6491
    @frankmgecha6491 2 роки тому +1

    I have learnt a very impressive excel tricks I have never idea with. Thank you very much

  • @garylowe598
    @garylowe598 3 роки тому +14

    Impressed my boss today after watching your Index/Match video!!! Thank you soo much Chandoo 🙏

    • @saumyagajjar8047
      @saumyagajjar8047 3 роки тому

      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..

    • @samfredy5881
      @samfredy5881 3 роки тому

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

    • @saumyagajjar8047
      @saumyagajjar8047 3 роки тому

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

    • @chandoo_
      @chandoo_  3 роки тому

      You can also use the new FILTER function to do it.

  • @bolleauk
    @bolleauk 3 місяці тому +1

    I'm fairly advanced but you always have some nice tips I didn't know. Excellent channel Chandoo!

  • @tarun_mangal
    @tarun_mangal 2 роки тому

    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

  • @cesarvalle1565
    @cesarvalle1565 3 роки тому +2

    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).

    • @chandoo_
      @chandoo_  3 роки тому +2

      Thank you Cesar... I am so glad I could teach & inspire long-time users like you. More power to you.

  • @victoriagleason377
    @victoriagleason377 Рік тому

    You are AMAZING and I love your videos - I learn so much from you. THANK YOU

  • @BikashKumar-pz8hc
    @BikashKumar-pz8hc 3 роки тому +1

    I love it, I love it, I love it..........................Completely in love with your content. Thank You!

    • @chandoo_
      @chandoo_  3 роки тому

      You are so welcome!

  • @samuelkodjoe1645
    @samuelkodjoe1645 3 роки тому +1

    That was very powerful....I'm always learning new tricks from you

  • @RobertAfrick
    @RobertAfrick 3 роки тому +3

    I always learn something new and unexpected…keep them coming!

    • @chandoo_
      @chandoo_  3 роки тому

      Thanks Robert... :)

  • @DF-te2vm
    @DF-te2vm Рік тому

    Nice of you to share your knowledge !

  • @p_anjali_codes
    @p_anjali_codes 2 роки тому

    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.

  • @Mhasnain2
    @Mhasnain2 3 роки тому +2

    Informative and great teaching and confidence style.

    • @chandoo_
      @chandoo_  3 роки тому

      Glad you liked it!

  • @sriramamurty1298
    @sriramamurty1298 3 роки тому +1

    Great....expecting more & more advanced tips....will be really helpful

  • @ssjewur
    @ssjewur Рік тому

    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!

  • @v.g.3640
    @v.g.3640 Рік тому

    Awesome video.Thanks for sharing all these useful tips!

  • @matttejada7381
    @matttejada7381 2 роки тому

    The data slicer is something new to me and it is wonderful.

  • @KamranMumtazAhmed
    @KamranMumtazAhmed 3 роки тому +1

    Some of the tricks were really awesome. Thank you for sharing with us.

    • @chandoo_
      @chandoo_  3 роки тому

      Glad you like them!

  • @murali_p
    @murali_p Рік тому

    Ohh my god, I had never seen such a smart guy in excel. Thank you brother.

  • @sumanghosh4951
    @sumanghosh4951 4 місяці тому

    Thank you sir for such a wonderful and knowledgeable session on advance Excel. Got to know new tricks.❤

  • @kenmcmillan2637
    @kenmcmillan2637 3 роки тому +1

    Fantastic tips sir! You are absolutely the BEST! Thank you for sharing.

  • @morechaitanya
    @morechaitanya 2 роки тому

    The best thing I liked about your video is, you are straight to the point, no bakwaas.............

  • @salehmuhammad6811
    @salehmuhammad6811 3 роки тому +1

    Loved these tricks.

  • @Nitinpaste-k5l
    @Nitinpaste-k5l 3 роки тому

    before watching your video i hit the like button, you are the best ! I truly follow you.

  • @AnshulMarele-gbaa
    @AnshulMarele-gbaa 2 місяці тому

    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?

  • @youssouf.a
    @youssouf.a 3 роки тому +4

    Thanks a lot, especially for the printing trick n°26 !

    • @chandoo_
      @chandoo_  3 роки тому

      You are welcome...

  • @gvinodnair
    @gvinodnair 3 роки тому +1

    Wow! Learning these tricks will surely make you productive and AWESOME in your job. Thanks Chandoo. ❤

    • @chandoo_
      @chandoo_  3 роки тому

      Thank you Vinod....

  • @zachngullie1866
    @zachngullie1866 Рік тому

    Thank you Chandoo sir , your videos are really helping me a lot 👍

  • @netesamuel2231
    @netesamuel2231 2 роки тому

    Thank you for d well explanatory of excel tricks and tips. Areas of interest capture, Many thanks

  • @miniroy1902
    @miniroy1902 3 роки тому

    Very Helpful and awesome tricks,

  • @sathishsathish-zm4vw
    @sathishsathish-zm4vw 5 місяців тому

    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

  • @LearnAccessByCrystal
    @LearnAccessByCrystal 2 роки тому +1

    so many good tips, thanks Chandoo!

  • @awesome_uk
    @awesome_uk 3 роки тому +2

    very helpful tips, Chandoo

  • @masterliver101
    @masterliver101 2 роки тому

    Fabulous as ever. Several of those are going to be applied to some data sheets on Monday at work. Thanks

  • @tirisal7370
    @tirisal7370 2 роки тому

    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

  • @dionisioxxx2008
    @dionisioxxx2008 2 роки тому

    Excellent! Thanks Chadoo!!

    • @chandoo_
      @chandoo_  2 роки тому

      Glad you liked it!

  • @jonk3361
    @jonk3361 3 роки тому +1

    Amazing...I have surely learnt some tips I didn't know. Thank You

  • @balakrishnanp7190
    @balakrishnanp7190 3 роки тому +1

    Man, day by day you are amusing me. Thumps up

  • @nagarajshekar5664
    @nagarajshekar5664 3 роки тому

    I like the way u explain everything in smoother way

  • @KimzCraftz
    @KimzCraftz 3 роки тому +1

    Great tips, many thanks for sharing, Chandoo. 😎

    • @chandoo_
      @chandoo_  3 роки тому

      You are welcome Kim...

  • @signofshinejobs6391
    @signofshinejobs6391 3 роки тому +2

    Mr. Chandoo
    Your works are really really awesome

    • @chandoo_
      @chandoo_  3 роки тому +1

      Thank you... 😍

  • @pardhasrihar
    @pardhasrihar 2 роки тому

    I love the way you explain. Thanks for that. And also can you explain about PowerBI

  • @shanhanif218
    @shanhanif218 Рік тому

    Love from Pakistan, Thanks for this valuable knowledge.❣

  • @pvsraaaa865
    @pvsraaaa865 3 роки тому +1

    Very useful tips and tricks. Learned something new today. Thanks Chandoo

    • @chandoo_
      @chandoo_  3 роки тому

      You are welcome Rama...

  • @isuruwickramasinghe9119
    @isuruwickramasinghe9119 3 роки тому

    Chandoo Man you are an XL GOD !, all the best and we need more !

  • @arbazahmad7177
    @arbazahmad7177 2 роки тому +1

    Thanks 😊 it's really Awesome.
    Excel = Chandoo = Awesome

  • @syedsirajudeen6394
    @syedsirajudeen6394 3 роки тому

    Maasha Allaah, Super Informative. Brother

  • @varunv9414
    @varunv9414 2 роки тому

    Thank you. wonderful & very useful videos. Pls keep doing such videos

  • @mkvlogsmahmoodkhan6412
    @mkvlogsmahmoodkhan6412 2 роки тому +1

    Hi Mr. chandoo i really like the way of your teaching. Thank you so much for spreading knowledge.

  • @Gorman-84
    @Gorman-84 Рік тому

    You are very fun to watch. Keep it up!

  • @dashrathpanchal8393
    @dashrathpanchal8393 3 роки тому

    Cool tricks chandoo as you are
    Thanks for sharing !!!

  • @meenasaravanan18
    @meenasaravanan18 2 роки тому

    This is pure gold!

    • @chandoo_
      @chandoo_  2 роки тому

      You know our rules. If I find gold, I must share it. 😀

  • @anusarikashree6109
    @anusarikashree6109 2 роки тому

    Nice tips. First time on this channel and gladly subscribing

  • @winsbury
    @winsbury 2 роки тому +1

    Good training video, cleanly presented with excellent pace.

  • @pvrameshbabu
    @pvrameshbabu 3 роки тому

    Selection of charts the last trick was cool.

  • @sk_cuteact1704
    @sk_cuteact1704 3 роки тому +1

    Really amazing tricks . Thanks a lot..

    • @chandoo_
      @chandoo_  3 роки тому +1

      Thanks Shoba. :)

  • @unspecified306
    @unspecified306 2 роки тому

    I enjoyed watching your videos, sir. Thank you!

    • @chandoo_
      @chandoo_  2 роки тому

      Thanks for watching!

  • @AndrzejFLena
    @AndrzejFLena 3 роки тому

    WOW the stock API is just legendary THANK YOU CHANDOO! :D

  • @jeremykong1657
    @jeremykong1657 2 роки тому

    Thanks Chandoo for this amazing tips.

  • @preethibalamurugan4976
    @preethibalamurugan4976 Рік тому

    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..

  • @AveyAvey
    @AveyAvey 3 роки тому

    Thank you sir for this effort for us

  • @c.mdsalih
    @c.mdsalih Рік тому

    Awesome video, thank you so much👏

  • @ai.simplified..
    @ai.simplified.. 3 роки тому

    Really enjoy this tricks, Do you have any tutorial anout analysis package.

    • @chandoo_
      @chandoo_  3 роки тому +1

      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

  • @chonzadaniel
    @chonzadaniel 2 роки тому

    Amazing tricks, easy to follow! I enjoyed watching the video

  • @raymondnepomuceno8815
    @raymondnepomuceno8815 2 роки тому

    great video! thanks a lot!

  • @venkatiyer7459
    @venkatiyer7459 2 роки тому

    Very useful one Sirji … As usual thanks a lot 🙏

  • @a.rakeshpatro
    @a.rakeshpatro 3 роки тому +1

    Great video. Thanks :)

  • @kiranyeluru7392
    @kiranyeluru7392 2 роки тому

    Wowwwwwwwwwwwwww Next Level Of teaching.................

  • @BenDieselBasicAutomotive
    @BenDieselBasicAutomotive 2 роки тому

    Thank you for the knowledge.

  • @vijayarjunwadkar
    @vijayarjunwadkar 3 роки тому +5

    Awesome tips Chadoo! Love the way you explain and present real life examples to help understand! 😊👍

    • @chandoo_
      @chandoo_  3 роки тому

      Glad it was helpful!

  • @monilj7766
    @monilj7766 3 роки тому +1

    Dear Chandoo excellent video

  • @mohemmedansari8664
    @mohemmedansari8664 3 роки тому

    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...

  • @AlesterPaladin
    @AlesterPaladin 3 роки тому +2

    This is a gold mine.👌😀

  • @tfconsulting152
    @tfconsulting152 Рік тому

    Chando! wonderful!!!! show some basic DAX and PowerBi sometimes

  • @thangaveluraj5366
    @thangaveluraj5366 3 роки тому +1

    Amazing.. as usual, thanks a lot. I have gained immensely. Notable is the nice audio quality, please keep it up.

  • @shauncamilleri4451
    @shauncamilleri4451 3 роки тому

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

    • @chandoo_
      @chandoo_  3 роки тому +1

      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.

  • @poodleseigien
    @poodleseigien 2 роки тому

    I enjoy your videos! Thanks for making them!

  • @fkutb
    @fkutb Рік тому +1

    I learned more about Excel in 20 minutes than I learned in 20 years. Thank you.

    • @ambhat3953
      @ambhat3953 Рік тому

      Then i guess you should do something else rather than work on excel

  • @suriyabalakrishnan614
    @suriyabalakrishnan614 2 роки тому

    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

  • @MuhammadAhmed-wk4zh
    @MuhammadAhmed-wk4zh 3 роки тому +1

    Nice Chandoo!!
    Can you share the excel file which used in above video.
    Thanks

    • @chandoo_
      @chandoo_  3 роки тому

      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.

  • @apple67603
    @apple67603 2 роки тому

    Nice and useful thank you

  • @maharadha1000
    @maharadha1000 11 місяців тому

    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

    • @chandoo_
      @chandoo_  11 місяців тому

      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.

  • @RoleJohn
    @RoleJohn 2 роки тому

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

    • @chandoo_
      @chandoo_  2 роки тому

      Awesome news CY. I am eager to hear about your progress. Keep us posted.
      More POWER ⚡ to you.

  • @nidhumanoj1552
    @nidhumanoj1552 2 роки тому

    I enjoyed all tips....

  • @patel2776
    @patel2776 2 роки тому

    @Chandoo Is there an Excel practice sheet for this video?

  • @ramneekpalkaur1349
    @ramneekpalkaur1349 3 роки тому

    Thanks a lot Sir for sharing such type of information. Great work.

  • @srinivaseven
    @srinivaseven 3 роки тому +17

    Great! your voice remembered me of my spiritual giant "Sri Satya Sai Baba".

  • @donaldlcartinsr2332
    @donaldlcartinsr2332 3 роки тому

    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.

    • @chandoo_
      @chandoo_  3 роки тому

      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/

  • @suchitaparanjape436
    @suchitaparanjape436 2 роки тому

    Thank you so much Sir.. 🙏

  • @wayneedmondson1065
    @wayneedmondson1065 3 роки тому +1

    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!!

    • @chandoo_
      @chandoo_  3 роки тому +1

      My pleasure Wayne. I wanted to create something epic to celebrate the 100k milestone. Hence this 😀

    • @wayneedmondson1065
      @wayneedmondson1065 3 роки тому

      @@chandoo_ Excellent! Congrats on the subscriber milestone :))

  • @KC-ym5nv
    @KC-ym5nv 2 роки тому

    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

  • @sravanbphrm
    @sravanbphrm 2 роки тому

    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🙂

    • @chandoo_
      @chandoo_  2 роки тому

      You're very welcome!

  • @ranjannayak99
    @ranjannayak99 2 роки тому

    Dear Chandoo Awesome Video...Kindly Share the Awesome data set....

  • @Salauddinshaik
    @Salauddinshaik 3 роки тому +1

    chandu garu, superb andi, loved it, thank you so much, so many useful tricks ,thank you very much andi!!

    • @chandoo_
      @chandoo_  3 роки тому

      Thanks for the lovely comment Salauddin... :)

  • @NiKO......
    @NiKO...... 2 роки тому

    chandoo bhai dil jit liya apne!!