Ad Free CAclubindia and Daily Updates on your Mobile. Subscribe Now!

Ask Anything on Excel, Word & Powerpoint

Abhishek Agarwal (EXCEL EXPERT) (92 Points)

26 May 2008

Hi,

Friends u can ask me any queries on Excel . i will be more than willing to help and share knowledge in Excel , Word & Powerpoint.

We CAs are very poor in powerpoint skills and excel charting .

I know a lot people know a great deal about excel , but still I can add a little and also learn a lot from other guys.

As for example i have just a simple formulla to calculate weekly shares closing prices. Thou knowledge of Excel macros is good , but i prefer to use excel formullas as it easier to understand and faster to work with .

regards

CA. Abhishek Agarwal

9911044625

Faridabad

Reply
Follow
Share

62 Replies

Swathi (Faculty) (186 Points)
Replied 26 May 2008

Its a very good idea to improve the subject by sharing. Its useful for many students.

Ms-Word,Excel,PPT are the basics for one and all. If the CA students have these basics, then lot of their work gets simple and fast. Simply saying, it makes things easier.

I am a faculty and planning to start MS-Office classes for CA students at Vidyanagar, Hyderabad using a projector.

Anyone can register for this. ONLY for CA students.

Upgrade to CAclubindia Pro. Subscribe Now!

Swathy (Senior Executive Business Consulting Services) (0 Points)
Replied 27 May 2008

Can I've the formula and a pricise explanation of its usage

R.V.RAO (SERVICE) (4125 Points)
Replied 27 May 2008

HI ABHISHEKH,THANKS FOR THE OFFER TO HELP. AM GLAD THAT PROF.LIKE CAs COME FORWARD TOSHARE AND HELP. IT IS A RARE GESTURE.HATS OFF.KEEP IT UP.KNOWLEDGE ONLY GROWS BY SHARING NOT BY RETENTION WITHIN ONE SELF. YOU SEEM TO KNOW THIS SECRET OF OUR VEDIC SCHOLARS. R.V.RAO

shashidharraju (Manager (Finance)) (20 Points)
Replied 27 May 2008

Hi,

I am shashidhar, working for an MNC, Hyderabad. I want to attend the classes on MS OFFICE.. can you please provide me your contact details and the dates of classes.

Regards,

Shashidhar

Nagaraju Pogula (Partner) (175 Points)
Replied 27 May 2008

Hi,

How to copy and paste the data with out hidden cells data.

Upgrade to CAclubindia Pro. Subscribe Now!

Abhishek Agarwal (EXCEL EXPERT) (92 Points)
Replied 27 May 2008

Hi Nagaraju

u have to use goto command

Select the area from where u want the data to be copied from

( If u do not select the data in advance , excel will select all the visible cells in the sheet and this will make ur file very heavy when u will paste it )

On the edit menu click goto (Ctrl + G)

then click specials

then select visible cells

Excel will select all the visible cells only within the selection u have selected above (No hidden Cells will be selected )

Just copy (Ctrl + C) it and paste it (Ctrl + V) where ever u Want .

regards

Abhishek

Abhishek Agarwal (EXCEL EXPERT) (92 Points)
Replied 27 May 2008

Dear Swathy ,

Excel is a vast software , It will be better that start with the areas in which u are working and are of daily use for u .

Like i am not very good in those scientific & Maths & Static formullas, since i dont use them at all.

U have to specify the area in which u r working and also some examples of excel data u work , then only it will be fruitful for u to get the formullas .

u can email me ur files at my email id : abhishekagarwalca @ yahoo.co.in

Regards

Abhishek

Delhi

Azmathullah Khan (Accounts Manager) (1386 Points)
Replied 27 May 2008

Do u have any file in excel please send at azmath @ springfieldsschool.com

Nagaraju Pogula (Partner) (175 Points)
Replied 28 May 2008

I work on no. of sheets simultaneously. Some times when i try to do any editing/ formatting, then message box appearing with info of ”Too many different cell formats"

Please advise me.

Upgrade to CAclubindia Pro. Subscribe Now!

Nagaraju Pogula (Partner) (175 Points)
Replied 28 May 2008

and one more thing, is there any other better/alternative formula for "vlookup" which identifies the data even if some or part of the text matches...

(Guest)

Hi Abhishek,

I want to know that if I mentioned date (25-05-2008) in other cell it will shows as days of the month in 2008 (31) like (15/02/2008)= (29) or (15/02/2007)= (28)

You can mail me on my email add raj_eshgoyal @ yahoo.co.in

Please advise me

Thanks & regards

Rajesh