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

#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 👉
========================

🔴 NEW - My course on Lookup Formulas
==================================

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.

~

🐦🦜🦃 Bird songs
=================
Recorded on a recent walk around my neighbourhood in Wellington, NZ.

Thank you and happy learning 😀

[pritikane]

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

[bolleauk]

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

[SanjayGore]

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.

[vijayarjunwadkar]

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

[kenmcmillan]

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

[sumanghosh]

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

[thevellaengineer]

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

[youssouf.a]

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

[zendfabi]

Very refreshing. Thank you for sharing.

[shailyagrawal]

I love your videos - so detailed and easy to follow

[PSMMOORE]

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!

[jonk]

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

[winsbury]

Good training video, cleanly presented with excellent pace.

[chandoo_]

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

[anjalipandey]

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.

[mkvlogsmahmoodkhan]

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

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

[poodleseigien]

I enjoy your videos! Thanks for making them!

[suriyabalakrishnan]

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

[ChinmayGaikwad]

Really enjoyed this video, It was extremely helpful!