You can also go to 'Data' tab in the ribbon and click on the button 'From Web'. If you import a site (e.g. http://bitcoincharts.com/markets/mtgoxUSD.html), you'll be able to get some data. I hope I helped 
Unfortunately Im runnog office 2012 for OSX and none of these funtions appear. I appreciate the link though. I can't believe this is that hard to do
.