Showing posts with label track. Show all posts
Showing posts with label track. Show all posts

Wednesday, June 8, 2011

Wine Cellar 2.1 Template for Microsoft® Excel Lets You Easily Track Your Personal Wine Collection

Wine Cellar 2.1 Template for Microsoft® Excel Lets You Easily Track Your Personal Wine CollectionWine Cellar 2.1 Template for Microsoft® Excel lets wine enthusiasts easily track and manage personal wine collections. The template saves people the time of setting up their own system. Data entry is easy and wines can be sorted by varietal, pairing, when to drink, quantity, price and many other categories. The spreadsheet can be customized to match different collections. Please note that the template is delivered via email. Added information: Very important; the template is designed for personal use where someone doesn't want to have to stand in their cellar or thumb through a notebook trying to decide what to drink. If you are in a business where you have to manage wine inventory, this is not the right solution. You need inventory management software.

Price:


Click here to buy from Amazon

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