Project: monthly expense report

In this lesson

1. 1. Add the missing expense

   You are the office accountant at a small firm. Finish the March expense report for your manager.

   First, one bill is missing.

2. 2. VAT for the first row

   The VAT rate is in I3. Lock it, so you can copy the formula.

3. 3. VAT for every row

   Copy the VAT formula down to the last expense.

4. 4. Total for each row

   The total is the amount plus the VAT.

5. 5. The grand total

   Add up all the amounts in row 11.

   This formula is long. In the next course you will learn a much faster way.

6. 6. Totals for VAT and Total

   Copy the grand total formula to the right.

7. 7. Format the money

   Show all the money with commas and two decimals.

8. 8. Format the dates

   Use a date format that is clear in every country.

9. 9. Style the headings

   Make the heading row bold, with a line under it.

10. 10. Center the title

    Center the title over the table, without merging cells.

11. 11. Keep the headings in view

    Freeze the title and the heading row. Select the first cell that should move.

12. 12. The VAT rate changes

    Your manager says the VAT rate is now 15%.

13. 13. Check your report

    Look at the grand total in F11.

Part of Excel Essentials. Short lessons with practice in a real spreadsheet, checked as you go.