Singh.Shweta
13

Human Resourse
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

From India, Hyderabad
V.Raghunathan
1317

Process Industry Consultant / Soft Skill Specialist
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, 3229 views)

Santosh_Nayak
87

Asst. Manager HR in a Construction MNC
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, 3528 views)
File Type: xls Excel's Shortcut .xls (55.0 KB, 2542 views)

Singh.Shweta
13

Human Resourse
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

From India, Hyderabad
ashnilchand14
11

Trainee
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

From Fiji, Suva

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

V.Raghunathan
1317

Process Industry Consultant / Soft Skill Specialist
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

From India
sreeniknr
4

Administration Manager
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 <[email protected]>
complicated formulas are not my piece of cake but all hr functions we can go through ,
READY STEADY CLICK
blessings
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

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

From India, Indore

This discussion thread is old and is closed for new comments. If you want to continue this discussion or have a follow up question, please post a new thread. 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 @ 2021 Cite.Co™