In the finale of our three part deep dive on customizing and deploying the new Office, our intrepid hosts demonstrate Office 365 ProPlus Click-to-Run integration with your existing management and deployment tools while exploring pre-installation via Windows image. Watch too as our fearless host Jeremy gets behind the wheel to test if Windows Intune can install Office as fast as a direct install from Office 365 from his car, in the time it takes him to go over Seattle's famous 520 floating bridge.

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.

We're excited to announce that a preview of Skype video calling and messaging is starting to arrive in Outlook.com--making it easier to stay connected to the people you care about most. Your Skype contacts appear in your contact list, so the next time you get an email from someone, you can call them back with just a click.

Many of our users expressed the need to be able to draw on the touch devices that do not ship with a pen. With this update to OneNote for Windows Store, now you can draw with your finger! Read on to learn how and to download the update.

Office.com receives over 3,000 customer messages a week-and we dig through them all. In this webinar, we bring you answers to the top questions and comments about the new Office and Office 365 Home Premium.

What you will learn at Tuesday's webinar

• What is the difference between Office 365 and Office 2013?
• What to do if you want to work offline, or don’t want the cloud...

Every couple weeks we round up industry news and articles you might have missed. Read on for our latest selections.

According to Felicity Huffman, "If Office 365 is like having your office travel around with you, OneNote is like having an office assistant combined with my own personal tutor right there in my big Mom bag that I carry around everywhere." Read on to find out how Felicity uses OneNote to keep everything straight and how to enter her Mother's Day Giveaway of four Surface RT tablets, all equipped with Office 2013 Home and Student RT with OneNote 2013 RT and other Office 2013 RT applications.

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.

Visually displaying always up-to-date information on clearly laid out diagrams helps to communicate information effectively. In this post, we will see how to connect data from external sources to a diagram. Associating data with shapes on a diagram does not require any code. Learn how to use the simple wizard which guides you through linking your data source to your diagram.

This week marks the second in a three part series, as hosts Jeremy Chapman and Yoni Kirsh, explore potential workarounds for your Office configuration, from removing and blocking applications such as Outlook, Word, PowerPoint, Excel, OneNote, Access and Lync that come with the new Office 365 ProPlus, using multiple languages, disabling the first run video to changing update properties and much more. Hear too from our lead Office set-up engineer, Paul Barr.