Computer applications and business systems - Integrating the Pivot Table into a Word Memo

Using the Professional Design Memo template in Microsoft Word, create a memo to your employer which provides them with the travelers that have a balance due greater than or equal to $2000. In doing so, be sure to address the following requirements:

1. Open a new Microsoft Word document. In the search box, run a search for the Professional Design Memo Template.

2. Update the Company Name to International Travel Company.

3. Update the values in the To, CC, From, and Date fields.

4. Update the Re: to be Statistics from Recent Balance Due Inquiry

5. The title of your template should be Travelers with >=$2000 Balance Due (Note: there is NO title place holder. Put the title under the Re: line)

6. In the body of the memo, include a short explanation of the details that you are providing to your employer.

7. Integrate the PivotTable that you created into the Memo as a Microsoft Excel object. (Do not create a link).

HINT: when you double click the pivot table, you should get a mini copy of Excel.

8. Save the Word document using the correct naming convention.

https://www.dropbox.com/s/ae07cuxzfoja9ed/Mod_data_file_and_ppt.rar?dl=0