The EXPAND function lets Excel 365 users resize a returned array to exact dimensions and fill added cells with a value of choice. Think of EXPAND as the missing piece when building report‑ready ranges from dynamic arrays. It takes a source array, returns a version with the exact number of rows and columns specified, and pads any new cells with either a custom value or the default error. This makes it ideal for standardizing array sizes for charts, dashboards, and exports. According to Microsoft’s documentation, the syntax is =EXPAND(array, rows, [columns], [pad_with]) and it will return #VALUE if rows or columns are smaller than the source, and #N/A in padded cells if pad_with is omitted. It’s part of the dynamic array family and available to Microsoft 365 users on Windows, Mac, and the web as of recent builds.

Read More

In this Excel tutorial I show how to use Standardize Function in Excel. The Standardize function transforms a value within a dataset into its corresponding z-score, which tells you how many standard deviations that value is away from the mean of the dataset. This is useful for comparing data points from different distributions or for identifying outliers. Let’s break down how to use the Standardize function in Excel.

Read More

In this Excel tutorial, I’ll show you how to use the COUNTBLANK function. This function counts the number of empty cells in a range. It’s the perfect tool for identifying missing data or blank entries in your spreadsheets. Here’s a step-by-step guide to using the COUNTBLANK function effectively:

Read More

In this Excel tutorial I show how to use the Search function in Excel. It’s a tool for finding text within other text, and while it might seem a little intimidating at first, it’s actually quite straightforward once you get the hang of it. Think of it as a more powerful version of Ctrl+F. While that shortcut helps you find things visually, Search lets you use those findings in formulas, opening up a whole new level of possibilities.

Read More

In this Excel tutorial, I show you how to use Counta function. It counts the number of non-empty cells in a range. This includes cells with numbers, text, or errors. Below is a step-by-step guide to using the Counta function effectively.

Read More

In this Excel tutorial, I show you how to use Count function. It helps count the number of cells with numbers. This is useful for analyzing datasets quickly. Below is a step-by-step guide to using the Count function effectively.

Read More

In this Excel tutorial I show you how to use the Text function in Excel. Text function converts numbers into text in a specific format. This is useful for displaying data clearly. For example, format dates, times, or currency in a readable way. Below is a step-by-step guide to using the TEXT function effectively.

Read More

In this Excel tutorial, I show how to use the lookup function in Excel. The lookup function helps you to find specific data quickly. This function comes in two forms: vector and array. The vector form searches a single row or column. The array form searches multiple rows and columns. Both forms are useful for different tasks. Below is a step-by-step guide to using lookup effectively.

Read More

The VLOOKUP function in Excel is a powerful tool for searching for a value in a table based on a matching value in the first column. When you need to perform a lookup based on another lookup from a different table, you can nest VLOOKUP functions. Here’s how to achieve this with a step-by-step guide.

Read More

We will explore the ins and outs of the Excel MATCH function and how it can simplify your data analysis tasks.

Read More