by Ilker | May 28, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to create and name a worksheet with VBA in Excel. Download Workbook Syntax You can create and name a worksheet using the Sheets.Add and Worksheets.Add methods. Both methods work similarly and have 4 optional arguments and...
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 | May 26, 2021 | Excel Tips & Tricks
A milestone chart is a visualization tool that can show scheduled events in a specific time. These significant events are called as milestones. Unfortunately, milestone charts are not natively supported by Excel. In this guide, we’re going to show you how to...
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...
by Ilker | Apr 20, 2021 | Excel Tips & Tricks
In this guide, we’re going to show you how to split text in Excel by a delimiter. Download Workbook We have a sample data which contains concatenated values separated by “|” characters. It is important that the data includes a specific delimiter character...
by Ilker | Apr 16, 2021 | Excel Tips & Tricks
How to shorten VBA code in Excel Shortening VBA code can make it much easier to read and maintain. Here, we mean shortening in the sense that some code blocks can be stacked or alternative statements can be introduced to make it more efficient. In this guide,...
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...
