7 Advanced Excel Tricks

Let's learn about the 7 most useful & interesting Excel Tricks. These tricks can help you speed up your Excel work & help you be more efficient. The tricks we will be discussing:
1. Quickly Adding Data to the Chart
2. Chart Formatting
3. Unpivoting using Excel
4. Breaking Data into Multiple Excel Sheets
5. Dynamic Ranges
6. Defining Custom Sort Order
7. Fiscal Year & Quarter ( Custom Function )
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/l...
✔️ Mastering DAX in Power BI -
goodly.co.in/l...
✔️ Power Query Course-
goodly.co.in/l...
✔️ Master Excel Step-by-Step-
goodly.co.in/l...
✔️ Business Intelligence Dashboards-
goodly.co.in/l...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co....
Corporate Training 👨‍🏫 - www.goodly.co....
Need my help on a Project 💻- www.goodly.co....
Download File ⬇️ - goodly.co.in/7...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - [e-mail]
===== 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'll find a ton of interesting videos that I have created :) Cheers!

[@KK-ty5hz]

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

[@jostsalzmann7192]

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

[@cholliday]

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

[@lmk001]

That is some excellent wizardry. Thanks!

[@chrism9037]

Great video Chandeep!

[@barttrudeau9237]

#6 🤯 wow!!!

[@thomasdavet2718]

Previous Cell trick is amazing!!!

[@IvanCortinas_ES]

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

[@tinhoyhu]

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

[@mogarrett3045]

thank you Sir

[@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

[@dvpe]

dynamic range blew my mind, indeed!

[@pierre-yves_david]

Me too!

[@KK-ty5hz]

Thanks👏

[@GoodlyChandeep]

Thanks Bro

[@scotolivera8207]

thanks

[@ahmed007Jaber]

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

[@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 UA-cam 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?

[@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.

[@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.

[@chrisholden6658]

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

[@GoodlyChandeep]

apply to all sheets

[@nazarkamal8831]

❤❤❤

[@SSi-nq3rt]

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