How to display File Open dialog in VBA

How to display File Open dialog in VBA

Excel VBA allows you to open a workbook directly – all you need is the full path of the file, including the file name. However, locating and supplying the file path each time may can be tedious when working with multiple files. In this guide, we’re going to show...
How to insert specific number of rows in Excel

How to insert specific number of rows in Excel

Inserting new rows is the easiest way to add new fields into your worksheet area. Since Excel inserts rows by copying the formatting of the previous row, it is usually more practical than moving bottom cells to open up space for new data. Thanks to VBA, we can insert...
How to use regular expressions in Excel

How to use regular expressions in Excel

You can use text functions to manipulate text strings in Excel. However, you can’t use them with regular expressions. As of writing this article VBA is your only option. In this guide, we’re going to show you how to use regular expressions in Excel. Download...
How to use Advanced Filters in Excel

How to use Advanced Filters in Excel

The arrow buttons, FILTER function, and Power Query are popular methods for filtering data in Excel. Unless you are using Power Query, these methods may not be enough when working with two or more criteria. The more powerful Advanced Filter feature can help for more...
How to calculate discrete probability in Excel

How to calculate discrete probability in Excel

A discrete distribution describes the probability of occurrence of a random variable that can take on only a certain number of values. Common examples for this are the probabilities in a dice roll or getting a certain card in a deck of regular cards. In this guide,...
Function: PROB

Function: PROB

The PROB function is a statistical function that can calculate the probability associated with a given range. The function is useful for calculating the probability for the occurrences having discrete probabilities of an event. In this guide, we’re going to show you...
How to add error bars in Excel

How to add error bars in Excel

Error bars are graphical representations of data variability in charts. You can add error bars into your Excel charts to provide a more comprehensive view of the data set. An error bar is usually a horizontal and/or vertical line drawn between lowest and highest error...
How to strikethrough in Excel

How to strikethrough in Excel

In this guide, we’re going to show you how to strikethrough in Excel. Download Workbook Strikethrough is a handy formatting option to eliminate data that is not relevant anymore. Let’s see how you can apply this formatting in Excel. Keyboard shortcut Simply press the...