I asked 6 Excel experts to share their *BEST* tips & tricks 👌

Are you ready for an EPIC Bonanza?
In this *INSANE* episode of Excel goodness, 6 Excel Experts share 12 of their BEST Excel tips & tricks. It is my honour and privilege to feature @MrXL @plumsolutions @trumpexcel @Computergaga @KenPulsXLGuru and @BorianaPetrova

Video Chapters ⏱👉
=================
0:00 - Hellos from the Experts
0:35 - Bill's first tip - Fill Series
1:31 - Sumit's first trick - Moving columns
2:50 - Alan's first tip - Use Tables
4:22 - Ken's first trick - Power Query load behaviour
5:50 - Boriana's first tip - Full column formulas
6:54 - Danielle's first trick - UNIQUE()
8:06 - Alan's second one - Chart labels from cells
9:09 - Ken's second trick - PQ Double refresh problem & fix
10:26 - Sumit on comparing two workbooks
11:31 - Danielle about see same workbook on two screens
12:20 - Boriana on smart ⚡way to get GRAND totals
13:28 - Bill on the secret 6 coloured ICONS 🔴🟠🟡🟢🔵🟣
15:41 - Closing remarks

Meet the experts 🤝
================
Please SUBSCRIBE to these channels if you want to learn from the EXPERTS. Amazing content & tips.

[1] Bill Jelen
[2] Sumit Bansal
[3] Alan Murray
[4] Ken Puls
[5] Boriana Petrova
[6] Danielle Stein Fairhurst

#BESTExcelTips

[MrXL]

I love these tips! Thanks for compiling them, Chandoo! At 1:43, I thought Sumit would sort Left to Right by Row 1. (Data, Sort, More Options, Sort Left to Right).

[vivek-placardcommunication]

Teaching excel is one thing and admiring the work of your competitors / fellow teachers is another. Your gesture is highly appreciated. This makes you even more respectable. Thank you. 👍🏼

[plumsolutions]

Thank you Chandoo for putting this together - it looks like you've had LOADS of fun with the editing process. So excited to be a part of it!

[meniporat]

Hi Sumit Bansal,
there's a simpler solution to reorder the columns:
1. select all data (except for column
2.Data-> Sort->Options>Sort Left to
3. sort by: Row1 and press:

😊

[wayneedmondson]

A Great collection of tips. Even for those recognized, it is a good reminder and refresher to use them. Thanks and thumbs up!!

[rodrigovalerio]

Such a useful video, thank you for putting something like this together.

[soumyodipkanrar]

Thanks for bringing together the experts! They are awesome. I regularly refer their videos.

[johnborg]

Thanks Chandoo for bringing them all together!! that was FUN!!

[talkinghat]

Excellent ideas bringing experts into one clip. Sharing is caring. Thanks.

[sagarvaryani]

Memes in this education video is like cheery on cake 😂😂

[aq]

thanks to all the wonderful trick masters and yes chandoo too👍

[freezendog]

Thanks guys!!! Awesome video Chandoo! My favourite has to be the last one by Bill, with the multicolour data bar, which you can repeat for as many values as you'd like...!!!! What??? 👏👏👏

[juja]

Thank you! So nice to see you all in one video :)

[caraziegel]

Ooh the power query default is something i can use right now!

[simonsj]

Thanks to the experts for the helpful tips.

[rajanghadi]

Hi,
There were 2 out of were new and added to my knowledge. Bill's conditional formatting was awesome and another which was solution for double refresh query and pivot (I was always doing refresh double till date).

Thanks Chandoo.. You should have also contributed to this by one of your tricks.

[MrGulsaeed]

Best video I have watched today. Thank you!

[alizaib]

Really amazing tips and tricks, .... Thank you all respected...

[KO]

Keep in mind Sumit's tip on moving ranges of data does not work with Tables. If you have a table you must Alt+drag instead of Shift+drag.

[cherianiype]

Thanks Chandoo for bringing the best leaders of Excel in 1 place. Lovely to see the legends - Bill, Ken, etc... Hope you can also bring in Mike Girvin next time too. thx Chandoo!