Project

Creating burndown charts for Project using Power Pivot and Power Query

When you are managing a project and tracking the work done versus the work planned or the remaining time left, it is common to use a burndown chart. In this article, we show you how to create a report of all tasks for the last 90 days, using Excel 2013 and oData streams. This example will also introduce you to some key Power Query and Power Pivot functions.

Office 365

Announcing Office 365 Personal: A new way to access Office 365!

At last week’s SharePoint Conference, we discussed Office 365 for business investments and got some outstanding feedback from customers. Now it’s time for a few updates for our consumer customers using Office 365 – 3.5 million subscribers and counting. Today I want to announce Office 365 Personal. Coming this Spring, Office 365 Personal is a new, great option for people interested in using Office 365.  It’s designed for an individual, allows…

Office 15-Minute Webinars
Image from webinar

Webinar: Working with Office Online and OneDrive

Office Online is more than the new name for the free, browser-based versions of Word, Excel, PowerPoint, and OneNote that anyone can use on multiple devices. We’ll show you how to collaborate with others in real time and store documents in the cloud (yes, we’ll explain that too) with OneDrive and 7 GB of free storage. What you will learn at Tuesday’s webinar Create & share docs for free with Office Online Storing docs with…

Updates

Office 2013 Service Pack 1 now available

Today we’ve released Service Pack 1 (SP1) for the 2013 set of Office products including Office 2013, SharePoint 2013 and Exchange Server 2013. SP1 delivers greater stability, expanded functionality, security enhancements and improved compatibility with Windows 8.1 and Windows Server 2012 R2. Office 2013 customers will begin to get notifications of SP1 availability through Windows Update within the next 30 days. Exchange Server 2013 and SharePoint 2013 customers can download SP1 at…

Office Online
Use Office Online at Office.com

Introducing Office Online at Office.com

Today, you’ll notice something new about Office.com and Office Web Apps–now officially called Office Online.  An online version of the Office you know and trust has been available for quite a while, but with today’s updates, we’ve made your Office Online experience easier to find, share and collaborate with others. Sure, some of you are already using the online versions of Office. And with the recent addition of real-time co-authoring…

Office 15-Minute Webinars
Image from webinar

Webinar: How Office works on an 82-inch touch screen

The webinar is over. Check back in a few days to see the video. Like working on your tablet or smartphone? Imagine one bigger than your TV. Perceptive Pixel by Microsoft delivers exceptional, multi-purpose touch devices for brainstorming, collaboration, and interactive presentations. In this week’s webinar, we’ll show you how Excel, PowerPoint, and OneNote work on a 82-inch screen. Click the…

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…

Power BI
PowerBI_GA_02_summary

Power BI for Office 365 now available to do more with business insights in Excel

Today we’re happy to announce that we’re making Power BI for Office 365 generally available to a billion Office users. Since announcing and previewing Power BI for Office 365, we’ve been continually adding new features and with today’s general availability customers can now make more informed decisions by discovering, analyzing, and visualizing their data in Excel and sharing through Power BI for Office 365.

OneNote
Go to onenote.com and sign in

Use OneNote anywhere with the OneNote Web App

The OneNote Web App lets you capture and access notes and ideas from any web browser. With no download required, you can use it anywhere: at your friend’s house, at the airport, or even on a device that doesn’t have OneNote already installed. If you’re new to OneNote, it’s fast and easy to give OneNote a quick spin on the web. You also can download it for your Windows, Windows Phone,…