In Microsoft Excel, there are 6 different functions for calculating variance but all of them are designed to find variance in the classical sense, i.e. how far a set of values are spread out from their average. In this article, you will learn how to calculate percentage variance between two cells. Continue reading
Subtraction is one of the four basic arithmetic operations, and every primary school pupil knows that to subtract one number from another you use the minus sign. This good old method also works for subtracting numbers and cells in Excel. Continue reading
As with other basic math operations, Microsoft Excel provides several ways to divide numbers and cells. Which one to use depends on your personal preferences and a particular task you need to solve. Continue reading
As with all basic arithmetic operations, there is more than one way to multiply columns in Excel. This tutorial will show you a few possible solutions so you can choose the one that works best for you. Continue reading
This tutorial shows how to use the multiplication operator in Excel and how to write a formula to multiply cells, columns and rows, numbers and percentages, and more. Continue reading
When it comes to calculations, there is almost noting that Microsoft Excel cannot do, from totaling a column of numbers to solving complex linear programming problems. Apart from that, you can use Excel as a calculator to do math - add, divide, multiply, and subtract numbers as well as raise to power and find roots. Continue reading
Squaring a number and finding a square root are very common operations if mathematics. But how do you do square root in Excel? Either by using the SQRT function or by raising a number to the power of 1/2. Continue reading
This short tutorial shows how a usual Excel Sum formula with a clever use of absolute and relative cell references can quickly calculate a running total in your worksheet. Continue reading
The tutorial demonstrates two easy ways to calculate weighted average in Excel - by using the SUM or SUMPRODUCT function. Continue reading
