Filter Shortcut in Excel

In this lesson, I will show you how you can use keyboard shortcuts to manipulate filters in Excel. Creating filters Take a look…

Posted On

Delta symbol

The delta symbol means change over time. It’s handy to use this symbol, instead of writing the whole word like “change” or “difference”….

Posted On

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