AutoFill

AutoFill is a very useful Excel feature. It allows you to create entire columns or rows of data which are based on the…

Posted On

Trendlines

One of the easiest methods for guessing a general trend in your data is to add a trendline to a chart. The Trendline…

Posted On

Remove leading zeros

When you have to work with a spreadsheet that you didn’t create, sometimes you may encounter poorly formatted data or formatting errors. For…

Posted On

Opposite of concatenate

The CONCATENATE function is used in Excel to merge several strings into one. Let’s suppose that you want to reverse the process and change the “JohnDoe45” to “John”, “Doe” and “45”….

Posted On