Excel tutorials, functions and advanced formula examples, page 7
Add a picture from SharePoint to Outlook emails using a special macro
I’d like to tell you some more about inserting pictures in Outlook emails. As our Shared Email Templates supports SharePoint, I’ll tell you about this platform, teach you placing images there and show how to insert them in an Outlook message. Continue reading
Conditional formatting for Outlook email templates
Interested in changing the default font color to any of your favorites in an Outlook email as quickly as possible? Shared Email Templates can do the trick and this article will show how. 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 LARGE function with formula examples to get n-th highest value
When analyzing a set of numbers, it often makes sense to find the biggest ones. Getting the highest value is super-easy with the MAX function. When it comes to targeting a specific largest value, say the 2nd or the 3rd biggest number in a dataset, the LARGE function comes in handy. Continue reading
Excel SMALL IF formula to find Nth lowest value with criteria
Trying to get a bottom value based on one or more conditions? Just use the SMALL function together with IF. This tutorial shows how to build such a formula and explains its internal logic, so that you could easily decipher the formula and adjust for your needs. Continue reading
Excel SMALL function with examples to find and highlight bottom values
Need to find a few lowest numbers in a worksheet? This is quite easy to do with the Excel Sort feature. Do not want to re-sort your data with every change? The SMALL function will help you quickly find the lowest value, second lowest, third lowest, and so on. Continue reading
Excel IF wildcard statement for partial text match
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
Ultimate Suite for Excel 2020.1.2494: Release Notes
The 2020.1.2494 update of Ultimate Suite for Excel is published! We added some options to the existing tools, fixed some minor issues, and made several improvements. NEW: Split tables by first N characters in the selected key columns Now, you … Continue reading
Excel wildcard: find and replace, filter, use in formulas
When you are looking for something but not exactly sure exactly what, wildcards are a perfect solution. You can think of a wildcard as a joker that can take on any value. There are only 3 wildcard characters in Excel, but they can do so many useful things! Continue reading
Sum if between two dates in Excel: SUMIFS with date range as criteria
Working on a report, investment plan or any other dataset with dates, you may often need to sum values within a specific period. This tutorial will teach you a quick and easy solution - SUMIFS formula with date range as criteria. Continue reading
How to use SUMIF in Excel with multiple conditions (OR logic)
Microsoft Excel has a special function to sum cells with multiple conditions and the AND logic - the SUMIFS function. In some situations, however, you may need to sum with multiple OR criteria. And this is when the SUMIF function comes in handy. 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
Excel XMATCH function with formula examples
In Excel 365, the XMATCH function was added to supersede the MATCH function. But before you start upgrading your existing formulas, it would be wise to understand all advantages of the new function and how it differs from the old one. Continue reading
Count words and characters in Google Sheets: LEN function
Though word and character count in Google Sheets are used in rare cases, it is still the functionality that some of us expect to see right in the menu. But unlike Google Docs, for Google Sheets, it is the LEN function that does that. Continue reading
How to make a dynamic dependent dropdown list in Excel an easy way
Creating a simple drop down list in Excel is easy. Making a cascading drop-down has always been a problem. But not any more! The introduction of dynamic arrays in Excel 365 provided a fast and easy solution. Continue reading
How to create a sequence of dates in Excel and auto fill date series
Until recently, there has been just one easy way to generate dates in Excel - the AutoFill feature. The introduction of the new dynamic array SEQUENCE function has made it possible to make a series of dates with a formula too. This tutorial takes an in-depth look at both methods so that you can choose the one that works best for you. Continue reading
Calculate days, months and years between two dates in Google Sheets: DATEDIF formulas
Today's blog post is all about figuring out the difference between two dates in Google Sheets. Come find lots of DATEDIF formulas to count days, months and years, and learn how NETWORKDAYS is used to count only workdays even if your holidays are based on a custom schedule. Continue reading
Excel SEQUENCE function - create a number series automatically
The times when you had to put numbers in sequence in Excel manually are long gone. In modern Excel, you can make a simple number series in a flash with the Auto Fill feature. If you have a more specific task in mind, then use the SEQUENCE function, which is specially designed for this purpose. Continue reading
How to generate random numbers in Excel without duplicates
As you probably know, Microsoft Excel has several functions for generating random numbers such as RAND, RANDBETWEEN and RANDARRAY. However, there is no guarantee that their result will be duplicate free. This tutorial shows a few formulas to build your own unique random number generator for Excel. 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