Monday, November 12, 2012

Contact List - Template

The template I am uploading is a contact list made on Excel. To get a better understanding first go the “Details” sheet and name the column header and fill in the details as per you requirement.

Then go to the “Directory” sheet and see that the cell contents have changed to the details you entered in the “Details” sheet. Use the textbox in the “Directory” sheet to search for the relevant information from “Details” sheet. Here you will find only the first 10 best possible answers available. Then click on the name go to the relevant information on “Details” sheet.

Please see the images below for a better understanding.

Click here to download




Friday, November 9, 2012

To Do List - Excel

This simple excel to-do list helps you keep track of your current projects. By adding relevant information in the columns, a chart shows which project/task/assignment needs your attention and what is the current status of your overall team. Using the filter options on column, you can quickly sort projects by their priority, to whom is was assigned, assigned date, expected due date, completed date, no. of working days it took to complete the project and the current status.

Click here to download