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!

Office 365

What powers Power BI in Office 365?

Power BI for Office 365 is a new self-service business intelligence (BI) offering enabling businesses to gain insights from their data in powerful new ways within Excel and Office 365. Customers now have the ability to easily search, discover and access data inside and outside of their organization and, with just a few clicks, shape and transform that data. They can also analyze and create stunning interactive visualizations that uncover…

Excel

We’ve Updated Excel Web App – What’s New as of June 2013?

About a month ago, we announced that Excel Web App and the Office Web Apps are destined to become a comprehensive productivity experience on more browsers and devices (not just companions to the desktop applications). We didn’t give any specific timelines as part of that, but last week we released our first feature update since that announcement. I’m excited to share some of the awesome new things you can do…

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…

News

Office is a life skill for graduates on the job hunt

A recent survey caught our attention this week, revealing that 83% of millenials say technology makes it easier to get a job. We couldn’t agree more. Computer skills, and proficiency in Microsoft Office in particular, are fundamentals most employers expect. With this in mind, we wanted to share resources that will help the class of 2013–and beyond–brush up on Office skills and stand out from the crowd.

Office 365

The Garage Series for Office 365: First look at new real-time co-authoring for Office Web Apps across Windows, iOS and Android

The second of our six-part show special on location from New Orleans where hosts Jeremy Chapman and Amanda Lefebvre take a pre-release, first look at upcoming Office experiences on the Web. We walk you through real-time co-authoring beyond pure text editing across Word, PowerPoint and at a cell level in Excel, as well as net new capabilities previously only available on the desktop. Watch too as we challenge a local…