10 Amazing Excel tricks that will change your life!!

​Microsoft Excel has amazing features and shortcuts. In this article, we are presenting 10 basic but most useful shortcuts and functions that absolutely everyone need to know to become Excellent in Excel.

Have a look at it and if you have any query you can mail us at info@amazingexcel.com.

When copying formulas in Excel, sometimes you want your input cells to move with your formulas BUT SOMETIMES YOU DON'T. When you want to lock one of your inputs you need to put dollar signs before the column letter and row number. Typing in the dollar signs is insane and a huge waste of time. Instead, after you select your cell, hit F4 to insert the dollar signs and lock the cell. If you continue to hit the F4 key, it will cycle through different options: lock cell, lock row number, lock column letter, no lock.

7. Summarize data with CountIF and SumIF

CountIF and CounIFs will count the number of times a value appears in a selected range. The first input is the range of values you want to count in. The second input is the criteria, or particular value, you are looking for.

Here we have a column of first names and last names. We can create a column with full names by using &. In Excel, & joins together two or more pieces of text. Don't forget to put a space between the names. Your formula will look like this =[First Name]&” “&[Last Name]. You can mix cell references with actual text as long as the text you want to include is surrounded by quotes:

10. Clean up text with LEFT, RIGHT and LEN

The LEN function in EXCEL is used to return the length of the text string.

You can use LEFT function when you want to extract some characters from leftmost part of string.

LEFT(text string, number of characters)

If you want to pull the numerical values out of this text string you have to use the RIGHT function. RIGHT grabs a number of characters from the right end of a text string.