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!
Our friends over in the Power BI Blog posted an in-depth walkthrough of the new features available as part of Power Query and Power View. In particular, how to create a cool time series scatter plot/bubble visualization. Read on to learn more about these new features to enhance the BI capabilities of Excel and how to register for the new Power BI for Office 365 preview.
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…
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!
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…
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…
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.
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.
Yesterday we announced some exciting news about Web Excel (and all of the Office Web Apps) over on the Office 365 Blog. Specifically, we announced that we’ll be improving the Web Apps to be a comprehensive productivity experience (not just a companion to the desktop applications) on more browsers and devices over the next year and beyond. Head on over to the Office 365 blog to check it out!
Ever had to sum data based on multiple criteria situated in different Microsoft Excel worksheets? In this tutorial, Excel MVP Liam Bastick provides a quick tour of INDIRECT references and Table functionality while combining qualities of the SUMPRODUCT function with the SUMIFS function, providing a solution to the mother-of-all Multiple Criteria problems.
One of the improvements we made for Office 2013 to the way users work with Charts in Word and PowerPoint is to make the data grid easier to use and less intrusive. Now the data grid is displayed in a streamlined small input window that floats above the chart. Read on to find out more about these improvements.