The idea is to have a box where you can type your employee data record to get particular employee data.īy having them recorded in this type of table, you can process any employee information easily. You can this worksheet to search for particular employee to get their information quickly. You can expand and shrink particular category using the top left number (1 or 2) while working in this worksheet. In the spreadsheet, there are samples of categories grouped into bigger category. You can put as many category as you want in this model. Also, you can use it for applicant database to ease you on recruitment process. By having them arranged like this, their data can be search easily either using VLOOKUP or INDEX&MATCH functions, especially if you have hundreds of employees or have high turnover rate. Each column corresponds to each employee. The second column onward will become columns to entry employee data. Write employee database category at the left side of the table. There are two worksheets inside this spreadsheet.įirst worksheet, is a database worksheet. This database manager is a simple but should solve your issues. It is developed to help you, who are not expert in programming but familiar with Excel, organizing your employees without spending time to much on manual side. Employee Database Manager is an Excel Spreadsheet to organize employee database on your company.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |