Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How To Use Excel Manage Recruit Employees?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How To Use Excel Manage Recruit Employees?
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. On Nov 6, 8:43 am, Davi wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel have a field to manage video in a playlist? | Excel Discussion (Misc queries) | |||
Using Excel VBA to manage outlook attachments 2003 | Excel Discussion (Misc queries) | |||
How do I manage data from access to excel | Excel Discussion (Misc queries) | |||
Using Excel to manage information in Access | Excel Discussion (Misc queries) | |||
I am looking for an excel template to manage our customer list. A. | Excel Discussion (Misc queries) |