Question about Microsoft Excel 2007 Home and Student Edition for PC

1 Answer

Excel sheet help

I am a HR recruiter. I have data of people who come for interview, some are selected some are rejected, I want to prepare in the excel sheet. How many people have come for the interview...and also how many days are left after that...i mean I;m working on deadlines too...also the rejection details....y rejected etc...can I do it in a easier way than puttin in manually?
Diff dept Diff positions Deadlines CV accpeted/Rejected Interview Accepted /Rejected Reason etc
THOSE ARE THE PROBABLE OPTIONS

Posted by on

Ad

1 Answer

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Microsoft Master
  • 1,996 Answers

You're covering a lot of ground there, but you should be able to use sorting and group selection, then cut and paste from your other programs, as well as keyboard shortcuts to save some time. There may even be some addins that will help you to organize the reports...but nothing can save you from data entry. There's definitely a steep learning curve involved...
It may be helpful for you to organize the logic and Hierarchy of the spreadsheet by hand on paper before you attempt to set it up on your system.
Google Excel tips and you'll find a plethora of info online to help you set it up right...(here's one) (or two)

I hope this information allows you to resolve this issue. If you need further assistance, please post back with a comment to this thread.
If I've managed to answer your question or solve a problem, please take just a moment to rate this post....thanks!

Posted on Jul 22, 2009

Ad

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Goodluck!

Posted on Jan 02, 2017

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

I want to save and retrieve some data from html page to excel. how to do this


remosofts,

  1. In a blank Excel sheet (or blank tab), click on the cell where you want the html page to begin placing data.
  2. From the top menu, select [Data] and choose [Get External Data] from the drop-down menu.
  3. Select [New web query] (view other options for future queries)
  4. A pop-up screen will have a few options, of course enter the html page location in the first box (Web address)
  5. You probably want to also select *The entire page (instead of only 'tables' default)
  6. Click [OK] and look at the data in your Excel sheet!
  7. You may want to adjust the options in future data retrievals.
Thanks for choosing FixYa!
-Gort.

Oct 11, 2010 | Microsoft Office Standard for PC

3 Answers

Export the data from excel to tally


  1. make a sale entry in tally
  2. Export the voucher from tally in xml format (this is to give u how the xml looks)
  3. Open the excel file where all the data is ther.
  4. open a word file, so that we can prepare the xml for mutiple vouchers. For this we will use Mail Merge facility
  5. in the XML which we did in step two, copy the data from "<TALLYMESSAGE xmlns:UDF="TallyUDF">" till the </TALLYMESSAGE>
  6. Now open the word file, go to mail merger, select the fields which needs to be changed, that is the Debtors and the amount (for normal sale entries) which should change for every sale voucher.
  7. create the mail merge.
  8. copy the data what you got in word file to a note pad and name it as sample.
  9. open again the step 2 - copy data from " <ENVELOPE> to <REQUESTDATA>" and paste in the begining of the notepad sample
  10. go the end of the notepad sample and copy the data from first file -"step 2" from " </REQUESTDATA> to </ENVELOPE>" and save the file
  11. Open tally
  12. go to import vocuhers
  13. specify the path of the notepad sample and yes ur data got imported.

Apr 21, 2010 | Microsoft Windows XP Professional

3 Answers

Export tally data to excel


tally data to excel converting . i have some data export to excel but no excel formating you have some tally data to excel spred sheet software

Aug 27, 2009 | Tally T2245 Matrix Printer

1 Answer

How do you print envelopes?


More information is required so I will only assume you are using Excel as a database. Excel is a spread sheet program used by accountants or for mathematical formulas and ledgers. Access is the Database program, however, Excel has functions which is faster to sort and work with address, phone number, zip codes. I will confess, I use Excel as Database because it is quick and easy. I do not know what version of Excel you are using so I will describe it from Office 2007. From Excel make sure you have headers above each column i.e. First Name in Cell A1 Last Name in Cell B1 Address in Cell C1 ect.

Make sure your data is correct and case sensitive as you would like it. If you want zip+4 select the Colum and right click to format the cells using special and select Zip or Zip+4.
It is easiest to use Microsoft Word for the next step rather than format the cells, add page breaks, and customize the print size.
Save your document as an Excel document where you can find it to import it into Word.
Open word and select Mailings then Start Mail Merge and Step by Step Mail Merge.
Select Envelope and next. Select envelope options to change envelope size, font and print options.
Click on Next Select recipients.
Click on browse under select an existing list.
Select the Excel file with your address information.
From the Select Table check the First row of data contains column headers.
Click on the OK buton.
Arrange your envelope then Preview it and your good to go.
If you have an older version of word selects Tools and click on Mail Merge.
Select Get Data.
Pull down Excel for document type.
Select entire Spread Sheet.
Layout your document and complete the merge.
On old versions of word it may not recognize the Excel file. If this happens open the Excel file and save it as a Database File (.dbf) and it should work.
I hope this helps since I did not have enough information from your question.

Jul 15, 2009 | HP OfficeJet 6110 All-In-One InkJet...

1 Answer

I want the excel attendence sheet how to prepare with help of


here are some templates to get you started

http://office.microsoft.com/en-us/templates/CT101172771033.aspx

Feb 21, 2009 | Microsoft Excel for PC

2 Answers

Excel


Highlight the cells you want to format. Move the mouse to the highlighted area, press the right mouse button and make sure the locked option is on under the protection tab.

Make sure protect sheet is enabled. To activate it, press the review under the menu options and select protect sheet (if its on sheet) or workbook for more than one sheet.

Sep 15, 2008 | Microsoft Excel for PC

1 Answer

Want to write a code in VBA for a Chart prepared in Excel


Dear Customer,

you have not define your all details,

Plz give all details than & only than some can help you ,

so,Please mention all required details

THNX

May 08, 2008 | Computers & Internet

1 Answer

One problem in the application of excel sheet


I can make out that
You are speaking about creating a macro to take data from one constant updated cell and to put that data into another cell or form sheet.
You will need to get precise help from a programmer on this.
If you want to see a little on macros just open a sheet and checkout the help section on macros.
Some macros can take many hours to write and test.Some make take months.
hope this helps.

Jan 30, 2008 | Microsoft Windows XP Home Edition

2 Answers

Duplicacy in excel sheet


Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

Drag this formula down column F till the end of your data
Select the entire data and do an auto filter
In column F filter the data by Duplicate and delete all these rows
What remains should be unique data

Dec 19, 2007 | Computers & Internet

Not finding what you are looking for?
Microsoft Excel 2007 Home and Student Edition for PC Logo

206 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2905 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18411 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...