What wins in a conflict between custom and exclusion dictionaries? In Office-Watch.com we’ve talked about the custom dictionary (which lets you add words to the Office dictionary) and the exclusion dictionary (which removes words that would otherwise be considered OK. But what happens if a word is in both the custom and exclusion dictionary? That […]
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 […]
