Resources
Function: VAR
The VAR function is a statistical function calculates and returns the variance of a sample. The variance provides a general idea of the spread of data, and can be used to calculate the standard deviation or determining risk of an investment. In this guide, we’re going...
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...
Historical Currency Exchange Rate Comparison Template
With hundreds of currencies used across the world, which ones have been performing the best in terms of value store? If this is something you want to know for building or reallocating your portfolio, this historical currency exchange rate comparison template is for...
Cryptocurrency Comparison Template
Cryptocurrencies have become very popular as an alternative store of value. Cryptocurrencies have different uses and they tend to respond differently to events or demand. Running a cryptocurrency comparison can help you understand the correlation between different...
Stock Quote Comparison Template
Stock quote comparison can help you understand the correlation between different securities and hedge your portfolio accordingly. Securities that move very close to each other when the markets reach to events may not be a good way to add more diversification. Excel is...
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://www.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...