SUM, COUNT, CONCATENATE and LEN are some basic formulas to use in Excel. These are predefined formulas that perform operations within user-specified parameters or arguments. Formulas begin with the equal sign, enclose pa... More »

To enter a basic formula in Excel, enter an equal sign into the cell where you want to place the formula. This signals to Excel that the following input is formula input. The formula itself varies depending on the type o... 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 »

Microsoft offers a free training center for Excel as of 2015. The database includes courses for Excel on Windows, Mac OS, Android, iOS and Windows Phone. Alternatively, users can access a help database within Excel by pr... More »

In Excel, the mean function is used to calculate the average of a set of numbers. The numbers used can come from any cell in an Excel spreadsheet by listing the cells involved into the average function box. More »

To subtract in Excel, enter the numbers in a cell using the formula =x-y, complete the same formula using the column and row headings of two different cells, or use the SUM function with negative numbers. Excel does not ... More »

Though there are several functions in Excel for rounding numbers, the ROUND function is the most basic and the most commonly used. Keep in mind that when using any rounding function, its result is always treated as round... More »