For this module's assignment you focus on the integration of Microsoft Word and Microsoft Excel. Going back to our travel project in Module 07 you created a PivotTable that provided us with the travelers that have a balance due greater than or equal to $2000. The management team would like to see your results.
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 listed below.
Requirements:
Open a New Word Document and Chose the Professional Design Memo Template
Update the Company Name to International Travel Company
Update the values of the To, CC, From, and Date
Update the Re: to be "Statistics from Recent Balance Due Inquiry
The title of your Template should be Travelers with >=$2000 Balance Due
Include a short explanation of the details that you are providing to your employer in the body of the text
Integrate the PivotTable created in Module 7 into the Memo
Save the Word Document. The name of the file should be your first initial and last name, followed by an underscore and the name of the assignment, and an underscore and the date