Excel

Use Webservice functions to automatically update Excel 2013 spreadsheets with online data

Have you ever wanted to incorporate data from online resources into your Excel spreadsheets, such as stock quotes, weather, Bing Search results or even Twitter feeds? With new Webservice functions, now you can pull data from the internet into Excel–and the best part is the information updates automatically in your spreadsheet! Read on to find out how to put this functionality to work for you.

Excel

Data Explorer brings Big Data connectivity to Excel 2013

On February 27, we announced an early look at a future addition to our self-service line-up with Microsoft Data Explorer Preview for Excel. Data Explorer enhances the self-service BI experience in Excel by simplifying data discovery and access to a broad range of public and enterprise data sources, enabling richer insights from data that has traditionally been difficult for users to get to. With Data Explorer, users can now quickly…

Excel

Going “Kamping with a K”: How we quickly organized a 20-person trip in Web Excel on SkyDrive

With the announcement of easier collaboration on SkyDrive, sharing files with friends, family and colleagues just got a whole lot easier! Now you can share a link to your Excel files with anyone and they can edit the workbooks without needing to sign in with a Microsoft account, even at the same time! Read on to find out how to put this functionality to work for you.

Excel

New support for query tables in Excel Services improves workbook sharing across an organization

With the enhancements to Excel Services as part of the new Office, we now support query table refresh. Workbooks with query tables now can be seamlessly refreshed on the go from any browser! No need to convert your query table to a pivot table or download a workbook to desktop Excel client to refresh your query table. In other words, broad sharing of workbooks throughout an organization just got easier.