We’re in the middle of a series on getting live internet data directly into Excel and it’s been a pleasant surprise. Currency Exchange Rates and Stock/Index data can automatically update your Excel worksheets. Microsoft has been improving the data connection features in Excel, especially Excel for Windows. It’s happened gradually and not always communicated well […]
Visio is coming to mobile devices, according to Microsoft. Apple, Android and Windows. The Visio for iPad preview program was started last month. The app lets you view Visio diagrams that reach your iPad from email, OneDrive, OneDrive for Business and Sharepoint. View files from OneDrive, OneDrive for Business, or SharePoint – files received as email […]
Last week we showed you how to get currency exchange rates into Excel as well as the overall method for grabbing info from the web to add to your worksheets. We had a lot of feedback (thanks) and it’s clear that many readers want a simple way to import the latest stock prices into Excel. […]
Here’s another method of getting stock prices into Excel. It’s part of a series: introduction and using MSN Money in Excel. This time we’ll use the improved Query system in recent versions of Excel combined with data from Google Finance. It’s a sad indictment of Microsoft Office that the best place to get stock data […]
Here’s how to grab stock price and indexes into Excel via MSN Money. It’s part of our series on getting ‘live’ data into Excel – Introduction and the Google Finance option. Microsoft dropped the MSN stock quotes option from Excel but they are still available. Use the ‘web page scraping’ part of Excel to do […]
