Raj Kumar

You can remove the spaces on the left and right of the text and within the text of the text string using Excel’s TRIM function.

Learn how to make a scatter chart in Excel to find the correlation between two variables, i.e. how one variable is affected by the other.

By default, Excel disables all macros to protect you from malicious viruses. But you can enable macros to automate repetitive tasks in Excel.

VLOOKUP function in Excel looks for a value in a range of cells, then it returns a value that’s in the same row as the value you’re looking for.

Learn how to transpose data in Excel and quickly shift the orientation of your columns and rows on a worksheet.

With VAR.S and VAR.P functions you can calculate sample variance and population variance from given data in Excel 2010 and later versions.

You might like