Resources
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. [button...
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
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
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
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
In this guide, we’re going to show you how to strikethrough in Excel. Strikethrough is a handy formatting...
How to alternate row color based on group in Excel
Using different coloring makes it easy to highlight differences in data or the layout of your spreadsheets. Excel has support for rows with alternating coloring in tables. What if your table contains similar values in groups, and you want to color the rows based on...
Bar Chart
Bar charts display data with the use of horizontally placed rectangular bars. Each bar represents a category and they are drawn with proportional length to the represented values. [button link="https://www.spreadsheetweb.com/wp-content/uploads/2021/06/Bar-Chart.xlsx"...
How to calculate variance in Excel
Variance is an important metric in statistics, and it can help you calculate like the risk of an investment. In this guide, we’re going to show you how to calculate variance in Excel. [button...