You do that by right clicking at the top of the column to the right of where you want to add a new column, then click “Insert Column.” If your company has lots of employees, then you may want to include a column for “Department” or “Team” so that you can easily narrow down a search. Remember, these are templated columns, and you should configure this to fit your company’s needs. It’s also nice to freeze the row if you have lots of employees for easy viewing. We recommend bolding and centering them so you know they’re the column titles. To enter these fields, type each one in row 1. The most basic information to keep track will be the employee’s name, birth date, address, phone number, department, job title, manager, pay rate, and start date. The columns you add will depend on the information you want to track for each employee. We’ll go with “Employee Database – Template.” Do this by clicking “File” and then “Save As.” In the top left, you’ll now see your file has a name. Start by creating a title for your employee database. Open Excel and click on the “New Blank workbook” box. Create a New Spreadsheet & Name Your File
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |