Excel

What happens when 9 Excel power users come to Microsoft campus?

Excel is a tool that means different things to many different people. And with the app available for the PC, Mac, web and even your phones and tablets, the ways in which Excel is being used is expanding like crazy. So it is important for our team to continuously learn from our diverse customers. In November, we decided to try a new way of engaging with some of our most…

Excel

Office 365 Search is now smarter about spreadsheets

Businesses use spreadsheets for many critical functions, such as financial reporting and investment modeling, and they need to minimize the risks that using these spreadsheets introduces. The need for strong spreadsheet management is emphasized in these stories compiled by the European Spreadsheet Risk Interest Group (EuSpRIG). Office responded to this need by introducing new features in Office 2013 to help manage the use of spreadsheets for important business functions, and…

Excel

Find all your data connections with Office Discovery and Risk Assessment

Do you need to find out where your data is being used? More specifically, how can you find Excel workbooks that have data connections to your databases? We went to SQL MVP Scott Stauffer to help answer that question. Scott is helping his client launch a data warehouse that will be the preferred source of data for many areas of the business. The client is also planning to switch to…

Excel
SUMMARY_ExcelRestAPI_258x143

Excel REST API in SharePoint Online

Excel Services on SharePoint offers a bunch of ways for developers to extend the power of Excel and integrate Excel workbooks into larger solutions. Originally, to take advantage of this, you needed to deploy and maintain your own SharePoint servers. The world has changed, though: With Office365 for business, you can access the power of Excel Services on SharePoint through the cloud. Here’s an example to help you get started using…