#Microsoft office word powerpoint and excel Pc
Word, Excel, PowerPoint, OneNote, Outlook PC only: Publisher, Access
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.Word, Excel, PowerPoint, OneNote, Outlook Her Word document is ready for more text and additional data. Her work complete, she clicks off to the right. 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. Now the table is complete, but it still shows too many unused cells. The last table change Rosamine uses is to select the titles and totals rows and bold each of them to contrast with the other data. To make the table look more defined in the document, Rosamine selects the entire table, then the Border button, then selects the “thick box border” to be placed around the outside of the table. Rosamine selects the top and bottom rows, clicks on the paint bucket button, and chooses a green color for the table. The table needs a contrasting color to make the titles and totals stand out. Next, Rosamine centers the Quarter numbers by selecting the three quarter cells and clicking on the centering button. With the bottom cell selected, Rosamine clicks the AutoSum button, which totals the three sales figures for all stores for the GM to easily see what total sales were generated from the second quarter. Rosamine selects and formats the column of numbers to be currency cells and to display the dollars generated from sales for the second quarter of the year. Rosamine has entered the sales figures from the three different stores, and wants to make additional changes to the table. Because she has no existing Excel file, she creates her own table through the following steps:Ĭell Style. She has the second quarter sales information from another report, but doesn’t have the Excel file itself to copy into her Word document. She continues writing her text and now needs to add an Excel table to her report highlighting the three different store Q2 sales numbers. 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. There are a couple of ways to integrate an Excel table into a Word document. Rosamine selects this and the DRAFT watermark is removed from her report. This button inserts or removes a variety of watermarks. Variety of possible changes for a document. Still in the Design tab, she moves to the upper right buttons and selects the Watermark button. She searches for the exact template and selects it by clicking on the image in the Word window. Customized Word TemplatesĪs 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. As you work more over time with Word, you will discover additional ways to integrate many elements into one document. As Rosamine will discover, each document can be a mix of both new and existing content.
Other times content from other sources and documents need to be incorporated and integrated into the Word document. There are many ways in which integration can take place in a Word document. Rosamine has collected all of the information she needs and is now ready to begin her report in Word. 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). To accomplish this, let’s look at an example scenario. 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. 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. Up to this point in the course, each of the computer applications has been treated as separate, standalone apps. Create a Word document with inserted icon.Create a Word document with inserted PowerPoint hyperlink.Create a Word document with integrated Excel chart.Create a Word document with integrated Excel table.
Create a Word document with customized template.