Blank cells in excel can be an indication of missing data that might get deleted intentionally or by mistake. It is easy to spot a … Read more

You can ring an alarm in excel through a simple trick. But why will you do that? While it sounds vague without context but imagine … Read more

Alt + = (equal sign) is the quickest excel sum formula. You can use it to calculate autosum in excel. It is a quick and … Read more

To indent in excel, you can add space manually before the value in each cell. This method works well when the dataset is fairly small. … Read more

Data like Social Security numbers, Phone numbers, etc sometimes contain dashes (hyphens).  You might want to remove these dashes before you start working with data.  … Read more

While MS Excel has many powerful features, writing paragraphs in excel is a bit confusing.  If you have ever tried writing or pasting a long … Read more

Do you want to add single quotes to enclose the data inside the cells? This can be done by editing the cell and adding single … Read more

Merging cells in excel can be useful in a variety of cases but it comes with some drawbacks too. For starters, you can’t SORT cells … Read more

A comma(,) is one of the most commonly used delimiters in Microsoft Excel.  In the case of numbers, comma is used to improve readability. For … Read more

It is very easy to calculate Mean in excel. You can either use the AVERAGE function of a custom formula to calculate the mean of … Read more