<div>
<div class="ns-school-defn2">
<h3>Learning Objectives</h3>
<ul>
<li>Use internet tools to enhance Excel workbooks.</li>
</ul>
</div>
<p>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.</p>
<p>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.</p>
<div><a href="https://data.ulearngo.com/assets/e22f86f1-1ea3-47d4-acaa-8a3c70c4e8ea"><img alt="A Microsoft Excel sheet for a sales campaign is displayed in the cells. A bing search for store 2 is displayed in front of the excel spreadsheet." height="423" src="https://data.ulearngo.com/assets/e22f86f1-1ea3-47d4-acaa-8a3c70c4e8ea" srcset="https://data.ulearngo.com/assets/8added39-7c06-4ac7-9856-31ded7fde717 928w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162155/excelinternet1-300x159.png 300w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162155/excelinternet1-768x406.png 768w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162155/excelinternet1-65x34.png 65w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162155/excelinternet1-225x119.png 225w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162155/excelinternet1-350x185.png 350w" width="800"/></a></div>
<div><a href="https://data.ulearngo.com/assets/5cef2d49-5ae2-4d20-828c-abe27376a3e9"><img alt="A Microsoft Excel sheet for a sales campaign is displayed in the cells. An image of a store has been inserted over the excel sheet." height="422" src="https://data.ulearngo.com/assets/5cef2d49-5ae2-4d20-828c-abe27376a3e9" srcset="https://data.ulearngo.com/assets/5eefd335-a740-4859-aa87-910e3052ad98 928w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162222/excelinternet2-300x158.png 300w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162222/excelinternet2-768x406.png 768w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162222/excelinternet2-65x34.png 65w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162222/excelinternet2-225x119.png 225w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162222/excelinternet2-350x185.png 350w" width="800"/></a></div>
<p>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.</p>
<div class="ns-school-defn2">
<h3>Practice Question</h3>
<div class="video-container">
<div class="responsive-video"><iframe frameborder="0" src="https://assessments.lumenlearning.com/assessments/load?assessment_id=5423&amp;embed=1&amp;external_user_id=&amp;external_context_id=&amp;iframe_resize_id=lumen_assessment_5423"></iframe></div>
</div>
</div>
<h2>Bonus Advanced Integration</h2>
<p>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 (<a href="http://www.dairy.com/market-prices" rel="noopener" target="_blank">http://www.dairy.com/market-prices</a>).</p>
<p>He takes the following steps to set up the table in a new workbook tab.</p>
<ol>
<li>First, he clicks on the <strong>Data</strong> tab, then selects the <strong>Get Data</strong> &gt; <strong>From Other Sources</strong> &gt; <strong>From Web</strong>.</li>
</ol>
<div><a href="https://data.ulearngo.com/assets/85980d3b-cc8e-41b4-97ce-47bc76828743"><img alt="A Microsoft Excel sheet for a sales campaign is displayed in the cells. The data tab in the ribbon menu has been selected. A dropdown menu from the get data has opened and the option to get data from other sources has been selected leading to another dropdown menu. The option to get data from the web has been selected." height="422" src="https://data.ulearngo.com/assets/85980d3b-cc8e-41b4-97ce-47bc76828743" srcset="https://data.ulearngo.com/assets/6ffe223b-f8d9-4072-bbd2-f28eba92e396 928w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162714/excelinternet3-300x158.png 300w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162714/excelinternet3-768x406.png 768w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162714/excelinternet3-65x34.png 65w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162714/excelinternet3-225x119.png 225w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162714/excelinternet3-350x185.png 350w" width="800"/></a></div>
<ol start="2">
<li>He then types in his webpage address into the dialog box and clicks <strong>OK</strong>.</li>
</ol>
<div><a href="https://data.ulearngo.com/assets/2100a621-b11d-41a0-b837-350d6fe24316"><img alt="A blank Microsoft Excel sheet is open. A search dialog box has been opened and a link has been inserted from where to get the new data from." height="422" src="https://data.ulearngo.com/assets/2100a621-b11d-41a0-b837-350d6fe24316" srcset="https://data.ulearngo.com/assets/606fee40-2221-4bbe-8b08-c2b3427cae9f 946w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162916/excelinternet4-300x158.png 300w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162916/excelinternet4-768x405.png 768w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162916/excelinternet4-65x34.png 65w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162916/excelinternet4-225x119.png 225w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28162916/excelinternet4-350x185.png 350w" width="800"/></a></div>
<ol start="3">
<li>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 <strong>Load</strong> button.</li>
</ol>
<div><a href="https://data.ulearngo.com/assets/2c5d6fa3-f44e-4b85-b147-d919f596d95a"><img alt="A blank Microsoft Excel sheet is open. The search dialog box has returned several results but the option to select and load table one is demonstrated." height="424" src="https://data.ulearngo.com/assets/2c5d6fa3-f44e-4b85-b147-d919f596d95a" srcset="https://data.ulearngo.com/assets/c139cb5c-e1b6-4836-9341-192b0dc1c83a 946w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163043/excelinternet5-300x159.png 300w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163043/excelinternet5-768x407.png 768w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163043/excelinternet5-65x34.png 65w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163043/excelinternet5-225x119.png 225w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163043/excelinternet5-350x185.png 350w" width="800"/></a></div>
<ol start="4">
<li>The data table from the website is now pulled into his spreadsheet. Hooray!</li>
</ol>
<div><a href="https://data.ulearngo.com/assets/c698348f-b20f-432b-9d73-451fb330b0a0"><img alt="An excel sheet is open with the newly loaded data table inserted." height="423" src="https://data.ulearngo.com/assets/c698348f-b20f-432b-9d73-451fb330b0a0" srcset="https://data.ulearngo.com/assets/ed89236e-7211-4a22-a795-4d6efab1035a 946w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163211/excelinternet6-300x159.png 300w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163211/excelinternet6-768x406.png 768w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163211/excelinternet6-65x34.png 65w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163211/excelinternet6-225x119.png 225w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163211/excelinternet6-350x185.png 350w" width="800"/></a></div>
<ol start="5">
<li>Maurice wants to make sure he has the most up-to-date information. He clicks the <strong>Data</strong> tab &gt; <strong>Properties</strong> button &gt; <strong>Query Properties</strong> button.</li>
</ol>
<div><a href="https://data.ulearngo.com/assets/c7c08907-5a16-4b30-9d30-a846043056fd"><img alt="An excel sheet is open with the newly loaded data table inserted. There are three green arrows, the first one is pointing at the data tab in the ribbon menu. The second is pointing at the properties button and the third is pointing at the query properties button." height="422" src="https://data.ulearngo.com/assets/c7c08907-5a16-4b30-9d30-a846043056fd" srcset="https://data.ulearngo.com/assets/166edd33-0d4d-4633-bc86-03e79613ac50 946w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163313/excelinternet7-300x158.png 300w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163313/excelinternet7-768x405.png 768w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163313/excelinternet7-65x34.png 65w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163313/excelinternet7-225x119.png 225w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163313/excelinternet7-350x185.png 350w" width="800"/></a></div>
<ol start="6">
<li>A new dialog box opens and he checks the box to <strong>Refresh </strong>every 60 minutes. He can change this to whatever time frame he desires to make sure he always has updated data.</li>
</ol>
<div><a href="https://data.ulearngo.com/assets/f84ced6d-1d94-42d7-9338-a47fc188c94a"><img alt="An excel sheet is open with the newly loaded data table inserted. The query properties dialog box is open and there are three green arrows displayed. The first one points at the option to set a time to refresh the table, the second one shows that the time has been set to 60 minutes and the third arrow shows that the ok button has been selected." height="422" src="https://data.ulearngo.com/assets/f84ced6d-1d94-42d7-9338-a47fc188c94a" srcset="https://data.ulearngo.com/assets/b1fc2e1c-2025-4652-87ba-a1b01c6bd19b 909w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163417/excelinternet8-300x158.png 300w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163417/excelinternet8-768x406.png 768w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163417/excelinternet8-65x34.png 65w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163417/excelinternet8-225x119.png 225w, https://s3-us-west-2.amazonaws.com/courses-images/wp-content/uploads/sites/1844/2017/07/28163417/excelinternet8-350x185.png 350w" width="800"/></a></div>
<ol start="7">
<li>The data table now refreshes and Maurice can conduct his research on the market price of dairy commodities.</li>
</ol>
<div class="ns-school-defn2">
<h3>Practice Question</h3>
<div class="video-container">
<div class="responsive-video"><iframe frameborder="0" src="https://assessments.lumenlearning.com/assessments/load?assessment_id=5422&amp;embed=1&amp;external_user_id=&amp;external_context_id=&amp;iframe_resize_id=lumen_assessment_5422"></iframe></div>
</div>
</div>
</div>

f81e5c79-392c-4944-a83a-d60f1aeed2c9

Internet and Excel

Computer Studies deals with general knowledge of computer and computing terminologies and technologies. It concentrates on fostering interest and raising confidence in the use of computing.

Computer Studies

Discover how to integrate Microsoft Office products through lessons on using Word, Excel, and PowerPoint together, creating customized templates, inserting tables and charts, utilizing internet tools, and incorporating videos for presentations with a final assignment to create a mail merge and capstone presentation.


Internet and Excel

Track Your Learning Progress

Earlier discussion