by Ilker | Aug 11, 2022 | Blog
SpreadsheetWeb Hub supports Excel's LAMBDA function. Recently released LAMBDA function allows Excel users to build custom, reusable functions without VBA. There are so many use cases of LAMBDA function. In this article, we will build a function to calculate distance...
by Ilker | Jun 23, 2021 | Excel Tips & Tricks
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...
by Ilker | May 27, 2021 | Excel Tips & Tricks
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...
by Ilker | Apr 30, 2021 | Excel Tips & Tricks
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...
by Ilker | Apr 26, 2021 | Excel Tips & Tricks
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...
by Ilker | Apr 21, 2021 | Excel Tips & Tricks
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...
by Ilker | Apr 1, 2021 | Excel Tips & Tricks, Uncategorized
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...
by Ilker | Mar 30, 2021 | Excel Tips & Tricks
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...
by Ilker | Mar 19, 2021 | Excel Tips & Tricks
“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...
