Some common Excel formulas include SUM, which calculates the sum of values within a specified range of cells, COUNT, which counts the number of cells that have characters or numbers in them, and INT, which eliminates the... More »

Use of tutorials and guides that provide helpful instructions can help you learn to create Excel formulas, and practicing these spreadsheet tools reinforces the knowledge. Use a guide to Excel spreadsheet equations, such... More »

Find various cheat sheets for formulas and functions in Microsoft Excel 2003 and newer versions on websites such as Dummies.com and the TechTarget section of WhatIs.com. An illustrated cheat sheet for Microsoft Excel can... More »

Add values in Microsoft Excel using the SUM function =SUM ( Number1, Number2, ... Number255 ), which adds up columns or rows of numbers. "Number" represents the values in cells to be summed. More »

A cumulative sum is a total amount resulting from the addition of several values. In Microsoft Excel specifically, it is a value reached by adding the numbers in a group of columns or rows. More »

To divide by the sum of cells A1 through A10 by 2 in Excel, use the formula: =SUM(A1:A10)/2. It is also possible to enter numbers directly into the formula. More »

To calculate the interquartile range in Microsoft Excel, first enter the values for which you want to calculate the interquartile range in one single column. To calculate the first quartile, select a blank cell, and ente... More »