Select Page

## How to get filename from path in Excel

In this guide, we’re going to show you how to get filename from path in Excel. We will cover how to do this with and without VBA. Download Workbook File path and file name A file path is a string identifier that specifies the unique location in a file system. It...

## How to generate a normally distributed set of random numbers in Excel

Normal distribution is a probability function in statistics and is often used to represent real-valued random variables. It is known as the bell curve because normally distributed set of random numbers create a bell-shaped curve on a graph. In this guide, we’re...

## How to find all combinations of two lists in Excel

In this guide, we’re going to show you how to find all combinations of two lists in Excel by using Power Query. Download Workbook In our example, we have two lists that contain Pokémon names and we want to see the combinations of matched Pokémon. We can join...

## How to compare two tables using Get & Transform Data in Excel

In this guide, we’re going to show you how to compare two tables using Get & Transform Data in Excel. Download Workbook In our example, there are two identical tables with the same column names. Although both tables contain the same data under the Name...

## How to create dynamic charts in Excel

In this guide, we're going to show you how to create dynamic charts in Excel using dynamic arrays. Download Workbook Even though Excel doesn’t have built-in support for dynamic charts, there are multiple ways to do this. The traditional methods are using Excel Tables...

## How to insert country flags in Excel

In this guide, we’re going to show you how to insert country flags in Excel. Download Workbook There are two ways of inserting flags into your Excel workbook. First is to find the images and insert them into your workbook copy pasting. If you place the flags...

## How to replace pivot tables with dynamic array formulas in Excel

Even though Pivot Tables are very useful in data management and analysis, they don’t automatically update when you make changes. In this guide, we’re going to show you how to replace pivot tables with dynamic array formulas in Excel. Download Workbook Simple...

## How to slugify a string with Excel

“Slugify” is a term for converting strings into URL slug format. A URL slug, or just slug in this article’s context, is the part of the URL that comes after the domain extension. In this guide, we’re going to show you how to slugify a string with Excel. Download...

## How to flip data in Excel

In this guide, we’re going to show you how to flip data in Excel. Download Workbook Using helper column And Sort feature Our first approach is based on using a helper column and the Sort feature. This is a quick and dirty way to flip your data in Excel. The...