Recording Metadata
- System
- Windows
- Version
- 10 (10.0.19045)
- Processor
- Intel64 Family 6 Model 94 Stepping 3, GenuineIntel
- Resolution
1920 x 1080 px
Reasoning Steps
Step 1
Open Microsoft Excel and create a new blank workbook to start building your expense report from scratch.
Step 2
In the first row, enter column headers,such as: Date, Category, Amount, and Notes to structure the data entry fields.
Step 3
Select the header row and the initial rows below it, then apply borders by clicking Home → Borders → All Borders to make the table visually organized
Step 4
Enter your expense data under each column, filling in the relevant date, category of expense, amount, and any notes or comments.
Step 5
Format the Amount column as currency by selecting the column, right-clicking, choosing Format Cells, and selecting Currency to ensure consistent number formatting.
Step 6
Click on a cell below the Amount entries and use the =SUM(C2:C100) formula (adjust range as needed) to calculate the total of all expenses entered.
Video
Loading tracking data...