How To Use Excel Manage Recruit Employees?

[Guest]

Excel
Use template track and compare vacancy candidates data
Simply evaluation, "Job Candidates Data and Compare Sheet" template:
1 "candidates data", input basic data, name, address, phone, apply position
2 "candidates compare data", input detail information relate to work "job
now working", and compare with many candidates.
Download templates
Microsoft Office Online/template/staff recruit
How to do it?

Excel
Track and report HR data
Resumes received
Candidates sources
Interviewed candidates quantity
Interviewed - employment ratio
Reject reasons

Evaluate, analysis and report:
1 Employee statistic
2 Employee relation
3 Staff management ratio

How to do this?






How Can I User Word Manage Recruit Employees?



Word
Word Template
Job Application Form
Candidates track
Candidates Evaluation
Work Experience Evidence Form
Employment Confirm Letter
Employment Rejection Letter





How Can I User Outlook Manage Recruit?

Outlook
Search Outlook
Search Folder

If company have a new Manager Asistant position, I should see all email
apply this prosition, how to create a "search folder" to search email that
apply for this position in Outlook folder?

Outlook provide a library with 13 "search folders"
I can "create user define search folder"

Outlook File/New/search folder
In "search folder", roll down to "user define", click "create user define
search file folder"
Input name of the "search folder", because the position title is "Manager
Asistant", so input "Manager Asistant" in this textbox.

Click "conditions"

In "search folder", click "mail" option, input "Job Req.56" in "search text"
textbox.

So, the position advertisement require candidates must input "Job Req. 56"
in any emails about this position.

In "location" drop down list, choose "only subject words".

Click "Enter" several times.

I am doing well?

Every position can create a "search folder"

Can I also search subject line and content of email, about the
advertisement, I put some keywords in advertisements, so when then apply and
include the advertisement, the "search box " can sort these emails. And also
search for skills, education background or skill ability related key words.

How to do that?

Use outlook organize meeting, interview and email:
1 Calendar can use for interview
2 Employment officers can use email send resume and share interview response.
3 Use email quick response to employee questions and communicate with
managers.
4 Color "calendar" can highlight important items.
5 Mark emails need operate and more continue works.




How can I use Access track employment positions and candidates information?


1 Identify Users

2 Identify User Requirement
Employ Manager: candidate work experience and education background, specific
position candidates compare report.

Manager Asistant: candidate work experience and education background,
specific position candidates compare report.

Candidate: Positions details, search the jobs meet requirements and skills.

Recruit officers: list new positions, detail resumes, search candidates meet
specific positions essential requirements.

3 Identify data that need save and search: data in resume before processing;
seperate repeat group and add key; resume data, exclude items and add outside
key; multi link relations.

4 Identify useful data.

5 Identify relations between sheets, for report, query and others.

6 Complete window, report and query design


File/Outside Data/Import
File Type: Outlook.
Outlook Contact














Use Visio and PowerPoint
Create sheets and presentation files
Visio to create and share structure presentation.
For example, department manager and employee relation
PowerPoint can create Procedures, HR contact list.
How to do it?

 

[iliace]

With your list of requirements and questions, it seems like you'll
need to hire somebody to do it for you. Entirely possible,
nonetheless.

As far as Excel goes, in the past I've used it successfully to create
a table of distributions and allowances (TDA). Each position that
needs to be filled was identified with a code:

<three-digit department code>-<five-digit position code>-<three-digit
location code>-<unique sequence number>-<one-digit FT/PT designation>-
<four-digit G/S designation>

So an example would be:
400-DCA02-410-3019-1-G4S8

Department: 400
Position: DCA02 (direct care overnight)
Location: 410
Sequence number: 3019
Shift: 1 (full-time)
Pay scale: Grade 4, Step 8

These were identified in columns A through G, with the following
formula to create the TDA number:

=A2&"-"&B2&"-"&C2&"-"&D2"&"-"&E2&"-G"&F2&"S"&G2

Additional columns were created as lookups to match the codes to
meaningful descriptions. Next, each employee was matched to a
position; unfilled positions remained blank. Then we created a pivot
table, that lists each position. In the data fields, we had count of
names (positions filled) and count of position numbers (positions
authorized).

Finally, we used Word to create relevant forms, such as personnel
action forms, position authorization/elimination, etc.

Eventually, this was upscaled to Access to also track position history
and employee history, and linked directly to our payroll database.
That took about 20 pages of code and 2 months of designing, but I was
able to do it with an HR co-worker, who assisted in adding various
features.

In the end, no one ended up using this, so it's still sitting on the
network, fully functional, but about a year and a half out of date as
far as position authorizations and assignments.

Sad, but true.

Good luck to you.