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.

Home / Archives for Formulas

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.

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

[Read more…] about Non-Adjacent Columns with FILTER FunctionThis 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.*

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.

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.

[Read more…] about Excel IMAGE Function – Insert Images from a Cell ValueIn 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.

[Read more…] about SEQUENCE Function in Excel- « Go to Previous Page
- Go to page 1
- Go to page 2
- Go to page 3
- Go to page 4
- Interim pages omitted …
- Go to page 19
- Go to Next Page »