Chrome Now Tops IE

atlas_hktypzhb

According to NetMarketShare Chrome now accounts for 41.66% of the browser market, 0.31% more than Internet Explorer and Microsoft Edge—Microsoft’s replacement for Internet Explorer. NetMarketShare also tracks the market share of search engines and mobile operating systems, both of which Google also dominates.

via Quartz. Click here to download market data

 

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.