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

Top 30 Advanced Excel Tips to make you awesome ⚡💡

Рет қаралды 334,972

Күн бұрын

#ExcelTips
Time to celebrate the beauty and versatility of Excel with 30 of my favourite Excel tips for advanced uses. You will be amazed and satisfied for sure. Watch the whole thing & share the video with a friend. Use below timestamps if you need to see a specific tip.
⏱ Video timestamps
==================
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
* indicates that you need Excel 365 to use the tip. All other tips should work in any modern version of Excel.
💡 More Excel tips for you 👉
========================
10 data cleaning tricks experts use all the time - • Data cleaning in Excel...
10 formatting tricks only Pro users know - • 10 Excel formatting tr...
10 awesome things you can do in Excel without formulas - • 10 awesome things you ...
10 copy paste tricks that you are not using - • 10 *SURPRISING* Copy P...
10 of my favourite Excel keyboard shortcuts - • The *ONLY* 10 Excel ke...
🔴 NEW - My course on Lookup Formulas
==================================
👉 skl.sh/3pR8ISG
I recently launched a complete short course on Excel lookup functions. You will learn all about XLOOKUP, VLOOKUP, FILTER, HLOOKUP, INDEX+MATCH and how to combine these functions to solve business problems. You will also learn advanced lookup techniques like 2-way lookups, all matching results, multiple criteria lookups in the course.
Join for this class on Skillshare - You will also get 1 month premium membership to the platform for when you use my link.
Click here 👉 skl.sh/3pR8ISG
~
🐦🦜🦃 Bird songs
=================
Recorded on a recent walk around my neighbourhood in Wellington, NZ.
Thank you and happy learning 😀

Пікірлер: 393

@pritikane4448 2 жыл бұрын

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

@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

@garylowe598 2 жыл бұрын

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

@saumyagajjar8047 2 жыл бұрын

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 2 жыл бұрын

@@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 2 жыл бұрын

@@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_ 2 жыл бұрын

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

@SanjayGore 2 жыл бұрын

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_ 2 жыл бұрын

Thanks Sanjay... :)

@umarbk2664 Жыл бұрын

This awesome, I enjoyed every bit of your video. Thanks

@varunv9414 Жыл бұрын

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

@shailyagrawal2513 2 жыл бұрын

I love your videos - so detailed and easy to follow

@kenmcmillan2637 2 жыл бұрын

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

@netesamuel2231 Жыл бұрын

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

@tarun_mangal Жыл бұрын

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

@winsbury Жыл бұрын

Good training video, cleanly presented with excellent pace.

@murali_p Жыл бұрын

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

@DF-te2vm Жыл бұрын

Nice of you to share your knowledge !

@vijayarjunwadkar 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Glad it was helpful!

@c.mdsalih Жыл бұрын

Awesome video, thank you so much👏

@anjalipandey3730 Жыл бұрын

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.

@manjulakarthik2157 Жыл бұрын

It's very informative and useful

@thevellaengineer6067 2 жыл бұрын

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 .

@poodleseigien 2 жыл бұрын

I enjoy your videos! Thanks for making them!

@arbazahmad7177 2 жыл бұрын

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

@zendfabi4666 2 жыл бұрын

Very refreshing. Thank you for sharing.

@ChinmayGaikwad12 2 жыл бұрын

Really enjoyed this video, It was extremely helpful!

@sriramamurty1298 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Sure 😊

@juliane1mota 2 жыл бұрын

Keep up the great work Chandoo. It is greatly appreciated.

@jonk3361 2 жыл бұрын

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

@v.g.3640 Жыл бұрын

Awesome video.Thanks for sharing all these useful tips!

@chrism9037 2 жыл бұрын

Excellent tips Chandoo, thank you!

@dionisioxxx2008 Жыл бұрын

Excellent! Thanks Chadoo!!

@chandoo_ Жыл бұрын

Glad you liked it!

@fkutb Жыл бұрын

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

@ambhat3953 Жыл бұрын

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

@milaronyartgallery4667 2 жыл бұрын

AWESOME TECHNIQUES

@Mhasnain2 2 жыл бұрын

Informative and great teaching and confidence style.

@chandoo_ 2 жыл бұрын

Glad you liked it!

@frankmgecha6491 2 жыл бұрын

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

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

@mkvlogsmahmoodkhan6412 2 жыл бұрын

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

@victoriagleason377 Жыл бұрын

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

@suriyabalakrishnan614 Жыл бұрын

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

@BikashKumar-pz8hc 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

You are so welcome!

@catchcb 2 жыл бұрын

Amazing tricks Chandoo. Thanks for such quick learnings.

@zachngullie1866 Жыл бұрын

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

@alexandarjelenic2880 Жыл бұрын

One tip: install and use “ASAP utilities”. Saves a lot of time.

@chonzadaniel Жыл бұрын

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

@salehmuhammad6811 2 жыл бұрын

Loved these tricks.

@BenDieselBasicAutomotive Жыл бұрын

Thank you for the knowledge.

@kiranyeluru7392 Жыл бұрын

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

@nidhumanoj1552 Жыл бұрын

I enjoyed all tips....

@raymondnepomuceno8815 Жыл бұрын

great video! thanks a lot!

@_KING_SHADOW 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

😍

@syedsirajudeen6394 2 жыл бұрын

Maasha Allaah, Super Informative. Brother

@chandoo_ 2 жыл бұрын

😀 Thank you.

@morechaitanya Жыл бұрын

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

@kita3752 2 жыл бұрын

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_ 2 жыл бұрын

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 2 жыл бұрын

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

@karthickck8203 Жыл бұрын

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

@pvrameshbabu 2 жыл бұрын

Selection of charts the last trick was cool.

@chandoo_ 2 жыл бұрын

Thanks Ramesh...

@excellover7172 2 жыл бұрын

Awesome 👌

@srinivaseven 2 жыл бұрын

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

@meenakshiyyy 2 жыл бұрын

In a way he has a resemblance too

@asheeshdhupper5595 2 жыл бұрын

He is Sai baba of excel tool

@aloksahu993 Жыл бұрын

Right👍

@manioommen871 Жыл бұрын

Shridi Sai Baba is the only true Sai Baba.

@meenasaravanan18 2 жыл бұрын

This is pure gold!

@chandoo_ 2 жыл бұрын

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

@ambhat3953 Жыл бұрын

Didnt know slicers work with tables... thanks!

@ramneekpalkaur1349 2 жыл бұрын

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

@shanhanif218 Жыл бұрын

Love from Pakistan, Thanks for this valuable knowledge.❣

@youssouf.a 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

You are welcome...

@matttejada7381 Жыл бұрын

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

@isuruwickramasinghe9119 2 жыл бұрын

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

@RobertAfrick 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Thanks Robert... :)

@dashrathpanchal8393 2 жыл бұрын

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

@thangaveluraj5366 2 жыл бұрын

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

@flootsy 2 жыл бұрын

Great videos as always.

@jeremykong1657 2 жыл бұрын

Thanks Chandoo for this amazing tips.

@AveyAvey 2 жыл бұрын

Thank you sir for this effort for us

@meluvu1tym190 Жыл бұрын

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

@frenan82 2 жыл бұрын

Amazing as usual. Great and useful compact resume. Thanks!

@ApteryxRex 2 жыл бұрын

Thanks Chandoo! Great video. Especially liked the pivot table colour scale conditional formatting. With very large pivots this plays into pattern recognition, outlier identification.

@juliane1mota 2 жыл бұрын

Your videos are great. They have helped me a lot. I got to know your chanel through your comprehensive Power Query video. Thank you so much for sharing your knowledge.

@monilj7766 2 жыл бұрын

Dear Chandoo excellent video

@chandoo_ 2 жыл бұрын

Thanks Moni...

@KamranMumtazAhmed 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Glad you like them!

@Gorman-84 Жыл бұрын

You are very fun to watch. Keep it up!

@PSMMOORE 2 жыл бұрын

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_ 2 жыл бұрын

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

@anusarikashree6109 2 жыл бұрын

Nice tips. First time on this channel and gladly subscribing

@awesome_uk 2 жыл бұрын

very helpful tips, Chandoo

@excelworx8712 2 жыл бұрын

last was the best. never knew!

@chandoo_ 2 жыл бұрын

Thank you... Excel has tonnes of features that it is hard to know & remember all.

@GZbautista 2 жыл бұрын

I'm your new fan. I just loved watching your video tips. I'm working my skills with Excel and hoping I can be in a level closer to yours 😇🙏

@raghibhumayun291 2 жыл бұрын

Thanks Dear Chandoo Excellent video. the way you elaborate and explain things is tremendous. very useful and professional.

@apple67603 Жыл бұрын

Nice and useful thank you

@miniroy1902 2 жыл бұрын

Very Helpful and awesome tricks,

@terihandrick2333 2 жыл бұрын

Chandoo, I am always amazed at all the wonderful ideas you share with us for Excel. This will be a great help for me in the future using several of these short cuts. Amazing!! Thank you

@chandoo_ 2 жыл бұрын

Glad to hear that. All the best with adding some of these to your workflow :)

@samuelkodjoe1645 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Fantastic!

@pardhasrihar Жыл бұрын

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

@venkatiyer7459 Жыл бұрын

Very useful one Sirji … As usual thanks a lot 🙏

@NiKO...... Жыл бұрын

chandoo bhai dil jit liya apne!!

@shaikusman536 2 жыл бұрын

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

@gvinodnair 2 жыл бұрын

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

@chandoo_ 2 жыл бұрын

Thank you Vinod....

@suchitaparanjape436 2 жыл бұрын

Thank you so much Sir.. 🙏

@jayeshdharod3736 2 жыл бұрын

Superb Chandoo sir, you are amazing

@tfconsulting152 Жыл бұрын

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

@NEERAJSINGH-rw6pj 2 жыл бұрын

Amazing tips and tricks

@chandoo_ 2 жыл бұрын

Thanks a lot

@chandoo_ 2 жыл бұрын

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

@ankitashah6404 2 жыл бұрын

in excel for subtotal if i want to do subtotal for the amount column in the top of the amount column for by default whole column without clicking on the column number mentioned by default in the excel spread sheet, how to do that

@FarmingTips Жыл бұрын

Qww

@prajjwaljaiswal3419 Жыл бұрын

Please share the practice file.

@sriramkudarla75 Жыл бұрын

Thanks for sure.

@press1676 Жыл бұрын

I loved the subtotal function, thanks for sharing superb tips