How To Change The Estimate

Table of contents:

How To Change The Estimate
How To Change The Estimate

Video: How To Change The Estimate

Video: How To Change The Estimate
Video: How to Account for a Change in Accounting Estimate 2024, March
Anonim

When drawing up an estimate, the necessary parameters are not always taken into account and the correct numbers are inserted. To be able to change the calculation, do it in Excel. Then at any time you can add the missing columns and recalculate the total cost, as well as the price per unit of the product or service.

How to change the estimate
How to change the estimate

Instructions

Step 1

To change the estimate, open it in Excel. If it was done in another, the table will have to be formatted. To do this, do the following. In all columns where there are numbers to add, remove the lettering. Select one column with the left mouse button. Click on its right button to bring up a window with actions. Select the "Format Cells" tab. In the first "Number" section, add the formats "Currency" or "Number".

Step 2

Change all columns with texts to the appropriate format. Otherwise, the words will not be displayed correctly. To do this, select the required column by holding down the left mouse button. Click on the right mouse button to select Format Cells. Click on the first "Number" tab. Designate the format as "Text". Now you can start editing the estimate.

Step 3

Add rows, additional columns, or cells. Select the area where the necessary information will be entered. Click on the right mouse button. Find the inscription "Add cells". She is about in the middle of the list. Click on the link. A table appears showing the next steps. It will allow you to create or delete various components of the estimate.

Step 4

Fill in the added areas with new numbers and text. If you set automatic counting in numeric columns, the amount will change itself. If a formula was specified in the estimate, you will not have to change it if the new conditions are included in its scope. If they are listed separately, the function needs to be updated. This can be done by clicking on the fx icon, which is located at the junction of columns B and C. Enter the required formula to calculate the required values. Select new cells to be counted by clicking on the left mouse button. The program will perform the appropriate actions on its own.

Recommended: