​Using the Professional Design Memo template in Microsoft Word- Integrating the Pivot Table into a Word Memo

User Generated

ehsvb88

Business Finance

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:

  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.

part 2

As part of a wrap-up to the travel destination project, it's always a good business practice to formally thank your employer for appointing you to pursue such an opportunity. As such, it's time to thank your boss in writing for allowing you to participate in this engaging project.

  1. Select any Word memo template that you like.
  2. Update the Company Name to International Travel Company.
  3. Update the values in the To, CC, From, and Date fields. (Your faculty member can be your boss for this assignment)
  4. In paragraph 1, thank your boss for selecting you for the Travel Project.
  5. In paragraph 2, explain some of the things that you learned that will help you in other projects. Be sure to mention at least three things and how you think they will be helpful.

files might help understand

Unformatted Attachment Preview

TRAVEL DATA REPORT Flores 1 Travel Data Report Andriane Flores Morris Gartenberg Computer Applications and Business Systems Concepts 26 August 2018 TRAVEL DATA REPORT Flores 2 Memo To: Sally Jones From: Andriane Flores Date: January 15, 2015 Subject: Travelers for the London and Paris Trip Below is the current status of the London and Paris trip: Travelers for London and Paris Trip Name # of Travelers John Jones 3 Terry Jones 2 Ed Murphy 2 Mary Harman 1 Total Cost 7500 5000 7500 2500 Down Payment 2500 2000 1000 1000 Travelers Information 25 20 15 10 5 0 Chicago New York # Trips New Orleans # Travelers # Insured Orlando Andriane Flores London & Paris Location North South East West Total Percent of Sales Total January February March 100 75 250 425 23% 200 80 245 525 29% 300 70 145 515 28% 200 55 90 345 19% Grand Total 1810 Replace the title with your name and the subtitle with your travel destination. Create formulas for Total Sales, Grand Total, and Percent of Total (E5/E9) - remember absolute cell addressing Create a bar or column chart for just the data (no calculations) Move the chart to its own sheet ute cell addressing My House Payment Mortgage Interest rate # of payments 350,000 6% 240 My monthly payment will be: ($21,000.02) My Savings Plan Number of months Amount saved Grand Total 12 $232 $2,784 23.71 Topic Aging and Death Aging and Death Aging and Death Aging and Death Aging and Death Aging and Death Aging and Death Aging and Death Criminal Justice Criminal Justice Criminal Justice Criminal Justice Criminal Justice Criminal Justice Introduction Introduction Introduction Introduction Introduction Introduction Introduction Introduction Introduction Introduction Introduction Marriage and Family Marriage and Family Marriage and Family Marriage and Family Marriage and Family Marriage and Family Race/Class/Gender Race/Class/Gender Race/Class/Gender Race/Class/Gender Race/Class/Gender Race/Class/Gender Race/Class/Gender Race/Class/Gender Race/Class/Gender Race/Class/Gender Race/Class/Gender Race/Class/Gender Research/Statistics Research/Statistics Research/Statistics Subtopic Sociology of Aging Death and Dying Sociology of Aging Sociology of Aging Death and Dying Death and Dying Sociology of Aging Sociology of Aging Deviance Juvenile Delinquency Deviance Deviance Juvenile Delinquency Juvenile Delinquency Conflict Approach Conflict Approach General General Macrosociology Approach Social Sciences Macrosociology Approach Social Sciences Social Sciences General General Marriage and Marriage and Family Marriage and Marriage and Family Marriage and Family Interaction Marriage and Family Interaction Marriage and Marriage and Family Marriage and Marriage and Family Race/Ethnicity Human Sexuality Race/Ethnicity Race/Ethnicity Gender Issues Gender Issues Human Sexuality Gender Issues Human Sexuality Human Sexuality Gender Issues Gender Issues Data Analysis Social Statistics Data Analysis Research/Statistics Research/Statistics Research/Statistics Research/Statistics Research/Statistics Research/Statistics Research/Statistics Research/Statistics Research/Statistics Research/Statistics Research Methods Social Statistics Social Statistics Research Methods Research Methods Research Methods Social Statistics Data Analysis Social Statistics Social Statistics Topic Research/Statistics Research/Statistics Research/Statistics Research/Statistics Research/Statistics Research/Statistics Subtopic Social Statistics Social Statistics Social Statistics Social Statistics Social Statistics Social Statistics Row Labels Elenor Pollack Jeremy Winters kenneth Springer Marlene Smith Grand Total Count of Artist 5 6 5 4 20 Artist Jeremy Winters Jeremy Winters Jeremy Winters Marlene Smith Jeremy Winters kenneth Springer kenneth Springer Jeremy Winters Jeremy Winters Elenor Pollack Elenor Pollack Marlene Smith kenneth Springer Elenor Pollack Elenor Pollack Marlene Smith kenneth Springer Elenor Pollack kenneth Springer Marlene Smith Name Spring in the Mountains Mountains in the Spring Blue Mountains Green Mountains Mountains in the Summer Boulder Park Geese Boulder Park Ducks Mountains in the Winter White Mountains Lake Michigan at Sunset Lake Michigan Red Mountains Boulder Park Lake Lake Michigan at Dawn Lake Michigan at Night Gold Mountains Children at Play Lake Michigan at Noon Boulder Park Water Yellow Mountains $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Value 73,482 48,293 47,180 44,448 58,571 63,687 37,794 40,377 24,631 58,387 70,663 56,417 68,582 72,443 29,051 54,117 36,531 71,194 43,249 72,035 Location Courthouse Convention Center Courthouse Courthouse County Center County Center County Center Courthouse Courthouse Convention Center Convention Center Convention Center Convention Center County Center County Center Convention Center Courthouse Courthouse County Center Courthouse Category Painting Sculpture Painting Painting Painting Sculpture Painting Sculpture Painting Painting Sculpture Sculpture Painting Painting Painting Painting Painting Painting Painting Painting
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

They are ready, Just co...


Anonymous
This is great! Exactly what I wanted.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags