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…

Excel

Practical PivotCharts in Excel

PivotCharts allow for charting-based data exploration and summarization in a way that no other Office visualization can. But they also offer power and flexibility that are largely unknown to many standard chart users, unless they work across businesses where PivotCharts play a significant role within their business intelligence efforts. Like PivotTables,PivotCharts work really well on aggregate data, which is why a lot of casual Excel analysts don’t often encounter the…

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!