How to automatically issue certificate of employment form and career certificate form in Excel
The Excel automatic form for the certificate of employment is used by small businesses that have not yet introduced a HR program.
However, the form is slightly different for each workplace, and there is some inconvenience in filling out the form because the information management of employees is not properly managed.
Let’s see how to use the employment certificate excel form below. 재직증명서 양식
Overview of Certificate of Employment and Certificate of Experience 좋은뉴스
– A certificate of employment is a ‘document proving that the worker is working at the workplace’ and is an official document proving the status of the worker.
– A career certificate is an official document that proves the worker’s past career as a ‘document that proves the period and work the worker has worked for at the workplace’.
It usually includes the following.
Worker information: includes personal information such as the worker’s name, resident registration number, and address.
Working period: Specify the working period from the start of work at the workplace to the present.
Type of work: Specify the type of work, such as full-time, contract, or dispatched work.
Position: Specify the position of the worker.
Others: If necessary, specify in detail the work contents and special matters of the worker.
– Employment certificates and career certificates are usually issued by the HR team at the workplace, and the request for issuance is made by the worker himself or an agent designated by the worker.
– Workers must check the contents of the certificate of employment and career certificate issued and ensure that there is no forgery or falsification, and then keep it safely so that others cannot see it.
Places that require submission of employment certificates and career certificates
Certificate of employment is an important document required in various situations, and can be requested mainly in the following places.
When buying a house: When applying for a loan to a lending institution to purchase a house, a certificate of employment is required for loan review
In case of financial transactions: A certificate of employment is required when handling tasks such as loan screening or investment at financial institutions such as banks and securities companies.
Employment: In case of employment or job change, etc., a certificate of employment is requested during the hiring process to confirm the applicant’s career.
Employment Certificate & Career Certificate Form Automatic Usage
Create employee list in excel
Modify only the name without changing the form of the first employee in the excel sheet.
Copy the employee name at the bottom of the excel sheet and make a new copy.
Enter the copied sheet as the content of the new employee and change the copied sheet name to the employee name.
It is desirable to make a detailed list of employees based on the submitted resume and employment contract.
Create employee list in excel
The contents of sequence No. 1 are not changed.
After copying and pasting the contents of sequence number 1 to number 2, select the line of sequence number 2, press [Ctrl + F], enter the employee name of the copied line as the employee name of the new employee, and select [Replace All] If you do, it will be collectively changed as shown in the figure below.
Since the hyperlink is also changed, the employee list is automatically completed with this one-time operation.
How to issue Certificate of Employment & Certificate of Career
2 required items to be entered
– name
– Select the purpose of issuance
If you enter the name (employee name to be issued) in the personal information column, the certificate of employment is automatically issued through the form.
After selecting the issuance purpose input box, click the mouse on the lower right corner to select one of the four purposes.
Since the information comes from the contents of the employee list, care must be taken not to break the format of the employee list.
If there is something to be corrected, if an amendment is made in the employee list, the employee list is automatically corrected, and the certificate of employment and career certificate are also automatically corrected.
A career certificate is also issued automatically.
The name and contact information of the person in charge of the issuing department may or may not be written at the bottom.
At the bottom, if you put the name of the company and the name of the representative first, you do not have to change it later.
I have attached the material below for those who need it.
If you are downloading the data, please sympathize + comment (posting that you are accepting) + click 2-3 advertisements and go.