Microsoft 365 Blog
Recent articles
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>![Small conference meeting in modern workspace.](https://www.microsoft.com/en-us/microsoft-365/blog/wp-content/uploads/sites/2/2022/10/Ofc17_Meeting_012-300x200.jpg)
Using multiple criteria in Excel LOOKUP formulas
If you want to look up a value in a table using one criteria, it's simple. You can use a plain VLOOKUP formula. But if you want to use more than one criteria, what can you do? There are lots of ways using several Excel functions such as VLOOKUP, LOOKUP, MATCH, INDEX, etc. In this blog post, I'll show you a few of those ways.Working with the Toshiba Portégé Z830
For the past few weeks I have been working with the sleek and stylish Toshiba Portégé Z830. The Portégé Z830 is one of the lightest 13” PC on the market, weighing in at just under 2.5 pounds, and incredibly thin at just 16 mm (a literal hair over 0.6”). The Portégé Z830 is an UltrabookVLOOKUP 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>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…![Sun-Hi engaged in focused work on her laptop​ Keywords: Viva; hybrid work; work from home; remote; woman; female; smiling; typing; leaning on a tabletop; office; on the go; scrolling; checking email; connected; empowered](https://www.microsoft.com/en-us/microsoft-365/blog/wp-content/uploads/sites/2/2022/10/CLO22_HybridWork_080-300x200.jpg)