Creating a association facts abstract directory is one plan to assist employees allot other employees within the business. This information should be updated monthly as dewy employees are hired and others sufferance. You can comprehend exigent data such as names, faculty titles, work ring and email dossier, profession locations within the building and added. After creating the directory, email it to each employee so they will be able to contact each other quickly and easily.
Instructions
1. Open an Excel spreadsheet.
2. Determine set up your company information summary directory. For instance, Column A can include the employee's name. To check for duplicate entries, click "Remove Duplicates" located in the "Data Tools" box. Column E can include their department manager' name and title.
3. Add employee names to the spreadsheet by manually entering the information or by importing from another document. To import data, click on the "Data" menu and select "Get External Data."
4. Organize the list by highlighting all entries and clicking on "Sort." This allows you to list names in ascending or descending alphabetical order.
5. Column B can include their job title and basic job description. Column can include their office phone number. Column D can include their office email address.
