Top 10 Excel Tricks ONLY Experts Know

10/10, great video!:)

Is there a way to filter for cell color across multiple columns? I know Advanced Filter lets you filter across multiple columns for values typed into cells, but cell color is not a value typed into the cell. 08/18/2023

I do not have the Data Types (Stocks and Curr.) in my bar. How can I add it? :(

can one get a scholarship please! @careerprinciples

I've used all the features in 1 2 4 8 & 9

Very useful video. Thanks a lot.

Wild intern...LOL

can you give me the name of it

bro what type excel do you use?

All I can say is a heartfelt thank you. I wish I could pay in INR for your courses.

I finally know how to do macros... amazing!

Great! Do you also have a video where you explain the INDIRECT function in combination with het MATCH function?

Amazing excel trick taught by you thank you so much

It's simple ....for a mis executive ....hard level ... still in SQL

Great tutorial. Thank you. I always have issues with the Sparklines as it's always greyed out on the sheet I need it at, but I can access it on a new sheet. Does anyone have a tip?

Level 1

I thought text to columns was level 1... there were some I didn't know, like the naming columns. Good tips though.

If you are simply recording a macro, use the status bar and not the developer tab.

Your videos are really good!! best ones so far I have seen. Grat format of presentation and tone of voice! =) Thank you

Expert😌

Thanks for all the lessons you provide. Im prepareing for interviews in finance and your videos are very helpful. I knew most of the 4 and 5 stars tips but all of them were very helpful. I was wondering if you can do conditional formating with the sparklines in order to change their color depending on if the trend is upward or downward. I cant check it myself because im using excel web and it doesnt support sparklines.

In my excel stock function is not there under data tab .
Can you help me in that?

I guess I'm not even level 1

Trend lines 👍🏻👍🏻👍🏻👍🏻👍🏻 thank you

Wasn’t that daily average not weekly average ???

I can't download the excel file. Can you help at all?

Level 6: Finding out about Power Query felt like I blew open Excel's 4th wall and spilled out into a new world of potential

I knew 9 out of 10. However, I am very pleased to learn about flash fill. So thank you 🙂

the tone and control of ur voice says "I know my sNice tutorialt!". Good stuff buddy.

Loved it

Hi there, is it possible to make a macro dynamic? For example I have weekly sales and stock which I extract in an excel sheet on a weekly basis and calculate weekly sell thru. I want to be able to do that next week for this week's data; next week. How do I record this?

It's worth subscribing to your channel. I learn a lot... 🙏

i am unable to download the excel sheet from any one of your videos from the link provided, is anyone else having the same problem?

When it comes to investing, I'm so ignorant about it, I hereby ask; What's your say or thought for anyone with over $20k looking for the best ways to make good returns off it? I will appreciate any help here on how to do this

Brilliant Thank you

Know what Excell is about, used it for some project years ago and I was amazed by what it can do. Right now my Excell "skill" is below sea level 😅

where are the expert tricks?
these tricks a beginner know

Why use split with freeze panes? Can’t you just select the top 2 rows and hit freeze panes?

The split to freeze panes is much harder than the easy way. Just choose the cell below the row and to the right of the column you want to freeze. Select freeze panes and you are good to go!

I got 9/10 and trust me, I DO NOT even consider myself expert level. I've seen wizards do very simple stuff

Your video boosted my confidence. Never knew I am an expert 😂

Great tips, learnt many new things

I would say all those would be at most a 3. 4/5 would be better suited for power query, m functions, dax formulas, and power pivot.

WOW!!!

Sparklines! I always thought it was just a line graph! This is so useful!

What version of Excel do we need to access the "Data Types" feature? Thanks.

It's the best thing i've ever seen!