The Sumif function in Excel is one of the easiest to learn, yet also extremely powerful. Very often in Excel, there are
One of the easiest ways to visualize your data is by making a line graph in Excel. It is most often used to show trends over
In addition to the very popular CONCATENATE function, you’ll find it very useful to learn how to use CONCAT in excel.
Excel is very good when it comes to dealing with dates and datetimes. In this post we’ll look specifically at finding
It can be frustrating to comb through a dataset looking for where your formula went wrong only to discover there’s an
One of the easiest formatting improvements you can make is to merge cells in Excel. This is very commonly done when creating
When dealing with data that is a combination of text, special characters, and numbers, you might run across a situation where
One of the most frustrating problems in Excel is when you want to remove text from a cell. The SUBSTITUTE function is