[ad_1]
Microsoft Excel is a program designed to make automatic calculations. By installing a simple coding, called function can be programmed Excel to quickly multiply, add, and extract data. This allows Microsoft Excel the ideal tool for billing. As the data changes, the results automatically improved
Guidelines .:
- Step # 1
Make headlines. In the first series, captions for each element to your account. Other items might include product, date, quantity, price, product Subtotal and Discounts.
- Step # 2
Sort cells. The cells containing the text to be formatted; but you have to format the cells containing dates and currency. To arrange a field, click a box and choose “Format Cells.” For date sections, select the “Date” from category box. Then, select the appropriate type. For cells currency, select the “currency” of the category box.
- Step # 3
Enter your information. Set data for each item purchased. If you do not currently have the information, you might want to put a few lines of info so you could see how numbers appear.
- Step # 4
Set the recipe of the product sum. To know Subtotal each product, select the cell that has Subtotal. In the formula bar, type “= SUM (” and select the cells that make up the sum as prices, discounts and quantity. Then press the “Enter” to submit your recipe.
- Step # 5
Make a total cells. In the row where you want the invoice subtotal select all the cells in the row to head the sum of the cell. Click and choose “Format Cells.” Select “Alignment” tab and select “Merge Cells” from the “Text Control.” Choosing the “right” from “horizontal alignment” box. Enter the “Sub-total” in the cell. Go over this step to make the cell for a total of taxes.
- Step # 6
Set account formulas. Select Invoice sum section. Type “= SUM (” and select all the chapters in a total section; .. Push the button “Enter” to make recipe Select Taxes section type “= [Accounts Total cell] * [tax rate].” Press the button “Enter “to make the recipe. Select Total cell. Type” = SUM (“and select” Taxes “and” Total “cells. press the” Enter “key to make the formula.
[ad_2]