How to use Weighted Average in Excel
Nov 06, 2020
To calculate a weighted average in Excel, simply use the SUMPRODUCT and the SUM function.
How to use RANK Function In Excel
Nov 04, 2020
The RANK function in Excel returns the rank of a number in a list of numbers.
How to Generate Random Numbers In Excel
Nov 04, 2020
Excel has two useful functions when it comes to generating random numbers.
How to use Percentiles and Quartiles In Excel
Nov 04, 2020
This example teaches you how to use the PERCENTILE and QUARTILE function in Excel.
How to use Standard Deviation In Excel
Nov 04, 2020
This page explains how to calculate the standard deviation based on the entire population using the STDEV.P function in Excel.
How to change Negative Numbers to Zero In Excel
Nov 01, 2020
A clever Excel trick to change negative numbers to zero but leave positive numbers unchanged.
How to Use MaxIfs and MinIfs Function In Excel
Oct 31, 2020
Use MAXIFS and MINIFS in Excel 2016 or later to find the maximum and minimum value based on one criteria or multiple criteria.
How to use FREQUENCY function in Excel
Oct 30, 2020
The FREQUENCY function in Excel calculates how often values occur within the ranges you specify in a bin table.
How To Create a Box and Whisker Plot In Excel
Oct 28, 2020
This example teaches you how to create a box and whisker plot in Excel.
How To Use AverageIf function In Excel
Oct 28, 2020
The AVERAGEIF function in Excel calculates the average of cells that meet one criteria.