V.Raghunathan
Process Industry Consultant / Soft Skill
Santosh_Nayak
Asst. Manager Hr In A Construction Mnc
Singh.Shweta
Human Resourse
Sreeniknr
Administration Manager
Manojsoni78
Senior Manager
Pr@veena
Aditya Birla Finance Ltd - Bussienss Supprot
Yaswanth24
Hr Executive
+3 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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.
Regards,
Shweta Singh

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


Attached Files
File Type: xls XL Shortcut keys.xls (54.0 KB, 3200 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.


Attached Files
File Type: xls Excel-Formulae.xls (1.09 MB, 3351 views)
File Type: xls Excel's Shortcut .xls (55.0 KB, 2436 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.
Regards,
Shweta Singh

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
Ashnil


Attached Files
File Type: xls MS Excel Formulas.xls (2.42 MB, 2137 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.
regards,
V.Raghunathan..................................... ............................... Navi Mumbai

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.

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 <rhinoramanan@gmail.com>
complicated formulas are not my piece of cake but all hr functions we can go through ,
READY STEADY CLICK
blessings
dr ram

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.

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

go to PASTE SPECIAL

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

blessings

dr ram


This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™