Dear All,
I do have one weakness i.e I am not good in excel and now I want to convert it in to my strong points.
So,requesting you all,kindly help me out to be excel in excel,if possible pls help me to learn from basic.
Eagerly waiting for your replies.
Shweta Singh

From India, Hyderabad
Hello Shweta Singh,
To be good in Excel is a relative term.
It has plenty of features.
Accountants and Engineers use it a great deal.
You have not given your background.
The best way would be to practice and learn theory.
Again practice with the new learnings.
Go on repeating the cycles.
I have attached one small guide.
You can down load plenty of material from Related Material and
Article Picks that are in the right side of this message
V.Raghunathan .................................................. .. Navi Mumbai

From India

Attached Files
File Type: xls XL Shortcut keys.xls (54.0 KB, 3249 views)

Hi Shweta,
Other than the normal functions what we are using in microsoft office, the main feature of excel that made excel a very useful and essential part of our official work is it allow us sort, organise and manipulate data using some formulas and fucntions.
Adding some files, hope it will be helpfull for you.

From India, Calcutta

Attached Files
File Type: xls Excel-Formulae.xls (1.09 MB, 3601 views)
File Type: xls Excel's Shortcut .xls (55.0 KB, 2588 views)

Dear Mr.Raghunathan,
I have done BSc(Physics) and then completed Master In Personnel Management & have been working as HR Generalist since 2.5 years,thanks for sharing the required formulas.
Dear Santhosh,
Thanks for sharing the specified formulas,but to be very honest to myself,I would want to give 4 out 10 in excel,although I have started working on the formulas but still it's my kind request to all pls help me out to convert my weakest point into strongest point.
Shweta Singh

From India, Hyderabad
Hi Shweta,
Please find attached a copy of MS excel Formulas that will help you to be an expert in MS excel. Just for your information, the best way to learn about a software is to play with do things on your own and there you are everything on your finger tips just try this out.
Kind regards

From Fiji, Suva

Attached Files
File Type: xls MS Excel Formulas.xls (2.42 MB, 2178 views)

Hello Shweta Singh,
You have now quite a few Xl attachments in the above postings
that will help you to understand the theoretical aspects.
Go on practising.
If your job does not offer much scope try to help out a colleague
of yours who has a lot of jobs on Xl.
Learn and Practice is the slogan to be remembered and followed.
V.Raghunathan..................................... ............................... Navi Mumbai

From India
dear swetha ji,
Practice is the only thing through which you can master in excel. It is one of the best platform provided by Microsoft. You can note my email id. Most of the time i am available in gtalk I am ready to help you whenever you required. Try yourself is the best way to learn. Best Wishes.

From United Arab Emirates, Dubai
dear child [ dont mind my calling u so]
excell is a beautiful tool . u will enjoy it for your hr work
long time back i sent a dashboard in reply to a query on manpwer data .
i can teach you step by step the use of excell once you are serious . it will be free no charges except your sincere commitment .
pl contact me at <>
complicated formulas are not my piece of cake but all hr functions we can go through ,
dr ram

From India, Indore
Dear All,
It is a great platform where we share small things and help each other. Instead of putiing an another enquiry, I would also like to have help of Excel Experts that How we can remove formulas after completion of the job from a complete work Book at once have 50 work sheet. Secondly I would like to collecpse all the work sheets on one work sheet. Are there any way to perform these functions.
Thanks & Regards.

From India, Jodhpur
dear mr jain

i see tqo queries in ur post

i will try and answer one by one

remove the formulas

once you have finished with a formula and got your answer or answers , select the answers and do a copy [ctrl + C]

the answers will get covered by moving ants box

select a new cell to paste data


click on "values"

and then click on paste or ctrl +v

the new cells will have only the values and not the formula

now if want u can delete the earlier obtained results [ if u dont want to do more calcualtions based on them]

the values u have pasted will be numeric and will not be linked to the formula or earlier cells

any correction you do to the base data will not affect the value pasted as they are no more interlinked .

merging work sheets

the only way to merge worksheets into one work sheet is to select all copy and paste in the sheet u want to retain .

i advice select a cell easy to remember so that u can do ctrl+g and reach there when ever u want .

u can also format the cells and use different color for each work sheet u have copied and pasted in you master sheet


dr ram

From India, Indore

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.

Please Login To Add Reply

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2021 CiteHR.Comô

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server