7 Advanced Excel Tricks

[@KK-ty5hz]

Thanks👏

[@GoodlyChandeep]

Thanks Bro

[@thomasdavet2718]

Previous Cell trick is amazing!!!

[@lmk001]

That is some excellent wizardry. Thanks!

[@chrism9037]

Great video Chandeep!

[@lukev730]

Awesome Chandeep I like the previous cell formula

[@odallamico]

gREAT Tricks in excel. Thank you for sharing

[@jostsalzmann7192]

Mandy Thanks for the video. My favorites are tips 4 and 5. Greetings from Germany

[@pondyanand]

Last one was the best 🔥

[@unnikrishnansanthosh]

thank you for sharing, all are superb tricks, well Dynamic ranges will be my top one

[@cholliday]

Most impressive 'Advanced Excel Tricks' type video that I've watched. Great work!

[@udayteja6595]

Great Content...

[@dvpe]

dynamic range blew my mind, indeed!

[@pierre-yves_david]

Me too!

[@barttrudeau9237]

#6 🤯 wow!!!

[@peggymahabir6108]

awesome tricks! I love it...thank you for sharing!! and yes, I am totally loving the "Previous Cell" trick. So excited to try them all 🙂

[@KK-ty5hz]

Too Good bhai. Very handy tricks. Gratitude for sharing :)

[@tinhoyhu]

That splitting into different worksheets trick is 🤯 Required a vba macro to do that before.

[@shyjumathew07]

Good one, thanks bro

[@mogarrett3045]

thank you Sir

[@IvanCortinas_ES]

Excellent explanation with those 2 Lambdas. Thank you Chandeep!!!

[@edwindeo]

That was good bro 😊

[@JonathanExcels]

A problem with custom sort lists is that the list only exists on the PC of the person that created the file. Any other user of that file will not have that option.

[@GoodlyChandeep]

Agree

[@josealvesferreira1683]

very interesting

[@nakibsayed]

Can we get multiple sheet report filter for showing two pivot tables in each sheet report

[@ahmed007Jaber]

Amazing man! never seen this one before, Alt+ D + P

[@scotolivera8207]

thanks

[@abidurrahmanabir7745]

Brother Love From BANGLADESH, I m new in Power Bi.. My Question is can i make any Power-Bi Project without Code?? Waiting for your reply......

[@chrisholden6658]

what's the relevence of keeping the "!' on the dynamic range?

[@GoodlyChandeep]

apply to all sheets

[@nazarkamal8831]

❤❤❤

[@prashantrawat6738]

What are the Job opportunity related to Excel. In India mainly MIS Executive job are popular but i dont think it has potential to grow in it. What do you think about it? How's in other countries?

[@GoodlyChandeep]

If your job is related to data, information and analysis, you have massive opportunity anywhere in the world including India.

[@Nitinpaste-k5l]

But if I want totals in TOP row in columns how can we do Dynamic name range ?? Pls advise

[@ankursharma6157]

Hi @Nitinpaste-k5l, Assume . . presently . . the dataset range is from B4:B10. You expect the range will increase from B10. In the SUM formula, You select a larger range. Example: SUM(B4:B1000) When new data is added in B11, B12 . . the formula will return the updated answer. This is the most convenient and oft-used method. Hope, this helps.

[@robbyl12]

Pls provide significant purchasing power parity discount on your M language course so it will be affordable for the student from developed country like me. tks

[@uclApo]

Buy a book. Tons of video on KZbin are free. If you want to learn there are tons of way for doing it. Money is not an excuse. Don't ask discount for people works

[@Nana_Buahen]

​@@uclApoWhy not?

[@dareemmanuel6079]

@@Nana_Buahendid you not read or understand his response?

[@mirash7]

Bro in every other tool 🗿 Bro in excel🗿🗿🗿🗿🗿🗿🗿

[@SSi-nq3rt]

„stone age“ 😂…. sometimes you can feel like „in the stone age“ even thought they have the latest excel version 😢