© 2022 - aleteo.co
In Word, click the Insert tab and click the Object button, as shown below. On the Object dialog, click the 'Create from File' tab and use the Browse button to navigate to your Excel file. Before clicking OK, you need to decide whether to check the 'Link to file' option, which is covered next. The 'Link to file' Option. The most direct and easiest way is to copy the worksheet contents in Excel, then paste them in the Word document. Open the Excel worksheet you need, and select the contents range you need to convert to Word document, if you need to convert the whole worksheet, press Ctrl + A to quickly select it, then press Ctrl + C to copy it.
Up to this point in the course, each of the computer applications has been treated as separate, standalone apps. In the world of business however, each application can be integrated, in various ways, into the others to enhance the reporting, presenting, and communication tasks of business on a daily basis. Integrating Word, Excel, and PowerPoint makes business communication more effective by organizing separated information into one place for easy access and analysis.
These skills from this course to this point will now be used to see how these computer applications can be integrated to accomplish business tasks. To accomplish this, let’s look at an example scenario.
The Rowan Retail store is about to have their annual review of their sales figures and Rosamine Ruiz has been asked to write up a one-page report explaining the sales trends for the past three years for the store’s General Manager (GM). Rosamine has collected all of the information she needs and is now ready to begin her report in Word.
There are many ways in which integration can take place in a Word document. At times new content must be created. Other times content from other sources and documents need to be incorporated and integrated into the Word document. As Rosamine will discover, each document can be a mix of both new and existing content. As you work more over time with Word, you will discover additional ways to integrate many elements into one document.
As Rosamine creates the sales report, the first step she takes is to open the Word application and create a new document using company templates—Rowan Retail Sales Report. She searches for the exact template and selects it by clicking on the image in the Word window.
This is what the template for the sales report looks like. It is in newsletter form with two columns because that is the way the GM prefers the report to be formatted.
Rosamine wants to customize this report, so she starts to tweak it before she starts composing.
The first thing Rosamine decides is to change the look and feel of the template. She changes the theme by clicking on the Design Tab then the Themes button on the far upper left. Rosamine picked the Retrospect theme, which changes the text and colors from the golden yellow color to a red/orange theme.
Next, Rosamine removes the DRAFT watermark from the report.
Still in the Design tab, she moves to the upper right buttons and selects the Watermark button.
There are a couple of ways to integrate an Excel table into a Word document.
Rosamine starts to type in her report. Along the way she decides to change the theme colors again to more of a brown color and repeats the theme change process like she did previously. She continues writing her text and now needs to add an Excel table to her report highlighting the three different store Q2 sales numbers.
She has the second quarter sales information from another report, but doesn’t have the Excel file itself to copy into her Word document. Because she has no existing Excel file, she creates her own table through the following steps:
The Excel table is now in her Word document and ready for data to be entered. Notice how the color of the upper toolbar is displaying the Excel green and that the Home tab is selected. This is an indicator to Rosamine to know she is now working with an Excel table. She can now begin to type in the data for the table.
Note: If at any time Rosamine clicks outside the table it will revert back to the Word document and she can double-click back on the table to open it up for data entry again.
Cell Style. AutoSum. Center. Color in Cells. Borders. Bold.
Rosamine has entered the sales figures from the three different stores, and wants to make additional changes to the table. This is how she changes the table.
Now the table is complete, but it still shows too many unused cells. Rosamine resizes the table by holding down the left mouse button and dragging the sides of the table to the correct size for the report.
Her work complete, she clicks off to the right. Her Word document is ready for more text and additional data.
What if Rosamine has access to the store sales information Excel file directly? With this scenario, she can place it directly into her Word document with no need to make her own table. Here is how Rosamine can insert an existing Excel file:
Next is getting back to the Word document. There are three ways to accomplish this:
Now that the Word document is selected, Rosamine now places the cursor where the table should be and right-clicks with her mouse. The menu appears again. She selects the Paste Option small clipboard icon, and the table is copied into the Word document.
This is how the document looks with the Excel table pasted into the document.
Here is an illustration of copy and pasting using the keyboard shortcut keys (Ctrl+C, Ctrl+V) where Rosamine would first select the Excel table, copy the table, then paste it into the Word document.
Once the copied Excel table is in the Word document, it can be modified by double-clicking in the desired cell and then it can be changed however desired. It does not open a small Excel spreadsheet as the table created within Word in Option 1 did.
The table is now set and Rosamine is ready for more text and an additional data chart.
There are a couple of ways to integrate an Excel chart into a Word document.
The next piece of information needed in the report is the annual sales chart. To enter this data, Rosamine makes sure her cursor is at the place in the report she wants the chart to go. She clicks back to the Insert tab and selects the Chart button.
The next step is to select the type of chart to use for her report. In this instance, Rosamine chooses a line chart.
Next, Rosamine selects the style of line chart to use and begins to enter information to create the chart itself.
The chart will contain the total sales numbers from the last three years for each of the three retail stores. She puts the years in Column A (purple color), the name of the stores across row 1 (pink color), and the sales figures in the rest of the cells (blue color). Here is what her chart now looks like in the report.
Rosamine clicks on the chart title box and changes the name of the chart to Annual Total Sales. Rosamine notices that the numbers are difficult to see, so she resizes the chart to make it easier to read.
Rosamine resizes the chart by clicking on the mid-points in the chart and dragging them to a larger size that still fits within the document column width.
The General Manager will now see the rise and fall of sales over the last three years in Rosamine’s report.
To finish the report, Rosamine types in the rest of the text. Next she needs to link a PowerPoint presentation file for a reference mentioned in the report.
What if Rosamine already had access to the Annual Total Sales chart file? She could copy and paste the chart into her document. First she opens the Excel file with the chart in it. Since she has learned to copy and paste from the previous table, she puts the Word and Excel windows side-by-side on her screen, then takes the following steps:
If Rosamine wanted to use the copy and paste keyboard shortcut it would be exactly like the copy and paste from the table example and look like this:
To finish the report, Rosamine types in the rest of the text.
Next, Rosamine will link to a PowerPoint document with a hyperlink in a Word document.
Once again Rosamine returns to the Insert tab and selects the link button. Towards the bottom of the dropdown menu, she selects Insert Link and then finds the correct PowerPoint file location and adds that to the window.
Now when the GM hovers over the hyperlinked file, the location and file name will be displayed and can be clicked on to open that third-quarter sales promotions presentation for more information.
There is one more thing Rosamine wishes to incorporate into her document—a final icon.
Rosamine’s GM has a good sense of humor, so Rosamine chooses a different icon to end with in each of her reports. This time she wants a little piggy bank icon. To do this, she puts her cursor where she wants the icon to go, clicks on the Insert tab, and selects the Icon button. After scrolling down, she finds the piggy bank icon, selects it, and clicks the Insert button.
The little piggy is now in the document but needs a bit of adjusting. Like she can with the table and chart, Rosamine can drag the little image circle boarder to make the icon smaller. She also selects the button to have the icon move behind the text.
Now the little piggy bank is in place, and Rosamine has finished her report. She makes sure to save her file where she can easily find it again and emails it to her General Manager. Well done, Rosamine!
Answer the question(s) below to see how well you understand the topics covered in the previous section. This short quiz does not count toward your grade in the class, and you can retake it an unlimited number of times.
Use this quiz to check your understanding and decide whether to (1) study the previous section further or (2) move on to the next section.