Advanced Excel: How Can These Details Help Us Improve Our Skills?

Hi all,

Hope all of you are doing great!

I am herewith posting Advanced Excel details. It will be useful for all of us.

Awaiting your feedback :icon1:

Regards,
Nithya

Hi Nithya,

For some reason, the PDF file is not opening. It states that it is damaged and cannot be repaired. It does seem that others could view the same. Can you please check and email the same again to me at [Login to view]?

Rgds,
Pramod Naik

Hi,

Please tell me about an Excel problem. How can I protect a single cell in Excel or unhide a formula in Excel?

Hello Everybody,

I am facing a problem withdrawing my PF from my old company. Can you please suggest ways for me to withdraw it? The concerned person is not signing the PF form. Is it possible to withdraw the amount in any other way?

Thanks & Regards,
Shekhar Kulkarni :)

Hello,

Actually, I am really bad with Excel, and I really want to improve in this area. Can you help me out with this?

Dear Nithya Sanjeev Krishna,

Thank you very much. Up to now, I thought that I am using a lot of options, but after observing your post XL details, I came to know that there is still a lot more to learn.

Thank you very much.

Kiran Kumar :)

Hi,

Could somebody please send me the Karnataka VAT Ready Reckoner for the A.Y 2009-2010?

Somashekhar.N
9008665640

Can anybody tell me how we can insert a column after IV?

In an Excel sheet, the last column is IV, but somebody told me we can insert a column after IV and up to ZZ. However, I don't know how to do this. Does anybody know about it?

Thanks,
Sahil

Hi Nithya,

It is really excellent information on Excel, but it would be more useful if there were some examples of the formulas in an Excel sheet. However, the Excel shortcuts are truly extraordinary.

With regards,
Cleopetra

Hi Nithya,

Thank you very much for your effort. I am quite confused about the VLOOKUP and HLOOKUP functions as I am looking to become an expert in using them, but I am currently unable to do so. These functions are essential for HR professionals.

Cheers,
Jeeva