You will need
- the program Microsoft Office Excel.
Instruction
1
Use a calculation in the Microsoft Excel. She has easy to handle interface, which can be used not only to calculate the total amount, but also subtract, or multiply the individual counts, as well as replace one value by another.
2
Hover over a cell in the top left corner to make the table. Its designation in the program - A1.
3
Hold down the left button of the mouse and count six columns to the right (to cell F1). The number of rows must be equal to the number of items that need to be written in the estimate.
4
Type the names of the columns. The first is a sequence number. Label it a symbol of the no. The second is the name of the material or type of work. For example, when providing a service list here the points of all the actions that will be produced. And with the purchase of the hardware - name of all products. Third - the unit price of the product or service. The fourth column - number of units, times, etc.). Name it is an abbreviation of "number".
5
The fifth column - the total cost estimate of works or materials. Make amount for all the items or service by the same name. Subsequently will automatically add up the total cost. To let the program to perform this operation, do the following:
- click the left mouse button and highlight the entire fifth column;
- press the right mouse button, then appears a table with the actions;
- locate the "Format cells";
- select the first tab "Number";
- specify the format - "Cash" or "Numeric".
Following the steps, calculate the total amount. Again, highlight the whole column. In the upper corner to the right, look for the symbol Σ (Sigma). Click on it to have all the numbers in the right column.
- click the left mouse button and highlight the entire fifth column;
- press the right mouse button, then appears a table with the actions;
- locate the "Format cells";
- select the first tab "Number";
- specify the format - "Cash" or "Numeric".
Following the steps, calculate the total amount. Again, highlight the whole column. In the upper corner to the right, look for the symbol Σ (Sigma). Click on it to have all the numbers in the right column.
6
In the sixth column place the notes. Enter here any additional information. Where to buy the right materials, colors, deadlines, phone customers, etc., So that the text information was displayed correctly, do the following:
- using the left mouse button, highlight all the lines of the sixth column;
- right click the mouse to the table with the action displayed on the monitor;
- select "Format cells";
- move to the first tab "Number";
- specify the text format.
- using the left mouse button, highlight all the lines of the sixth column;
- right click the mouse to the table with the action displayed on the monitor;
- select "Format cells";
- move to the first tab "Number";
- specify the text format.
