The N function returns a number when given a value. This tutorial breaks down the N function in Excel and then shows two real-world examples of using it with the SUMPRODUCT function.
You can download the Excel workbook to follow along.
Non-Adjacent Columns with FILTER Function
This tutorial will return non-adjacent columns with the FILTER function. Dynamic array functions such as FILTER and SORT can only return consecutive columns natively. However, there are various methods to specify the columns to return from the array. Functions such as CHOOSECOLS, CHOOSE and INDEX are wonderful for this task.
You can download the Excel workbook to follow along
Moving Average in Excel
This tutorial will look at how to calculate moving average in Excel. The moving average is sometimes referred to as the rolling average as it averages the values from a rolling, or moving, date range. In this post, our focus is on a seven-day moving average.
You can download the Excel workbook used in this tutorial to follow along.
Excel IMAGE Function – Insert Images from a Cell Value
The IMAGE function in Excel enables us to return an image to a cell using an Excel formula.
This function makes it easy to lookup images based on a cell value, and because the image is stored in the cell, it is returned when sorting and filtering, and when using other functions such as XLOOKUP, FILTER and IF.
Excel IMAGE Function
The IMAGE function accepts five arguments, but only the source argument is mandatory. The other arguments enable us to specify alternative text and to specify the size of the image.
IMAGE(source, [alt_text], [sizing], [height], [width])- Source: The URL of the image file. This can be entered as a text string, be a reference to a cell containing the URL path, or be a formula that returns a valid URL path.
- Alt text: The alternative text for the image.
- Sizing: Determines the dimensions of the image. There are four options to choose from.
- 0 – used to fit the picture to the cell maintaining its aspect ratio.
- 1 – fill the cell ignoring the aspect ratio.
- 2 – keep the original image size even if it ignores the cell boundary.
- 3 – set the images height and width.
- Height: The image height in pixels.
- Weight: The image width in pixels.
The Excel IMAGE function can handle numerous image formats including JPEG, PNG, bitmap, TIFF, and more. The source, however, must be a URL using the ‘https’ protocol.
Download the practise workbook to follow along.
Let’s see some examples of it in action.
SEQUENCE Function in Excel
In this tutorial, we will introduce you to the fabulous SEQUENCE function in Excel along with two ‘real world’ examples of its use.
The SEQUENCE function is a dynamic array function and is only available in Excel 365, Excel 2021 and in Excel Online.
When you first see the SEQUENCE function, it is maybe not that clear how it will come in useful. So, two examples will be provided toward the end of this tutorial, and in the following video, to see some practical uses.
You can download the Excel workbook used in this tutorial to follow along.
