Excel: Insert Tables From Web

Use the Insert from Web option, to quickly import tables from web pages into Excel.

Watch this 2 minute video to see all you need to know.


To Insert Data From Web into Excel

  1. Using your web-browser, locate the content to be imported.
  2. RIGHT + CLICK in the addressbar and select Copy.
  3. In Excel, on the Data tab of the Ribbon, click From Web. A New Web Query dialog will appear.
  4. RIGHT + CLICK in the addressbar, select Paste, and click Go. The source webpage will populate the dialog.
  5. Click the yellow arrow grnarrw next to the table(s) you wish to copy (the icon will change to a green check grnchk  ).
  6. Optionally, click Options and select formatting preference (i.e., None, Rich Text, HTML) then click OK.
  7. Click Import. The Import Data dialog will appear.
  8. Select starting cell to import data to or select “New Worksheet” to import into a new sheet.
  9. Click Properties, uncheck Save Query Definition*, and click OK.
    *Alternatively, to maintain a link to variable data, leave Save Query Definition checked; you will be prompted to ‘Enable Content’ each time the file is opened.
  10. Click OK to complete the import.
Additional reading..

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 190 other followers

MS Office: Insert Screenshot

Need to insert a screenshot into your presentation, document, spreadsheet or email? The Office 2010/2013 Insert Screenshot button makes this easy.

Watch this 60 second video to see all you need to know.


To Insert a Screenshot

  1. Display content window that has the material to capture. Do not minimize this window.
  2. Open or switch to destination application (i.e., MS Word, PowerPoint, Excel, or Outlook).
  3. Place cursor where you wish to insert the screen capture.
  4. On the Insert tab of the Ribbon, click Screenshot button. The available (i.e. not minimized) windows will display as thumbnails.
    • To insert an entire window; select associated thumbnail from the drop-down.
    • To insert a portion of the window previously displayed; select Screen Clipping, then CLICK + DRAG cross-hair around the portion to insert.
Additional reading..

Cheers!

hɔuᴉnb

Comments and questions are always welcome!

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 190 other followers