Conditional Formatting Rules Simplified
Conditional formatting is a popular feature and is a great way to easily identify cells with a range that meet some criteria.
Enterprise
See how enterprise organizations are leveraging Microsoft 365 to drive digital transformation, enhance business operations, and improve employee productivity. Gain insights into innovative solutions, best practices, and success stories tailored for large organizations.
Refine results
Product
Audience
Publish date
-
-
Change the default line spacing in Word
When the default line spacing in documents changed from single spacing in Word 2003 to a slightly roomier 1.
-
Tip: Add a watermark to an Excel worksheet
If you’re collaborating or creating sensitive material in Excel, you probably need either a DRAFT or CONFIDENTIAL watermark.
-
5 tips on using Bcc in Outlook email
It’s kind of funny that a software application would use abbreviations that refer to pre-software days. -
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. -
VLOOKUP Tutorial: Updating prices in a master price list
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.
-
Using multiple criteria in Excel LOOKUP formulas
If you want to look up a value in a table using one criteria, it’s simple. -
Using a Combo Box to search as you type
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.
-
Grouping emails by conversations
Have you ever had to find an email that was part of a long thread–an email with lots of replies about the same topic? For example, your boss might have asked for the results of last month’s important meeting, and you know Sherry sent an email outlining them, but then you remember that Todd followed hers with more information.
-
Quick Trick: Resizing column widths in pivot tables
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.
-
Filtering emails in Outlook
Outlook offers several ways to filter emails.
-
Using crosstab queries in reports
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.