Excel

Manage your spreadsheets with Data Validation in the Excel Web App (aka an awesome tool to prevent your friends from messing up your data)

If you’ve ever wanted to leverage the power of Data Validation in Excel combined with the flexibility of Web Excel, now you can!  In this post we walk through an example of how easy it is to collect information from a group of friends through Web Excel without having to worry about managing emails, receiving incorrect data, or manually aggregating information.   Read on to learn more!

Excel

Automatically plot multiple pieces of online data in your Excel spreadsheet

If you’ve ever wanted to incorporate data from online resources into Excel spreadsheets, now you can with the new Webservice function. With this new feature, you can add information such as stock quotes, weather, Bing Search results or even Twitter feeds to your spreadsheets–and you can make the information update automatically. In this post, we’ll discuss some of the more advanced aspects of the Webservice function.  Read on to learn…

Excel

Exciting new BI features in Excel

Yesterday during the Microsoft’s Worldwide Partner Conference we announced some exciting new Business Intelligence (BI) features available for Excel. Specifically, we announced the expansion of the BI offerings available as part of Power BI–a cloud-based BI solution that enables our customers to easily gain insights from their data, working within Excel to analyze and visualize the data in a self-service way.  Read on to learn more!

Excel

Adding rich data labels to charts in Excel 2013

Storytelling is a powerful communication tool, and data is essential for many decision-making tasks. Together, they can be data visualization at its best: the science and art of transforming your data so that the most important points shine through. Sometimes a basic chart will do the trick. But to make your visual message really pop, it’s often handy to add data and text to your chart. The rich data label capabilities…

Excel

Opening workbooks by running separate instances of Excel

In Excel 2013, each of your workbooks opens in its own window, similar to Word and PowerPoint. This means that each workbook has its own ribbon and top-level window frame that you can move and resize independent from your other open workbooks. This functionality can improve multitasking, visibility, and analysis across workbooks. In this post, we’ll discuss some of the more advanced aspects of these changes, in particular how to…

Excel

Simplify management of an Excel Power View template by using a VSTO add-in

Templates are one of the cornerstones in modern professional Excel development. By using one or more templates, we can provide a structural approach for end users to acquire, store and present data. From a development point of view, we can simplify the maintenance. In this tutorial, Excel MVP Dennis Wallentin shows how to simplify management of a Power View template by using a VSTO add-in.

Excel

New server release: Spreadsheet controls in Office 2013

In April, we released 2 important new spreadsheet management server-based applications to complement the desktop spreadsheet management features we introduced with the release of Office 2013. Now available are Audit and Control Management Server (ACM), and Discovery and Risk Assessment, which are both designed to help you manage the use of spreadsheets and Access databases.  Read on to learn more.