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

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

КОМЕНТАРІ • 399

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

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

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

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

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

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

  • @fkutb
    @fkutb 2 роки тому +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

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

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

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

  • @sominramchiary5880
    @sominramchiary5880 2 місяці тому +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

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

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

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

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

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

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

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

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

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

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

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

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

    Nice of you to share your knowledge !

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

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

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

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

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

    Informative and great teaching and confidence style.

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

      Glad you liked it!

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

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

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

    Loved these tricks.

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

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

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

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

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

      Thanks Robert... :)

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

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

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

    Awesome video.Thanks for sharing all these useful tips!

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

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

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

      You are welcome...

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

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

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

    Love from Pakistan, Thanks for this valuable knowledge.❣

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

    very helpful tips, Chandoo

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

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

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

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

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

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

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

      Glad you like them!

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

    This is a gold mine.👌😀

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

    I like the way u explain everything in smoother way

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

    Very Helpful and awesome tricks,

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

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

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

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

    My favorite Excel youtuber :) I'm currently studying to become a Data Analyst in my late 30s, and so far your vids have been spot on every time I'm in a pickle ;)

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

    Good training video, cleanly presented with excellent pace.

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

    Mr. Chandoo
    Your works are really really awesome

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

      Thank you... 😍

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

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

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

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

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

    chandoo bhai dil jit liya apne!!

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

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

  • @cascadelover1
    @cascadelover1 4 дні тому

    You are just excellent. Keep the hard work up.

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

    Very refreshing. Thank you for sharing.

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

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

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

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

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

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

    Thanks Chandoo for this amazing tips.

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

    Great video. Thanks :)

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

    so many good tips, thanks Chandoo!

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

    Thank you for the knowledge.

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

    Thanks Chandoo👍👌

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

      You are welcome Nikhil.

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

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

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

    Excellent! Thanks Chadoo!!

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

      Glad you liked it!

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

    This is pure gold!

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

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

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

    You are very fun to watch. Keep it up!

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

    Great tips, many thanks for sharing, Chandoo. 😎

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

      You are welcome Kim...

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

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

    I enjoy your videos! Thanks for making them!

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

    Awesome video, thank you so much👏

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

    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

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

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

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

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

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

    I enjoyed all tips....

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

    Selection of charts the last trick was cool.

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

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

    Awesome 👌

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

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

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

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

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

    Really amazing tricks . Thanks a lot..

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

      Thanks Shoba. :)

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

    Maasha Allaah, Super Informative. Brother

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

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

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

      You are welcome Rama...

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

    great video! thanks a lot!

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

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

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

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

    Excellent tips Chandoo, thank you!

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

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

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

    AWESOME TECHNIQUES

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

    I love your videos - so detailed and easy to follow

  • @thevellaengineer6067
    @thevellaengineer6067 2 роки тому +5

    Dear Chandoo the way you elaborate and explain things is pretty good as well as helpful, I would like to thank you for such a good quality content. I found your videos are very helpful for me to start my carrer as a Data Ananlyst. Lots of love and respect for you .

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

    Thank you sir for this effort for us

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

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

    Amazing tricks Chandoo. Thanks for such quick learnings.

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

    Dear Chandoo excellent video

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

    Excellent Well done

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

    Nice tips. First time on this channel and gladly subscribing

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

    Thank you so much Sir.. 🙏

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

    Very useful one Sirji … As usual thanks a lot 🙏

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

    I enjoyed watching your videos, sir. Thank you!

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

      Thanks for watching!

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

    Dear Chandoo, the way you teach is really marvelous. Kudos to your effort.

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

    Awesome Tricks to Ease My Project Presentations....Thanks Bro

  • @NEERAJSINGH-rw6pj
    @NEERAJSINGH-rw6pj 3 роки тому

    Amazing tips and tricks

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

    Nice and useful thank you

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

    Love! Love!Love! ♡♡♡♡♡☆☆☆☆
    Wonderful video!

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

      Thank you so much! 😍

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

    It's very informative and useful