Skip to main content
Microsoft 365

Microsoft 365 Blog

End of featured posts section

Recent articles

Published 
8 min read

Office and the Cloud 

<p>  The transitions that organizations and people are making to the cloud enable many new opportunities for sharing with others.  We believe that the best way to leverage the cloud is to connect the best-of-breed applications to feature-rich services.  We do not believe that a one-size-fits-all browser based solution is suitable to meet the needs of both work and personal computing because it misses so many opportunities to leverage the power of rich applications. We know that people work online and offline - internet connectivity should never be a barrier to productivity.  These beliefs underlie our work in connecting Office to the cloud and shape our philosophy for the entire release. In this post, we'd like to talk about how we've taken Office and connected it more naturally to the cloud. Let us know what you think about these new capabilities and please give us feedback about what you'd like to hear more about in the coming posts.</p>
Published 
2 min read

Email stuck in your outbox? Try this. 

<p>"What do you mean you didn't receive it? I sent it last night!" At least you thought you did. Now you're red-faced in a meeting set up to review the PowerPoint presentation that never made it to your recipients.  You check your Outbox and there it is. If you ever find yourself in this situation, here are some reasons why and some steps you can take.</p>
Published 
4 min read

Combining chart types, adding a second axis 

<p>It's often helpful to create charts that compare different types of data. For example, you might want to compare overall revenue with the number of units sold. To do that you need to know how to use different chart types in one chart and how to use a secondary vertical axis to plot values that are in a different value range. Read more to learn how. (Sample workbook included)</p>
Published 
2 min read

Using crosstab queries in reports 

<p>A well designed database stores data in a normalized format with dates defined in a field so that new data is simply added as additional records. However, people want to see data with dates grouped by columns. This can be done by using a crosstab query. However, when creating reports based on crosstab queries, we need to control the specific column names that are returned by the query. Otherwise, the report cannot refer to the query's fields.</p>
Published 
1 min read

Quick Trick: Resizing column widths in pivot tables 

<p>Who could be better than a Business Intelligence analyst at teaching us a thing or two about Excel? We asked our own number-crunching wizard Stacey Armstrong to share some Excel tricks she's learned along the way. In this first one, she shows us how to change the default width of a column in a pivot table. Knowing this is especially helpful when you're working with data that that makes a row really long.</p>