Sunday, February 20, 2011

Use Excel to keep track of your projects

Troy Chollar is a designer and owner of TLC Creative Services, Inc., a multimedia and graphic design studio located in San Diego, CA. Troy is also a Microsoft Most Valuable Professional (MVP) for Microsoft PowerPoint.

Many customers of Troy require visually dynamic PowerPoint presentations.   Trojan uses Microsoft Excel 2010 to keep track of design projects of his company. The following is an example of how he has set up a spreadsheet to keep track of multiple design elements in a project that are scattered among the three designers.

Example of spreadsheet

Above:

The spreadsheet is online, so anyone in the Office can access it using Microsoft Excel Web applic rows 1 and 2 remain the same for all client worksheets. He adds more generally rows with specific design elements relevant to the larger project.

 Example of spreadsheet

Above:

Troy maintains a separate tab for each project, with the most recent on top.The ' Main ' tab, here, is the model that he Drops and Rename for each new project.All in Office may revise and update the worksheet-simultaneously!

To download a copy of the template uses Troy, go here: http://office.microsoft.com/en-us/templates/results.aspx?qu=Joy+MIller&origin=FX101741961&AxInstalled=1&c=0%23ai%3ATC102382690#ai:TC102382690|

--Joy e. Miller

Joy E. MillerJoy e. Miller is a writer for PowerPoint.


View the original article here

No comments: