EXERCISE 6: BUDGET AND SUPPLIES & CUSTOMER INVOICE IN MICROSOFT EXCEL

How To Complete a Customer Invoice Spreadsheet

1. Create the company Logo and title.

2. Format as table- choose your color.

3. Format price per unity and line- for example: 

total to currency : P or Php.

4. Compute : Line Total = quantity'

* price and total Supplies, 

Total=sum(D4:d7) or depending on the cells you used!

Change= total - change

5. Change the tab or sheet name

 to Customer invoice and 

change the tab color.

6. Print screen the final output and then you're done!

How to Complete a "Budget and Supplies" Spreadsheet

Same as before! You can copy the spreadsheet and edit it to add your budget and supplies! Repeat steps 2 to 6 and then you're done!