The ultimate Excel tips and tricks guide

20 years of Excel Tips and Tricks jam packed into 1 hour.
Created for the Microsoft Excel Tech Community Webinar Series

Learning Power BI?
Check out my book
"Power BI for the Excel Analyst"

0:00 Introduction
00:53 Merging and Hiding
3:39 Fills and Formats
13:10 Copy Paste
15:10 Shapes
18:04 Tables
23:50 Power Query
31:00 HYPERLINK Function
34:54 Hyperlink with XLOOKUP
37:15 Traffic Lights (Icons)
39:16 AGGREGATE
42:00 SWITCH
44:45 TEXTJOIN
46:30 Grand Totals on a Stacked Chart plus the 5 m trick
48:45 Dependent Drop Downs
56:24 XLOOKUP and Data Validation
58:21 Quick PIVOT tricks

The other webinars in the series are here

Did you know I've written a book "Power BI for the Excel Analyst"?

Connect with me

[ne]

This is the most informative video I have ever watched, and also most useful for those who works extensively with office apps. Like You have improved the efficiency of thousands of people. Unbelieveable work.

[PhuongNguyen-wmwi]

You are so kind to share all the tricks like that. I have been frustrating with doing things without shortcuts, but I didn't even know many of them were possible until I watched your video. Thank you much!!!

[Serraomomma]

I’ve been using excel for years and these tips are priceless! Some I knew, but many were new! Bravo!!!!

[bernardheymans]

You definitively made my day.
second video seen... LOST 3 hours looking. WON many hours working.

[gwenkreager]

Excellent! I will be watching this every day until I have memorized every Amazing new stuff.

[Computergaga]

Nice one Wyn. I was waiting for your infamous Slicer tab technique 😜

[wmfexcel]

Power Query - The best washing machine for dirty data!
I love it. :)

[txreal]

12:06 Thanks for reminding me to remove the "idiot" like from my Autocorrect 🤣
I also saved a list of your Autocorrect options

[jcc]

Only 10 mins in, but that double click formatting thing will save me so much time! It was such a pain trying to copy formats to different parts. And it works on WORD too

[txreal]

21:50 Insert Slicer - I use this quite a bit so I put this in the QAT. Thanks.

[TheJoshtheboss]

6:14 what kind of wizardry is this :). Excel is like an infinite well of suprises

[adiloufkir]

I've learned so much through this fantastic tutorial! Huge thanks!

[KingsoTV]

Right-click and drag a cell / range border...
Also, for the dependant lists, I just use separate tables with the DV of =INDIRECT(%primary%). I have a macro that sets the table name to the header value.

[benaycock]

Every video of yours I’ve seen makes me holler in excitement lol. Glad I found your channel! Thanks for sharing!

[manel]

I've seen many unusual Excel tips that can be helpful in the future! Thanks

[joedi]

I have to admit I smugly thought ‘Been here and done it all’. Ha! Little did I know, the old cat learned some new tricks.

Count: 8 new ones that I did not know!

[billgillaspey]

Really good, quick, overview. I LIKE it; watched it a second time. [But only 190 likes? deserves MANY more than that.]

[BenDieselBasicAutomotive]

Thanks for sharing your knowledge.... More power to you, Sir!... May GOD bless you more and

[breadplastic]

I want to visit Perth once in my life. Bucket list.

[michellethaovu]

Super informative. Sometimes I thought "oh I already know this trick" then you take it to next level and my jaw dropped =))