Excel Training Perth

TRAINING TEST OBJECTIVE - MAIL MERGE USING DATA FROM EXCEL

Send 7 mail merged letters to managers of paint outlets in each state; reporting all states sales figures.

This is an open book test.  You can also use the F1 key for MS Office help. Common formulas:

1. Open your Excel file you created in previous lessons
2. Right click any tab at the bottom left of the page  >  Insert  >  New Sheet.
3. Rename the new sheet "Test" and colour the tab light green.
4. Add the following data to the new sheet.

	2000	2001	2002	2003	2004	2005
WA	22	33	15	38	44	48
NSW	18	18	25	32	48	32
Vic	17	18	21	22	22	24
QLD	16	16	13	15	17	17
SA	15	15	15	6	15	16

5. The numbers below each year represent litres of paint sold.  Assume @ $2 / litre
6. Show totals in column "H" with an Australian total in H8.
7. On the "Test" Sheet create a bar chart for Western Australian sales ONLY for 5 years.  Extra marks for labelling.
8. On the "Test" Sheet create a simple (non fragmented) pie chart for All states year 2000 only sales.
9. Save Excel file in Prac folder with your name.
10. Bonus marks for those who can save another chart on the Test sheet, showing paint sales of all state over all 5 years.  Tip: Start by selecting all of what is shown in part 4 above.

    ---

11. Report to the managers, using MS Word, as much as you can in the best way you know how including:
    1. Sales by litres table (like in point 4 above but with totals)
    2. Sales by dollars table (like in point 4 above but with totals)
    3. Litre sales chart
    4. Dollar sales chart
12. Use the addresses you invented in previous lessons to mail merge your reports to.
    Tip:  You need to copy (Ctrl+C) tables and a chart to the NEW original mail merge document file named and saved as "mail merge source.doc"  Use the letter mail merge wizard to merge to another Word document I want you to save to the file name "mail merge test.doc"
13. A unique first paragraph scores bonus marks.
14. Once you have completed the basics of this Excel info into mail merge report, you can go back to your Excel table and work on formatting (working on it's appearance) and then work on the formatting of the test Word doc.

Next Week:

Removing a series from a chart. Eg WA

Hypertext links to www resources (eg web pages) in Word and Excel

and

Creation of PDFs from Word and Excel

---

Excel Training Perth

Excel Formulas

Perth Excel Training Enrolment

Microsoft Office Training Perth

Computer Training Perth

Perth WA

Top Excel Training Perth