Information Analyses. After the information is merged the analyzing process is to be started. Pivot table could be used for those purposes. Pivot table is a table which summarizes the datum and provides an opportunity to analyze the information according to various criteria. There are a lot of various books about such table and I don't want to quote it here.

But there is one particular topic I would like to talk about here. Maybe the most popular summary tables are MS Excel, but they have one strong disadvantage - they don't give an opportunity to edit source data. Just imagine - you analyze expenses for employee's benefits (F column in spreadsheets). When customizing information you realize that expenses on one employee are much bigger than on the other one. Most probably one of the managers made a mistake and put one additional zero to the sum. But what are we supposed to do with this knowledge? For solving this problem you have to check all the raw data and undo the whole table. This is very inconvenient and takes a lot of time. Thankfully there exist pivot tables in which you can edit source data. I personally use MergeExcel. Using the analytical resources of this software you can easily find any information.

Export of the data into source files. For managers to get the information on which offers were approved I export the results of my work back to source files. It is easy in MergeExcel - just press the Export button. After that files go back to senders.

This is how one can analyze all the necessary expenses and send it back to sender the easiest and quickest way. But there is a problem, and it is connected as usual with the human factor. The thing is that it is quite difficult to make 100 people follow up the table without mistakes. Someone surely will type "100 dollars" instead of "100". Someone will type his name in 10 different ways. Of course there do exist various administrative ways to control this but they all are waste of time. Thankfully there is one way to solve this issue. One should restrict the number of data variations managers can fill in the blanks. This is conducted by special operation called "Validation" (you can find it in menu "Data"). For example to the cells which can only conduct numbers "Whole number" restriction could be stated. If some of the cells are not to be change than one can just put the "Lock" restriction.

The sphere of usage of this way of information management is barely restricted. Here I am going to list some examples. * Analyses of working plans and reporting. The Excel file should contain information about - Name - Date - Type of activity - Working time spent on this activity * Analyses of representative expenses. Should contain information about: - Name - Date - Type of expenses - Sum * Survey. 2 columns needed: - Questions - Answers. It would be useful to choose variants for this column from a number of set variants. * Menu plan. Employees should choose from a number of set variants. (fish/meat/chicken) * Information on resale. - Name of reseller - Date - Type of production sold

Those examples are given only to illustrate the fact that variant of information procedure given is almost universal.

Page 2 of 2 :: First | Last :: Prev | 1 2 | Next