5 Useful Functions in Excel

Let’s take a look at the following really useful functions that will help us every day in Excel. Functions that help with CASE This set of 3 functions are very handy to use when text has been imported into Excel and it has READ MORE

Manipulating imported .CSV data files in Excel

Let’s look at a scenario where data is given to you in .CSV format or already has been imported into Excel for you. It may be the case that you have a list of ID numbers, when they are pasted or imported into READ MORE

How to find the minimum value in a range while ignoring the 0 value

In this example we cannot use the function Min (Minimum), because it will only find the smallest value in a range of cells. However the Small Function allows you to choose the Smallest and also the second smallest, third smallest and so on. READ MORE