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!

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…