Database Management

In order to keep track of how many sales my company makes of my product, I will use spreadsheet applications since it is the easiest and fastest way to store large amounts of data within the bowels of the system server. I will require my staff to use the Zoho spreadsheet application because one spreadsheet project can be worked on by multiple people in different locations at the same time. Since Excel is the preeminent application, I will have my staff convert the Zoho files into Excel files which is another good reason for using Zoho.

While ultimately using Excel for data management, I will make it manadatory that all documents are to be conditionally formatted. This will enable fast browsing of the key elements in an Excel spreadsheet. There will be set of company guidelines as to the color coating scheme when conditionally formatting Excel documents.

Additionally, emphasis will be put on the use of pivot tables for further summary and analysis of major data spreadsheets that are convoluted with lots of information. These tables will enable the breakdown of information. For example, the amount of units, in this case hand dryers, sold in a certain country and the total profits made from that sale are just one of many ways to chop-up the data to view in simplier terms for overall maximum effciency.