Breaking News
Home / Tips and Tricks / The simple yet powerful Excel functions you need to know

The simple yet powerful Excel functions you need to know

Power users like to talk about how powerful and ingenious Excel is, what happens with its pivot tables, nested formulas, and Boolean logic. But many of us barely know how to find the Autosum feature, let alone the Excel features for building powerful formulas.

If you're part of Excel 99 percent, there are 16 convenient Excel functions available. How to get to Spreadsheet

= SUM ()

The first function that everyone should know is Excel's basic calculation. For example, suppose you want the numbers in cell A2 and cell B2 in cell C2 to be added together. Just type = SUM (A2: B2) in C2 and press Enter. In an instant you would see the sum of the two cells.

You can use this feature and most of the features listed here to include as many cells as you need. You can also select them with the mouse, but it is much easier to enter a series of cells.

= AVERAGE ()

Average does exactly what it says and works much like SUM. If you have a worksheet with your monthly earnings for the last year in columns A2 to A1

3, enter = AVERAGE (A2: A13) in A14 to get the average of all monthly earnings.

Once again, you can also use your mouse pointer to highlight a series of cells by clicking and dragging, or use Ctrl + Click to manually select individual cells

= MIN ()

If you need to find the smallest number in a range of cells, MIN can help. With = MIN (B3: B39) you get the smallest number contained in these cells.

= MAX ()

Max is the counterpart to MIN and the opposite shows you the largest number

= TRIM ()

When you copy text from another program in Excel, it can often get too excessive There are spaces that turn your spreadsheet into a visual horror. TRIM can help you to clean it up.

TRIM can only handle text from a single cell. So start by cleaning up the text in cell B1, for example, by typing = TRIM (B1) in cell C1. The result will be clean text in cell C1. Repeat the function for all other cells that you need to clean up.