MS Advance Excel Course

A cell reference refers to the name or address of a specific cell or range of cells within the spreadsheet which is a combination of a column letter and a row number. Each worksheet in Excel consists of several cells. Each cell has a specific cell reference which helps the users to find easily address […]

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 locked while the column changes when the formula is copied or dragged. 2 The column is locked while the row changes when the formula is copied or dragged. Below 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 have a fixed value that you need to use in the formula (such as tax rate, commission rate, percentage number of months, etc.) absolute cell references don’t change 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 is called Nested If function. We use Nested If function in Excel when we need to apply more than one condition to analyze the data of excel, and whatever condition

The MAX function in Excel returns the largest numeric value in a range of cells. you can easily extract the largest value / number out of thousands and millions of values ​​typed in the sheet of MS EXCEL. STEP 1 – First of all, open that MS EXCEL sheet in your computer, inside which you

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 the smallest value from all these values, then in this case you can use the Min formula. Using the MIN formula, you can easily extract the smallest value / number

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 to get the same result. There are no specific functions for calculating percentage In MS Excel so you have to use the skills you were taught in your math’s class

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 just like the AND Function. This function also gives the result in True or False. If all the conditions are satisfied in the IF function, and if any one of

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 to give a condition. And then if that condition is True then the If Function will return one value and if it is False then it will return another value