Skip to main content
Microsoft 365

The Microsoft 365 Marketing Team Posts

Subscribe
Microsoft
The Microsoft 365 Marketing Team
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 
2 min read

Using a Combo Box to search as you type 

<p>Here's a neat trick that you can use to filter a Continuous or Split form while your users are typing in a Combo Box. As the user types, the form filter updates to display full or partial matches for the value entered. This example uses a slightly modified version of the Northwind 2007 Template, available for download from Microsoft. The "Customer List" form is a Split form that displays a list of all customers. We want to allow users to filter this list to easily find a customer, even without knowing the full customer name.</p>
Published 
9 min read

VLOOKUP Tutorial: Updating prices in a master price list 

<p>In honor of VLOOKUP Week, MVP Bill Jelen has created a VLOOKUP tutorial for those of you who have a basic working knowledge of Excel but want to improve your skills. This tutorial assumes you've heard about VLOOKUP and its benefits, but that you don't really know how to use it. Bill uses the example of updating prices in a product list to introduce the value of this time-saving function. </p>
Published 
<1 min read

Yammer + Ultimate Software = More Engaged Workplace 

Today, we are thrilled to announce an integration with Ultimate Software, a leading provider of unified human capital management SaaS solutions, at the company's Ultimate Connections Conference in Las Vegas. The bi-directional integration allows updates from Ultimate Software to appear in Yammer, as well as conversations from Yammer to be published in a custom feed inside…
Published 
1 min read

Change the default line spacing in Word 

<p>When the default line spacing in documents changed from single spacing in Word 2003 to a slightly roomier 1.15 spacing in Word 2007 and Word 2010, customers asked the inevitable: Why did the default line spacing change? And how do I change it back? The short answer is that the default line spacing changed in Word 2007 to make online documents more readable. If you want to change the default line spacing in Word 2007 or Word 2010, or learn how to set the line spacing in a single document, here are the best resources we've found for step-by-step instructions.</p>
Published 
4 min read

Conditional Formatting Rules Simplified 

<p>Conditional formatting is a popular feature and is a great way to easily identify cells with a range that meet some criteria. However, users often want to create conditional formatting rules that go beyond comparing a cell’s value to a single value or a single cell reference - row or column comparisons are commonly requested operations. In this blog post, we will learn how to use relative references in conditional formatting rules to make such tasks easier.</p>
Published 
1 min read

Circular Reference? Excel’s most popular (!#?%) error message explained 

<p>Millions of people using Excel don't get why they see the "circular reference" error message right after they've entered a formula. The message means that your formula is trying to calculate its own cell--kind of like when a dog chases its own tail. Because so many of you (millions) searched on "circular reference" on Office.com, we thought we should very clearly explain how to remove or fix your formula. </p>
Published 
1 min read

Tip: How to cut and paste without messing up formatting 

<p>Why does formatting sometimes get messed up when you cut and paste text? And what is that thing that appears at the end of the last sentence every time you paste-like a fly returning to honey. That thing--the Paste Options button--is your friend, a worker bee and not a fly whose only job is to follow your formatting instructions. Learning how it works keeps you from wasting time manually formatting pasted text. </p>
Published 
3 min read

Customize! 5 table of contents tricks 

<p>The Word 2010 gallery makes adding a basic table of contents quick: Click the References tab, click Table of Contents, and then click the gallery table of contents you want. But what if you want more? What if your table of contents needs to provide different information--more levels, or fewer levels? What if you want a table of contents at the beginning of each chapter? What if you want to change the font? Here are some of the ways you can customize your table of contents.</p>
Published 
3 min read

An IT Professional’s Technology Wish List 

When most people think about making a holiday wish list they think of things like toys, home gadgets, and jewelry. However, if you happen to be an IT professional you may have different items on your list, ones that include upgrading PCs and software and virtualization technologies. We listened to some IT professionals and here