Tutorials, videos, useful tips for Excel, Outlook and Google Sheets, page 5

How to find top or bottom N values in Excel

Want to identify the highest or lowest values in a column or row? Need to return not only the values themselves but their names too? With this tutorial, you will learn how to find top 3, 5, 10 or n values in a dataset and retrieve matching data. Continue reading

How to insert OneDrive images in Outlook email templates

Today we are going to have a closer look at our Shared Email Templates add-in and learn more about its super-useful options to add pictures. I’ve prepared a set of tutorials for you where I’ll walk you through the entire process, show you different approaches for inserting images and tell you the pros and cons of each of them. Continue reading

Excel IF statement for partial text match (wildcard)

Trying to build an IF statement with wildcard text, but it fails every time? The problem is not in your formula but in the function itself - Excel IF does not support wildcard characters. However, there is a way to get it to work for partial text match, and this tutorial will teach you how. Continue reading

How to create, change and remove border in Excel

Sometimes Excel worksheets can be difficult to read because of dense information and complex structure. Adding borders around cells can help you distinguish different sections, emphasize certain data, and make your worksheets better presentable and more attractive. Continue reading

How to get random sample in Excel without duplicates

A while ago, we described a few different ways to randomly select in Excel. Most of those solutions rely on the RAND and RANDBETWEEN functions, which may generate duplicate numbers. If you need a random selection without duplicates, then use the approaches described in this tutorial. Continue reading

Excel dynamic arrays, functions and formulas

Due to the revolutionary update in the Excel 365 calculation engine, array formulas become very straightforward and understandable for everyone, not just for super users. The tutorial explains what dynamic arrays are, and how they can make your worksheets more efficient. Continue reading