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

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
5th January 2013 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
6th January 2013 From India

Attached Files
Membership is required for download. Create An Account First
File Type: xls XL Shortcut keys.xls (54.0 KB, 3156 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.
6th January 2013 From India, Calcutta

Attached Files
Membership is required for download. Create An Account First
File Type: xls Excel-Formulae.xls (1.09 MB, 3120 views)
File Type: xls Excel's Shortcut .xls (55.0 KB, 2282 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
6th January 2013 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
Ashnil
7th January 2013 From Fiji, Suva

Attached Files
Membership is required for download. Create An Account First
File Type: xls MS Excel Formulas.xls (2.42 MB, 2092 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
7th January 2013 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.
7th January 2013 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 <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
7th January 2013 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.
7th January 2013 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
7th January 2013 From India, Indore
btw mr jain

if u are good at programming , u may draw energy from the following solution . not me i am a mgt guy and not an it guy

I have an Excel (2007) Spreadsheet that has 173 worksheets (tabs) with 43 rows each. I need to combine them all into one worksheet. How? (yes, I could cut&paste each sheet, but I'm not into doing that 173 times.

4 years ago Report Abuse



PCS_Help

Best Answer - Chosen by Voters

You are not stuck.

- From your spreadsheet, press Alt-F11 to get to the Visual Basic Editor.

- Select "Insert", "Module".

- Paste the following code into your module.

Sub Combine()

'

' Developed by PCS_Help

' For immediate help goto PCS_Help - CrossLoop Expert in Most problems. Windows XP, Server, Vista, Office, Word, Excel, Access, Outlook, Powerpoint, Publisher, VBA, Quickbooks, ... <link updated to site home> ( Search On Cite | Search On Google )

'

Dim NumSheets As Integer

Dim NumRows As Integer

' Change the value of NumSheets to equal the number of sheets you wish to combine

NumSheets = 173

' Change the value of NumRows to equal the number of rows in each sheet

NumRows = 43

Worksheets(1).Select

Sheets.Add

ActiveSheet.Name = "Consolidated"

For X = 1 To NumSheets

Worksheets(X + 1).Select

Rows("1:" & NumRows).Select

Selection.Copy

Worksheets("Consolidated").Select

ActiveSheet.Paste

Selection.End(xlDown).Select

ActiveCell.Offset(1, 0).Select

Worksheets(X + 1).Select

Range("A1").Select

Next X

Worksheets("Consolidated").Select

Range("A1").Select

End Sub

- Edit the number of sheets and number of rows if required

- Click on the green play (Run) button

- Close the Visual Basic Editor

You are done!

BEST OF LUCK

BLESSINGS

DR RAM
7th January 2013 From India, Indore
Dear senoirs, this excel detail is very useful for me so, i thank all of you and share this types of detail because it will be helpful to others for further knowledgs.
7th January 2013 From India, Rajkot
Dear Dr Ram
Thanks for your prompt reply.
Kindly understand my need and advise accordingly. I am using so many work Books of Excel and each work book are having several number of sheets. If I shall use your technique to eleiminate the formula I have to go sheet by sheet and it will be troublesome task for me.
I want that if there is any command or short cut by which I can remove the formulas of entire work book of several sheets at once, it will be a great help to me.
Similary if I copy each sheet and paste on one sheet it again troublesome and time taking. If there is any procedure by which I can bring a work Book of 50 sheets on one single sheet (merging all) than it will be great relief.
I hope I shall get some solution.
Regards.
7th January 2013 From India, Jodhpur
These things are amazing ...i m working in a manufacturing company can i get tds,vat,insurance,etc help
7th January 2013 From India, Pune
Greeting of the Day................
I got many appriciations on this post, but the fact is I got all these stuffs from CiteHR itself shared by fellow mambers or some seniors. So guys first use the Research option above before creating a new thread. You may find so many discussions on your required query.
Have a nice day...........
8th January 2013 From India, Calcutta
Combining several sheets can be done by using VBA as suggested by Dr Ram sir.It will be always useful, as far as data structure is concerned,it should be a single table, no merged cells, data fragmented (means much legands). This table may be a payroll, PF statement, leave record or anything. Will this kind of simple single table data structure in EXCEL you can use fucntions, VBAs, pivots and many more.
8th January 2013 From India, Kolkata
Dear All, Its really great for providing useful information to all on MS Excel, not only for shwetha it will help to all the members who are using in cite HR. Thank you Regards Praveena
11th January 2013 From India
Dear V Ramanan Sir, Thank you so much for your support,have sent you the request on gtalk,kindly do accept it. Dear ALL, Thanks alot for sharing your valuable thoughts to me. Regards, Shweta Singh
12th January 2013 From India, Hyderabad
hi seniors..........i have a doubt on VLOOKUP i.e., by using VLOOKUP how to copy whole sheet1 to sheet2 i mean paste same sheet1 data in sheet2........... thanking you Regards Yaswanth
22nd January 2013 From India, Hyderabad
DEAR YESHWANT
god bless u
pl do not confuse the learning
always be simple
go to the sheet number
rt click
click copy
and place the sheet where ever u want and click
ur whole sheet is copied to a new sheet
rename it the way u like
NOW FOR LOOK UP
see the link
look up is required only for comparison to given values
Microsoft Excel VLOOKUP Tutorial - YouTube
pl keep life and learning very simple
blessings
dr ram
p.s when u click move or copy
click on make a copy check box
23rd January 2013 From India, Indore
Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™