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. […]
Updating Office 207 can literally go on forever! Many users are reporting a problem with the patches for Office 2007. The three troublemakers are: http://support.microsoft.com/kb/2760583/ (KB 2760583) http://support.microsoft.com/kb/2760411/ (KB 2760411) http://support.microsoft.com/kb/2760588/ (KB 2760588) No matter how many times you install them, manually or automatically. Given the widespread nature of the problem, across different versions of […]
How accurate is Excel compared to universal needs. On page 45 of the Sept/Oct 2013 Mental Floss magazine is a small item ‘Why do we care so much about the digits if Pi’ which includes this trivia: “The computers that keep the International Space Station humming round off pi at a crude 16 digits. When […]
Evernote for Android now comes with the ability to edit Office documents. Our favorite notemaking system, Evernote, now has the ability to edit Office documents within their Android version. Yes – we very much prefer Evernote over Office Onenote. Evernote runs very well, syncs seamlessly and completely across all popular platforms and devices. Evernote has […]