Highly Useful Excel Tricks that NO ONE Knows | Advanced Excel Tips and Tricks

Presenting some super useful Excel Tricks that can speed up our day-to-day tasks in Excel!

===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -

✔️ Power Query Course-

✔️ Master Excel Step by Step-

✔️ Business Intelligence Dashboards-

===== LINKS 🔗 =====

===== CONTACT 🌐 =====

===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

[vokisek]

I consider myself very proficient in Excel and usually in these kind of videos are the same tricks over and over again, but all of these tricks (except maybee autofill) were new to me :) Nicely done :)

[elbadlis]

Exclamation mark in trick #2 to make it available in all sheet is the one i found awesome. Thank you for sharing this, Chandeep!!!

[excelgazialimuhiddinhacibekir]

Chandeep, you are absolutely my favorite hero on the block of the NEW GENERATION Excel teachers.

As an Excel instructor who has been learning and teaching and implementing Excel for teaching, research and business in the past 18 years, I didn't know TRICK #5 about pasting the format of an Excel chart onto another Excel chart, TBH.
I love TRICK #2 -- I learnt it recently, just last year, with the "!" = exclamation mark. But I had never ever thought of using a RELATIVE cell address to refer to the cell above or to the cell to the LEFT WHEREVER YOU ARE. That is so elegant, so clever! Thanx a lot, Chandeep!

[sabarashid]

Dynamic Ranges trick was the one which blew my mind off. So subtle no offset formula or other long formulas to make the range dynamic. Thanks for sharing

[canirmalchoudhary]

It's not about knowing or not knowing it's shame when people don't use even after knowing. Exclamation mark and dynamic range is really awesome. When I picked up learning excel your PDF was in my bucket and it is still on my drive. Thank you. You are super amazing in all excel tricks.

[rm]

Awesome Chart trick ! All your videos are informative and quick and smart. Thanks for sharing.

[stefaanlouette]

"They're go bonkers" loved it 😅 and I didn't knew any trick so thank you for sharing!!

[incredible]

PrevCell blew my mind. Thanks a lot. Will apply this to several of my sheets at work

[mohammedelsayed]

Man this is insanely amazing……
I knew some of those tricks but the last one (chart paste format) is mind blowing. I remembered every single chart and dashboard I created in the last 15 years 😢😂

[pratikcu]

I have been using excel for so many years and I felt I am pretty good at it but surprisingly, I didn't knew any of this trick.. Just Awesome !!!

[pupycron]

That Previous Cell sum trick is nice! Never seen that one for sure. The quick lookup is also pretty cool and unknown to me. Thanks for these!

[onehardy]

Unbelievable Chandeep! Usually, if they tell in other videos about excel tricks, I know all of them. In your video I didn't know any of these tricks! Amazing! Thanks!

[jdholakia]

Wow!! some really useful shortcuts.... amazing...

[pokesajid]

Bro these tips are actually amazing! I haven’t seen these on any videos working my corporate job the last 2 years, definitely going to be adding a bunch of these to my arsenal

[ruzzputin]

Amazing! I knew the last 2 tricks but not the first 3. Thank you!

[captvo]

No SHAME but only FAME !!! Neat tricks … thank you for sharing them.

[virgolock]

Thumbs up for all the tricks shared to help us work faster!

[comsavvy_ogp]

Thanks for sharing this amazing Excel tricks! You blow my mind with some of these tricks.


I just subscribed! I must not miss out on the goodies you always share.

[cjimmer]

! Wonderful PrevCell trick. New to me!

[saviodcunha]

Thanks - immensely useful. Did not know anyone