Excel Tips and Tricks
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 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...
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...
How to create and name a worksheet with VBA in Excel
In this guide, we’re going to show you how to create and name a worksheet with VBA in Excel. Download...
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 going...
How to create a Milestone Chart in Excel
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 create a...
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. [button link="https://spreadsheetweb.com/wp-content/uploads/2021/04/How-to-find-all-combinations-of-two-lists-in-Excel.xlsx" type="big"...
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...