One of the things that is incredibly satisfying about working on the Excel team is seeing how people use Excel in unbelievably cool and unexpected ways for work and for fun. There have been a few great examples of this floating around the internet and the news recently–here are some favorites. Read on to learn more!
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.
CTRL+PgUp, CTRL+F, SHIFT+TAB: keyboard shortcuts can help you streamline work in Excel and look like a magician in a spreadsheet. We’re currently planning the next round of keyboard shortcuts to add to Web Excel and would love to hear your input. Let us know about your favorite shortcuts in desktop Excel by filling out this survey.
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…
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.
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.