Since Microsoft Excel 2007, Excel’s formulas have become more readily accessible. This has opened up a number of pretty powerful Excel formulas, that if you can spend a little time getting to know, can save you a LOT of time in the long run.
Here are ten great formulas to help you save time and get the most out of your data.
Want MORE than 10?! Check out this post describing finding highest and lowest numbers with Excel.
Top 10 Powerful Excel Formulas
1) PROPER
How many messy spreadsheets do you have where data has been entered in a hurry? One common mistake is that names of people or companies are all in lower-case
Using the PROPER formula will quickly convert all your text to begin with capital letters.
Example: If cell A1 contains “colin welch” you can enter =PROPER(A1) in to another cell and it will display “Colin Welch” instead.
Another tip! If do this with a big list of names, and you want to copy then back in to the original cells – copy them all, and then use Paste Special > Values
2) UPPER / LOWER
Two formulas for the price of one here!
These both work the same as the “Proper” formula above – but convert all text in to upper or lower case case – e.g “COLIN WELCH” or “colin welch”