Integrating the Pivot Table into a Word Memo
Description
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:
- Open a new Microsoft Word document. In the search box, run a search for the Professional Design Memo Template.
- Update the Company Name to International Travel Company.
- Update the values in the To, CC, From, and Date fields.
- Update the Re: to be Statistics from Recent Balance Due Inquiry
- 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)
- In the body of the memo, include a short explanation of the details that you are providing to your employer.
- 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. - Save the Word document using the correct naming convention.