Skip to main content
Microsoft 365

Microsoft 365 Blog

Recent articles

Published 
3 min read

Opening workbooks by running separate instances of Excel 

<p>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 have workbooks running in different instances (or processes) of Excel. </p>
Published 
1 min read

SkyDrive Pro client for Windows now available 

<p>We are pleased to announce that the SkyDrive Pro sync client is now available for Windows. This standalone client allows users of SharePoint 2013 and SharePoint Online in Office 365 to sync their personal SkyDrive Pro and any SharePoint 2013 or Office 365 team site document libraries to their local machine for access to important content on and offline. The SkyDrive Pro client can be installed standalone and does not require any version of Office to be installed.  It can also be installed side-by-side with previous versions of Office (Office 2010, Office 2007).</p>
Published 
4 min read

Summing data across multiple criteria on multiple worksheets 

<p>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.</p>
Published 
3 min read

Data-linked diagrams: Linking data from an external data source 

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.
Published 
2 min read

Outlook.com gets two-step verification, sign-in by alias and new international domains 

<p>As announced earlier today, over the next few days we are releasing an update to Microsoft account. For people who use Outlook.com, this includes a number of new features such as two-step verification, the ability to sign in with an alias and new international domains for your email address. Read on to learn about this new feature and how to set it up. </p>
Published 
3 min read

Using conditional formatting to highlight dates in Excel 

Date functions in Excel make it possible to perform date calculations, like addition or subtraction, resulting in automated or semi-automated worksheets. When you mix date functions with conditional formatting, you can create spreadsheets that display date alerts automatically when a deadline is near or differentiate between types of days, like weekends and weekdays. In this tutorial, learn how to put this functionality to work, with some examples in the Excel Web App so you can experiment with the results.