5 Useful Functions in Excel

5 Useful Functions in Excel 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...

The Choose Function, the Alternative to the IF or Vlookup

The Choose Function, the Alternative to the IF or Vlookup The Choose function is categorized in the latest versions of Excel as a Lookup and Reference formula, it returns a value from a set list of arguments based on a given position. The function looks as follows:...

How to find the minimum value in Excel (while ignoring the 0 value)

How to find the minimum value in Excel (while ignoring the 0 value) How to find the Minimum Value in Excel. 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...