Skip to main content
Microsoft 365

The Microsoft 365 Marketing Team Posts

Subscribe
Microsoft
The Microsoft 365 Marketing Team
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.
Team collaboration around a laptop in an office.
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.
Published 
12 min read

What’s new in SharePoint Online–top 10 

<p>SharePoint Online (SPO) has a gaggle of new innovation and welcome improvements. The premier sharing service is updated with a new, fluid user interface, active personal file sharing, higher storage limits for both personal and team sites, a high-end cloud app development model, and more robust tooling for admins to more easily and effectively control their SPO environment. Everyone benefits from the new SharePoint Online! Users benefit with new ways to share internally and externally and anonymously, in how they search and discover the right information and people and how they build sites and experiences in a more self-service fashion. Project managers now have better ways to organize documents, project details and timelines. Developers are no longer limited on the types of solutions they can deliver to the Office 365 cloud. IT Professionals can more easily manage sites and permissions on behalf of their entire company. This article will cover the top 10 new SPO innovations with a pointer at the end to the new SPO service description - home to all SharePoint features across all offerings (online and on-premises).</p>
Published 
1 min read

Business Process Modeling with Visio at the Gartner BPM Summit 

<p>The new Microsoft Visio, powered by interoperability with Microsoft SharePoint and Office 365, provides a strong social, mobile and cloud-based infrastructure for Business Process Modeling (BPM). In addition to the newer workflows and collaboration features, it also offers several new diagram templates that support the latest industry standards, such as BPMN 2.0 and UML 2.4. Look for us at the Gartner BPM Summit April 2-4, 2013 as we take our very compelling and well-recognized BPM story to the Washington D.C. area. Microsoft is a Platinum sponsor of the summit, and we are very excited to speak with a variety of customers, partners, analysts and press while at the event. Do join us if you can!</p>
Published 
5 min read

Format and customize Excel 2013 charts quickly with the new Formatting Task pane 

<p>The new Excel makes creating and customizing charts simpler and more intuitive. One part of the fluid new experience is the Formatting Task pane, which replaces the Format dialog box. The new Formatting Task pane is the single source for formatting--all of the different styling options are consolidated in one place. With this single task pane, you can modify not only charts, but also shapes and text in Excel. </p>