- Use internet tools to enhance Excel workbooks.
- Use internet tools to enhance Word documents.
- Use internet tools to enhance PowerPoint presentations.
The internet is an integral part of business, whether you are searching for information, images, competitor’s websites, or comparative product prices or communicating through video chats, online meetings, or email.
This section will walk through an example scenario and show how you can incorporate information from the internet into your documents, spreadsheets, and presentations for work.
Each of Rowan Retail’s three stores is preparing a report for the success of the third-quarter sales campaign. Every store is using a different application to report their results and have integrated various internet activities into each report. Now we’ll walk through how the stores accomplished this integration.
Internet and Excel
Rowan Retail Store #2 is using Excel to plan their campaign for the Q3 sales campaign. The campaign for this store is to create a loyalty program and start with selling more dairy groceries. Like Word and PowerPoint, the same skills apply to copy, paste images and address from the internet. There is one other feature that is unique to Excel which we’ll go over.
Maurice has opened his Q3 sales campaign Excel file and wants to insert pictures of each store in the table he has made. He searches the web for the photos by first clicking the Insert tab and Online Pictures button. After finding the second store’s photo, he clicks the Insert button and then resizes the photo in the worksheet.
He finds and inserts the third store’s photo and now his table is complete. He wants to keep a reference for a webpage next to the table. With a browser open to the website, Maurice copies the web address and goes back to his Excel workbook. He selects a cell and pastes the address directly into the workbook.
Bonus Advanced Integration
Maurice wants to conduct research on current dairy prices to help him decide on the sales percentage. Excel has a function to allow tables from websites to be imported into a worksheet. Maurice already knows the website he wants to follow (http://www.dairy.com/market-prices).
He takes the following steps to set up the table in a new workbook tab.
- First, he clicks on the Data tab, then selects the Get Data > From Other Sources > From Web.
- He then types in his webpage address into the dialog box and clicks OK.
- This sends Excel out looking for the website and its data. It then displays a dialog box with the information it can read. Maurice selects Table 1 and clicks the Load button.
- The data table from the website is now pulled into his spreadsheet. Hooray!
- Maurice wants to make sure he has the most up-to-date information. He clicks the Data tab > Properties button > Query Properties button.
- A new dialog box opens and he checks the box to Refresh every 60 minutes. He can change this to whatever time frame he desires to make sure he always has updated data.
- The data table now refreshes and Maurice can conduct his research on the market price of dairy commodities.
Internet and Word
Rowan Retail Store #1 is using Word to present their plan for the Q3 sales campaign. The campaign for this store will be through social media and the focus on selling more sporting goods in the store. Shanda Bates is creating the Word document.
First, Shanda opens Word on her computer and decides she will use a report template. She searches for business reports. Word’s search bar uses the internet to find thousands of report templates for Shanda to use. This is one way the internet is integrated into a Word document.
After Shanda selects and downloads the report template, she types in the titles and other information on the first page.
Next, Shanda begins to compose the plan and wants pictures and icons to add where appropriate, so she opens a web browser and searches for images. To find usable images she selects the Tools>Images for reuse option, which sorts the images to fit this parameter. Shanda finds a little shop icon, copies (Ctrl+C) and pastes (Ctrl+V) it into the report. She then drags it and resizes it to fit.
She continues to search for images, but this time she uses the Online Pictures button within Word to find a usable Facebook icon.
She searches and finds an appropriate icon and clicks to insert it in her document.
After resizing the icon, Shanda wraps the text by the icon so that it fits on the page with the text.
Shanda thinks that including a link to the social media strategy video she watched to create this plan is a good idea. She searches and finds the video in YouTube, then copies the link and pastes it into the plan. Alternatively, she could click the share button and share the video on various social media platforms.
She continues to fill in the text of the plan and finish this report off. Let’s have a quick recap of the integration actions she took.
- Store icon. Shanda searched the internet for an appropriate icon, copied it, pasted it, resized it, chose a layout, and dragged the icon to the place in the document she liked.
- Hyperlinked YouTube page. Shanda included a link to the video by finding the video on YouTube, then copying and pasting the link into the report. The link can now be clicked to take the reader to watch the video.
- Graphic chart. Shanda searched with Word’s Online Picture button and found a chart to display her social media campaign plan’s purpose. Like before, she copied the chart, pasted it, resized it, chose a layout, and centered the chart.
- Facebook icon. Shanda searched with Word’s Online Picture button to find the Facebook icon to put next to the Facebook section in her report. She copied it, pasted it, resized it, and picked the appropriate layout option, then dragged the icon to the appropriate place in the document.
These same processes of search, find, copy, paste, resize, and so on are going to be the same in Excel and PowerPoint.
Internet and PowerPoint
Rowan Retail Store #3 is using PowerPoint to present their campaign plan for the Q3 sales campaign. The campaign for this store is to use point-of-purchase displays to sell more gift cards for the company. Luke is creating the Q3 Plan PowerPoint presentation. He has settled on a presentation template and added the title slide.
He has now added a number of slides and is ready to enter text and more.
Luke selects two images and inserts them in the slide. He decides on the image on the right and selects a slide design with that image. He also changes the name of the slide.
Now he searches for and adds more images that show ideas for displaying the gift cards.
Luke opens a browser and searches for gift card display ideas. He finds a link to a webpage and is brought to a Pinterest page. He likes the ideas and snaps a screenshot by pressing the PrtScn button on his keyboard. This copies the screen and he can now paste (Ctrl+V) the screenshot into a slide.
He now wants to add in the hyperlink to the webpage under the screen shot. He clicks on the Text Box button in the Home tab and creates a text box under the picture. Next, Luke toggles back to the browser window (Alt+Tab), selects the website address, and copies it with Ctrl+C.
He pastes the hyperlinked address in the text box. He will now continue to add in text, tables, and charts associated with his point-of-purchase plan.
Check Your Understanding
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.