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.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?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. As the user types, the form filter updates to display full or partial matches for the value entered.![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.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. This tutorial assumes you’ve heard about VLOOKUP and its benefits, but that you don’t really know how to use it.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.![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)