Thanks Chandoo! Special thanks for encouraging people not to merge cells but instead to use 'center across selection'. Dealing with someone's merged cells can be very annoying!

You are an Excel wizard. You make dumb people like me who do not know Excel (rather little scared of it) fall in love with it. Thanks a lot.

Professor Chandoo, you are super fantastic ! Simple and daily options shown in a easy way! ...Booohhmmm !

The best was the "like" button.. :-)

Love your videos❤

Super video Chandoo!

Quick & Detailed Refresher . Thank you so much Sir.

Super as always

Always valuable

Shifting the comma does NOT change the precision of the DATA but only how it looks in the VIEW. This causes a lot of problems when you read Excel data in another program. In that case ALWAYS use the proper ROUND function.

Thank you sir

Chandoo, what is that takes vertical cells text to sort without merging the cells

Hi nice video very informative, could you please upload a video on how to use vlookup pictures in excel using the value output from vlookup and not using dropdown list. Thank you

Thank you, Suddenly surprised to see teaching basics after teaching depth of Excel!!

@chandoo_

2 ай бұрын

You are welcome. As we have a lot of new learners on the channel, I want to help them get most out of it too.

@rtshort

2 ай бұрын

I was going to say that's a great beginner course. Very informative to someone new to Excel.

You are the funniest instructor, you are soooo good . Elena

A Very helpful and frequently used Home Ribbon Buttons contented in this video, Thank you Sir, here I request please make like this video on DATA Tab also, if it already exists, please share the video link, and Thank you again Sir...🌹👍❤📝

Thank you for your video! Your are the excel master! Just a short comment about inserting/deleting a column or a row: I position my cursor on the Column letter(s) or Row number(s) that I want to insert/delete and use Ctrl+ (control plus) to add a row or a column and Ctrl- (control minus) to delete them.

@chandoo_

Ай бұрын

Great tip!

Can someone please suggest will macbook air m1 would be useful for a finance professional like me or should I go with any windows laptop ? I use mostly Excel SQL & Power BI.

@redradoa

Ай бұрын

No power BI on Mac

Thank you very much for the video. I tried to change the cell format of decimal value from text to number but not working.I tried in different ways by checking in th Google but no use.Not sure how to change, please let me know if you could help me.

@chandoo_

2 ай бұрын

Here is one way to do it. Select any blank cell in your workbook and copy it (CTRL C) Select all the text sells and go to Paste Special (CTRL ALT V) Now select "ADD" option to add the blank cell to your text data. Your text values become numbers 💥

I use the like button alot thank youu 😊

@chandoo_

2 ай бұрын

Thanks for liking

i miss when center across defaulted to did not merge cells.

When are you mailing the free ebook Excel Tips?

@chandoo_

2 ай бұрын

You should get it automatically. Just enter your email address and confirm it. Go here - chandoo.org/wp/subscribe/

👍🏻

Initially i thought it was basic , i know this , but there is always something new

Excel pushpa ni avva thaggedhe le😊

How a fresher can do certification in EXCEL data visualisation

I'm one of them who is familiar with your channel

answer the question: chandoo, I want you to look into this problem. I want to find & replace multiple entries at a single click. example: let's say in C2, C3, C4 the entries are IT Trainer, SoftSkill Trainer, Technical Trainer. I want to find & replace them all into employees in a single operation. Can I do this? in find & replace. Give me a solution to it. Thankyou

@chandoo_

Ай бұрын

You can't do this easily unless you resort to either formulas / powerquery or VBA. A simple manual solution is to first Filter your table to the rows you need to replace Then select all the cells Now type "Employee" in one cell and press CTRL+ENTER to replace the value in all visible cells.

@ranjan4495

Ай бұрын

@@chandoo_ a special thankyou for your timely response. If it is in a) formulas b) powerquery any video available at your end or any support, please let me know.

@chandoo_

Ай бұрын

See these: Power Query: kzread.info/dash/bejne/i4t1r8Oao8KXcbg.html Formulas: kzread.info/dash/bejne/nYiop6t-Z9aTpJc.html

Merge across should be made the default. Merge & Centre is awful.

first