How to Use IFERROR Function in Excel The IFERROR function in Excel is a logical function that allows you to handle errors in your worksheet by providing an alternative value or…
Tag: advanced excel Functions
How to Add Months to Date in Excel
Have you ever been required to find a specific date after some months like after 6 months or 12 months? Excel has one inbuilt function EDATE which will help to do exactly…
How to use Average function in Excel
The Average function is categorized under Excel Statistical functions. It will return the average value of a given series of numbers in Excel. This guide will show you, step-by-step, how to calculate…
How to Stop Excel to make auto hyperlink
How to Stop Excel to make auto hyperlink?? Microsoft excel by default convert text into a hyperlink if your data match with url or email address format.This is actually unwanted things for…