Examine US public health data in Excel. One of the great things about the recent Internet is the availability of previously hidden data. Large blocks of information have been collected, checked and published online. Combine that with a tool like Excel and you can do your own analysis! Here’s just one example of what’s available […]
An example of web scraping from BestBuy.com into Excel. We’ve already talked about getting prices from the Amazon.com web site into Excel with automatic updates. Now let’s look at how to do it for BestBuy.com prices.Excel has had a method of web scraping for many versions you can find it at Data | Get External […]
How to check Amazon product prices automatically in Excel. With Black Friday coming in the USA, it’s time to carefully check prices and look out for bargains. Ideally get those prices automatically and put them into Excel for comparison. To do that for Amazon means ‘scraping’ or trying to grab prices from a web page. […]
How to copy an image from the web into an Office document. Getting an image from your web browser to a Word document is quite easy, though easier with some browsers than others. In your browser, right-click over the image you want and look at the options available. At the very least there’ll be an […]
The Vatican’s latest mistake can be blamed on Microsoft … if you try hard enough. A good laugh can be had with this news from the Vatican: “A commemorative coins issued by the Vatican has been withdrawn because it spells the word ‘Jesus’ incorrectly”. You’d think that knowing how to spell the name of the […]