Category: MS Advance Excel Course

Mixed cell references are more-tricky than the absolute cell references if we compare. There can be two types of mixed cell references: 1 The row is …

Absolute cell references are useful when you don’t want the cell reference to change as you copy or drag formulas. This reference used when you …

There is no spacefic function called Nested If function in MS Excel, but whenever we use multiple IF function together within IF in MS-Excel, it …

The MAX function in Excel returns the largest numeric value in a range of cells. you can easily extract the largest value / number out …

When we type many values ​​on the sheet of MS EXCEL and there are small and big values ​​in it, then we have to extract …

In this tutorial, you ’ll learn five different ways how to calculate percentage in Excel. All of them are correct and can be used interchangeably …

The OR function in Microsoft Excel comes under the logical function category. The OR function is also used to test multiple conditions at a time …

IF function in Excel This is a very useful function. IF function is used to check the condition. In this, first of all you have …