7 Advanced Excel Tricks

Рет қаралды 18,139

Goodly

Күн бұрын

Пікірлер: 43

@KK-ty5hz 2 ай бұрын

Thanks👏

@GoodlyChandeep 2 ай бұрын

Thanks Bro

@peggymahabir6108 2 ай бұрын

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 🙂

@chrism9037 2 ай бұрын

Great video Chandeep!

@jostsalzmann7192 2 ай бұрын

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

@KK-ty5hz 2 ай бұрын

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

@udayteja6595 2 ай бұрын

Great Content...

@cholliday 2 ай бұрын

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

@lukev730 2 ай бұрын

Awesome Chandeep I like the previous cell formula

@unnikrishnansanthosh 2 ай бұрын

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

@lmk001 2 ай бұрын

That is some excellent wizardry. Thanks!

@pondyanand 2 ай бұрын

Last one was the best 🔥

@odallamico 2 ай бұрын

gREAT Tricks in excel. Thank you for sharing

@edwindeo 2 ай бұрын

That was good bro 😊

@shyjumathew07 2 ай бұрын

Good one, thanks bro

@thomasdavet2718 2 ай бұрын

Previous Cell trick is amazing!!!

@tinhoyhu 2 ай бұрын

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

@barttrudeau9237 2 ай бұрын

#6 🤯 wow!!!

@nakibsayed 2 ай бұрын

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

@JonathanExcels 2 ай бұрын

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 2 ай бұрын

Agree

@mogarrett3045 2 ай бұрын

thank you Sir

@dvpe 2 ай бұрын

dynamic range blew my mind, indeed!

@pierre-yves_david 2 ай бұрын

Me too!

@josealvesferreira1683 2 ай бұрын

very interesting

@ahmed007Jaber 2 ай бұрын

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

@IvanCortinas_ES 2 ай бұрын

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

@chrisholden6658 2 ай бұрын

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

@GoodlyChandeep 2 ай бұрын

apply to all sheets

@Nitinpaste-k5l 2 ай бұрын

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

@ankursharma6157 2 ай бұрын

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.

@scotolivera8207 2 ай бұрын

thanks

@robbyl12 2 ай бұрын

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 2 ай бұрын

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 2 ай бұрын

@@uclApoWhy not?

@dareemmanuel6079 2 ай бұрын

@@Nana_Buahendid you not read or understand his response?

@prashantrawat6738 2 ай бұрын

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 2 ай бұрын

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