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