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

Asked By S-Amin 15 points N/A Posted on - 08/20/2016

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?

• Status: Open
• Question Views: 371
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Lopez Berardi 0 points N/A #155668

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

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).

About Lopez Berardi

Questions
1

Answers
32

Best Answers
4

• Vote Up 0 Vote Down

• Posted on - 08/20/2016
• Question Category: MS Excel