Very cool tips Chandoo! Every time you end up enriching your viewers with something practical and useful! Keep up the great work! 😊👍

@chandoo_

2 жыл бұрын

Thanks Vijay 😀

You're the best one in explaining Excel so far, Thanks a million!

@chandoo_

2 жыл бұрын

You're very welcome!

This was great. Super helpful to show in incremental steps

I am a mis Executive In a organization. After See your amazing Videos now I am developing My Skills Into Data Analyst.. ❣️❣️

@chandoo_

2 жыл бұрын

Wow.. More power to you Ankit...

you are really amazing and down to earth and humble guy

Super! Thank you for sharing!

Loaded with value. Thanks for your kind help. Regards.

Thanks for the data bar tip! 📊🙂

Best Excel teacher. You give example data sets to download as well as show exactly how it is done. Amazing!!!!!. You make me love excel more and more

@chandoo_

2 жыл бұрын

You are welcome!

Brilliant as always! Thank you.

@chandoo_

2 жыл бұрын

My pleasure!

Highly overwhelmed getting in touch with you. Wishing for your greater progress.

You never fail to amaze me. Just too short of time right now but as soon as I am a bit available, I would like to sign up for your excel class. Thanks for the wonderful work

@chandoo_

2 жыл бұрын

Thanks Sarika... Sure. my course is ready whenever you are...

Lovely Tips!

Excellent, excellent, excellent! You are a wonderful teacher!

@chandoo_

2 жыл бұрын

Thank you! 😃

This is great. Thank you

very informative video!

Splendid video

Great video! I loved the content and the engaging and easy presentation as well!!!

@chandoo_

2 жыл бұрын

Glad you enjoyed it!

Excellent teaching Chandoo. I enjoy learning Excel. Learned a few new things today. 🙏

Great CF tips! Thanks Chandoo. Thumbs up!!

@chandoo_

2 жыл бұрын

You are welcome Wayne... 😀😀😀

Chandoo my man, real respect for you. Hi! From London.

Very useful ❤

Thanks for video.

GOOD STUFF!

These were great tips, thank you Chandoo!

@chandoo_

2 жыл бұрын

Glad you like them Chris...

Amazing

🤘Rock On! Thanks for a great lesson!

@chandoo_

2 жыл бұрын

😎😍😎

That makes our report look "yummy". LOL I like that.

@chandoo_

2 жыл бұрын

😎

Super to superb

very interesting sir great explanation want to learn more excel tips from u sir hope u share more videos 😊

always great, always you present new Technics

@chandoo_

2 жыл бұрын

You are welcome Hazem...

As usual awesome...

@chandoo_

2 жыл бұрын

Thank you so much 😀

Really Awesome 😀.... I need this one on Conditional formatting... Love to hear pop up music🎵 coming in during this video... Nicely arranged video... Thank you ...Sir..👍

@ramakumarguntamadugu1299

2 жыл бұрын

yes, 👌that pop up music is fun😊

@chandoo_

2 жыл бұрын

Glad to *hear* that... 😎

Thanks

Thank you Chandoo. That was great. 👌

@chandoo_

2 жыл бұрын

Glad you liked it!

Wonderful as Always. A new Subscriber

@chandoo_

2 жыл бұрын

Welcome aboard Karim...

great tip to get more attention from dashboard audience... thank you..👍👌

@chandoo_

2 жыл бұрын

Glad it was helpful!

This is awesome Sir..! Could you do an Vedio on Interview Qestions in Excel? .....That helps a lot Sir

@chandoo_

2 жыл бұрын

You are welcome Shashank.. I have an *exciting* video coming up next week. Stay tuned...

Hi, how can I hide rows based on a cell value specifically a drop down menu, using excel 2016. Using conditional formatting as an alternate to macros but my version does not have the "hide" option in the "font" tab. Thanks

hi chandoo, i tried highlighting the top 3 sales using sample document provided. I used the same $B2>150000 ( data starts from 2nd cell, B column) but top 3 data is not highlighted? Can you tell me where I went wrong.

haha, I thought I knew conditional formatting, then I watched this :) Nice one Chandoo!

@chandoo_

2 жыл бұрын

Wow. Thanks Danzi...

Hi Chandoo !! A question regarding applying conditional formatting in a pivot with multiple slicers. I want a particular cell (Say D4) to show the text in Green when the value is > 0 when we select "Debit total" as the slicer option. However, the same cell should show red show values My question: Can we apply conditional formatting in this same cell to show the text as Green when "debit total" slicer is selected and as Red when "credit total" slicer is selected? Please do note that the range where the conditional formatting needs to be applied is a part of a pivot table. Apologies for the lengthy question !!

Nice Job 👍. Keep it up

@chandoo_

2 жыл бұрын

Thanks 😀

Great Tutorial.....is there a way of formatting the font size and font type?

Helping us to improve as always, thank you.

@chandoo_

2 жыл бұрын

That is my mission really. Helping one million people every month...

Sir my company is using one cash flow excel sheet and once i edit numbers or any data it showing a differennt formate which means i need to make each and every one need to format painter . My question is how to set the whole excel sheet in particular format? If i edit any thing i need it same format before.

Thank you sir.

@chandoo_

2 жыл бұрын

Most welcome

Thank you Chandoo. Very informative. Is there a way to compare the values of 2 two rows with each other with conditional formatting to highlight the ones that do not meet the condition e.g. If the customer's days are larger than the supplier's days for a specific month, it should be highlighted. I know I can apply this condition for each month separately, but to do the conditional formating with one formula for the complete row is the preference. Thank you

Nice trick for rank avg

@chandoo_

2 жыл бұрын

You are welcome Mutlunun...

How to format those cells whose sum constitute defined % of the total sum? .

Great

@chandoo_

2 жыл бұрын

Thank you :)

please how can i extract a set of given data from a group data, all having unique id number?

Hi how we can find top sales figure multiple department in each articles (dept /subdept/articles)

Thanks Sir 🙏💕 But what's difference between Excel n Adv.Excel; Requesting Kindly share your knowledge through the Videos

I want data depending on cell status i have Active and Closed. So i have data in A,B and in C i have Active or Closed, So If i select Closed then data in A,B should add up and be displayed in column D, how can we do it?

How to exclude cells with zero or no values in top bottom rules? Thank you!

Nice sir can u please also make videos on SAP

Hi Chandoo, I have a question for you, I want to apply [Color10]0.0"▲";[Red]-0.0"▼"; plus #,,.00 formatting to a single cell how can I do that?

How to do conditional use formatting if for example a vendor has weekly limit of Invoice posting limit how to highlights on which week the limit got exceeded

You could have kept the rule of top 3 then added a new rule to the adjacent column which format green based on the colour of your D column. So if it was a top 3 then the other cells in that row will go green picking up the colour change in column D

@chandoo_

2 жыл бұрын

Hmm.. not sure you can do that. There is no "CF" rule that can change color based on the color of other cells (not yet). Or am I missing something?

could uoyplease make a video on latitude and longitude in excel

Can use large(cell,3) function to sweet three large cells value.

@chandoo_

2 жыл бұрын

Great tip 😎

@riteshzope3672

2 жыл бұрын

@@chandoo_ thanks 🙏🏻 Please make more videos related to advanced power bi

@m.raedallulu4166

2 жыл бұрын

Excellent! I was to write the same idea!

Hope you can assist. I have data set and the first column is Planning date. i want to conditional format the entire row with colour fill if a date is inserted, if blank nothing happens. Then there is another column Delivered Date. Once a date is entered there is need to over write the Planning date with colour green (entire row) . Please advise if you can advise how this is done, been battling for a while now to get this right. Many thanks

@chandoo_

5 ай бұрын

Sure. Assuming your planning date is cell A2, delivery date is in cell F2, select all your data (excluding headers) add a new conditional formatting, formula rule type the rule as =$A2"" and set formatting as red color. Now add one more rule type the rule as =$F2"" and set the formatting as green color This should give you the result you want. If you notice some inconsistencies, go to manage rules and make sure that the rules are in the order of red first then green (so green will always overwrite red).

Hello Chandoo, I am big fan of your work. I wanted to know is there any way to alter the values in formula bar? Eg. I input 10,00,000. Then I convert that value as '1' through some custom formatting as my client wanted to see this value as scaled. Now his requirement is they wanted to see '1' in formula bar as well. Is there any way to show such conversion in formula bar? If there any, please suggest me. Thank you.

@chandoo_

2 жыл бұрын

Thanks Suraj... As far as I know, this is not possible. Why not hide the formula bar instead? You can do it from the "View ribbon"

@surajtharali1273

2 жыл бұрын

@@chandoo_ Thank you Chandoo. I will hide the formula bar instead.👍

hey chandoko your videos is very nice but your editing is also nice i want to know how you edit this effect on camtasia 3:30

@chandoo_

2 жыл бұрын

Thanks Kartavya... Here is a brief outline of that edit. 1) Duplicate the screen recording layer and place it on top the original (at exact frame) 2) Crop the second layer (holding down ALT) to just the formula box 3) Add custom animation to the second layer and zoom it up. 4) Add any shadow / highlight effect if needed 5) Restore the animation once the emphasis is over. Hope that helps.

I need excel training

Power BI kaha say milay ga

@chandoo_

2 жыл бұрын

Download it from powerbi website.. search it up.

Sir kindly reply my query regarding move cammand of cmd.

Conditional formatting.. the Devil’s tool….

Sorry your formatting is really not pleasant. Won't work for business setting

@chandoo_

2 жыл бұрын

Feel free to format in whatever way works for you... There is no "RIGHT" way to do these things.

Another formula for top 3: =COUNTIF($B$4:$B$13,">" & $D4) < 3

@chandoo_

2 жыл бұрын

Goodone.. I think the first ref. should be $D$4:$D$13...

You're the best one in explaining Excel so far, Thanks a million!