How To Create An Expense Report In Excel- Follow These Steps.

Asked By 15 points N/A Posted on -
qa-featured

To create an expense report in Excel, we need a spreadsheet. It helps us in adding the total of the salary, products, etc. How to create an expense report in Excel?

SHARE
Answered By 0 points N/A #155668

How To Create An Expense Report In Excel- Follow These Steps.

qa-featured

To create an expense report in Excel, we need a spreadsheet. It helps us in adding the total of the salary, products, etc.

Step 1: After you open Excel, you will notice that each row and column has a unique name or address. Each alphabet represents a column, and each number denotes a row.

Step 2: In the first cell which is A1, type Item and in B1, enter price. Now from A2 type item name and then in B2 type the cost. Keep typing until your entries get over.

Step 3: At the end of the A column type Total. At the end of B column type SUM(Cell number of the first entry of cost: Cell number where you have made the last entry of the price).

Related Questions