Starting Year : Type the starting year period where you want to record and track your employees. You can follow a short guidance below to use this template:įilename : Change the filename with exactly the same name with the filename that you have saved as or modified by your computer
The lite version is for up to 15 employees. For example, the size of 150 – 250 employee database manager spreadsheet (the Pro version) is between 13 – 21 Mb, and if one employee image has 200 Kb filesize, there will be an additional 30 – 50 Mb. But, it is not recommended if you manage hundreds of employees because it will make the size of the file becoming very big. If you don’t have many employees to be managed, you can insert employee images in each employee data form. It is intended to help you writing/selecting correct names and titles to minimize any typos which could make them undetected in summary formulas.
To accompany employee information form and database worksheet, I added setup worksheet. This one column data entry will ease grouping of those related data into a one row employee data in a big database record. The idea of creating this spreadsheet is to assign one worksheet to one employee and set one column to type all needed employee information. I suggest you to use your official form and use this as a database to process and retrieve employees data. It is designed as an interface to the employee database worksheet. The outlook of Employee information worksheets might not fit your official employee data form, if you plan to make it as your form as well.
There are summaries and charts built from those datas with common excel functions. It is simple because the intention on creating this spreadsheet is to record all employee information in a simple format and map those information in a simple database which can be processed quickly and easily. This Employee Database Manager is a simple excel template that will help you manage information of your employees easily.
0 kommentar(er)
