Human Resource Management:

Human resource management (HRM) is the strategic and coherent approach to the management of an organization's most valued assets - the people working there who individually and collectively contribute to the achievement of the objectives of the business. In simple words, HRM means employing people, developing their capacities, utilizing, maintaining and compensating their services in tune with the job and organizational requirement.
Human resources management involves several processes. Together they are supposed to achieve the above mentioned goal. These processes can be performed in an HR department, but some tasks can also be outsourced or performed by line-managers or other departments. When effectively integrated they provide significant economic benefit to the company.
• Workforce planning
• Recruitment (sometimes separated into attraction and selection)
• Induction, Orientation and Onboarding
• Skills management
• Training and development
• Personnel administration
• Compensation in wage or salary
• Time management
• Travel management (sometimes assigned to accounting rather than HRM)
• Payroll (sometimes assigned to accounting rather than HRM)
• Employee benefits administration
• Personnel cost planning
• Performance appraisal
• Labor relations

Sum a range of cells:

If you insert a row directly above the Excel SUM function, the new row may not be included in the SUM. It may continue to sum cells A1:A4, and ignore A5. To ensure that new rows are included in the total, you can use the OFFSET function with the Excel SUM function.
1. Select cell A5.
2. Enter the following formula:
=SUM(A1:OFFSET(A5,-1,0))
3. Press the Enter key to complete the entry.
4. Insert a row above row 5
5. Type a number in cell A5, and it will be included in the total in cell A6

How to reduce the size of the mail box:

To reduce the size of your mail file, you have a few options.
What do you want to do? Procedure
Automatically archive unused messages 1. Open your mail, select Actions > Archive > Settings > Criteria, and either edit existing criteria or create new criteria. This criteria will tell Notes which documents to archive and what to do with them.
2. After editing or creating, select the desired criteria from the list and click Enable.
3. If you have access, set an archiving schedule on the Schedule tab. Click the check box next to Schedule archiving, and then choose a time to run archiving. You must leave your computer on at the time you schedule.
Manually archive unused messages Follow the first two steps for automatically archiving unused messages.
During step one, for Selection Criteria, select Selected by user. Make sure to enable this criteria.
At any time after this, select the messages you would like to archive, and then select Actions > Archive > Archive selected documents.
Automatically delete unused messages Follow the steps for automatically archiving unused messages.
When you create or edit the archiving criteria, select Just clean up this application without archiving.
Manually delete unused messages Follow the steps for manually archiving unused messages.
When you create or edit the archiving criteria, select Just clean up this application without archiving.
Automatically reduce unused messages Follow the steps for automatically archiving unused messages.
When you create or edit the archiving criteria, select Reduce the size of documents in this application, and make a selection from the corresponding drop-down list.
Manually reduce unused messages Follow the steps for manually archiving unused messages.
When you create or edit the archiving criteria, select Reduce the size of documents in this application, and make a selection from the corresponding drop-down list.

Traceability Matrix:

In a large testing project, it is easy to lose track of what has been tested and what should be tested. The question often arises, "Is the testing comprehensive enough?"
A simple way of determining what to test is to go through the source documents (Business Requirements, Functional Specifications, System Design Document, etc.) paragraph by paragraph and extract each requirement. A simple matrix is built, with the following format:
Source
Document Section Requirement Test Case
Func Spec 3.1 An account number must be entered, of 8 digits and a 1 digit checksum. Invalid account numbers must be diagnosed with an appropriate error message. 147
Func Spec 3.1 The account number must exist in the Customer Database; if not, an appropriate error message must be displayed. 148
Func Spec 3.2 Given a valid account number, the customer details must be retrieved from the Customer Database and displayed on the CD-102 screen form. 149
Basically, the Traceability Matrix relates each functional requirement to a specific test case. Thus if someone says, "Did we test that the account numbers must be valid?", the matrix indicates which test case does that test.
The Traceability Matrix is created before any test cases are written, because it is a complete list of what has to be tested.
Sometimes there is one test case for each requirement; other times, several requirements can be validated by one longer test case.

Telephone Etiquette:

Presenting a professional image, both in person and on the telephone, is very important in the Office Skills profession. Taking care of your customers over the telephone and making them feel well informed and appreciated is essential.
Answering Calls

1. Speak clearly. A picture paints a thousand words but the caller on the other end of the phone can only hear you. They cannot see your face or body language. Therefore, taking the time to speak clearly, slowly and in a cheerful, professional voice is very important.
2. Use your normal tone of voice when answering a call . If you have a tendency to speak loud or shout, avoid doing so on the telephone.
3. Do not eat or drink while you are on telephone duty. Only eat or drink during your coffee break or lunch break.
4. Do not use slang words or Poor Language. Respond clearly with “yes” or “no” when speaking. Never use swear words.
5. Address the Caller Properly by his or her title. (i.e. Good morning Mr. Brown, Good afternoon Ms. Sanders). Never address an unfamiliar caller by his or her first name.
6. Listen to the Caller and what they have to say. The ability to listen is a problem in general but it is very important to listen to what the caller has to say. It is always a good habit to repeat the information back to the client when you are taking a message. Verify that you have heard and transcribed the message accurately.
7. Be patient and helpful. If a caller is irate or upset, listen to what they have to say and then refer them to the appropriate resource. Never snap back or act rude to the caller.
8. Always ask if you can put the caller on hold. If you are responsible for answering multiple calls at once, always ask the caller politely if you may put them on hold. Remember that the caller could have already waited several minutes before getting connected to you and may not take lightly to being put on hold. Never leave the person on hold for more than a few seconds or they may become upset and hang up.
9. Always focus on the call. Try not to get distracted by people around you. If someone tries to interrupt you while you are on a call, politely remind them that you are on a customer call and that you will be with them as soon as you are finished.
Making Calls
1. Always identify yourself properly. When calling a client or customer, whether in person or when leaving a message, always identify yourself properly by providing your name, company name and contact telephone number. For example, "Good afternoon Mr. Brown, this is Ms. Brown from Officeskills.org. My telephone number is 408-555-1212." Always be aware of confidential information when leaving messages. Also, be aware of people around you while talking on the phone. Be discreet! Someone next to you might overhear confidential information that could negatively affect your business.
2. Avoid leaving long winded messages. Remember, someone has to listen to your message, write it down and then act upon it. Your message may be just one of many messages that need to be handled. It is often a good habit to write down or type out your message in advance. Keep it brief and to the point.

Customer-Supplier Partnership:

Customer-Supplier partnership is a long-term relationship between a buyer and supplier characterized by teamwork and mutual confidence. The supplier is considered an extension of the buyer’s organization. The partnership is based on several commitments. The buyer provides long-term contracts and uses fewer suppliers. The supplier implements quality assurance processes so incoming inspection can be minimized. The supplier also helps the buyer reduce costs and improve product and process designs.

Labor Scheduling Software:

A computer software program that creates weekly work schedules for employees and departments. The software program inputs company parameters such as vacation, holidays, work availability, hours of operation, peak sales periods, etc.