Excel cells Function Tips

How To Calculate Weighted Average In Excel

The average value of number of cells or a data range in Excel can easily be calculated using AVERAGE() formula.

The Importance Of INDIRECT Function

INDIRECT Function yields a reference to a range. The range being referred can be a named range, a range of cells or can be a cell. 

Convert Text To Numbers In Excel – A Step By Step Tutorial

We often see numbers stored in Excel as text which leads to wrong calculations, especially while using the cells in the functions i.e.

Locking Cells In Excel

In some scenarios, you desire to lock cells so that no changes can be made in the cells by other people in Excel.

Countif Greater Than

COUNTIF() function is used for counting cells with unique values in a range that meet a certain criterion, or condition.

How to Use Counta Function

The COUNTA function is usually used for counting the non-empty cells in a given cell range.

Count Unique Values in Excel Using COUNTIF Function

COUNTIF() function is used for counting cells with unique values in a range that meet a certain criterion, or condition.

How to use COUNTIF greater than

COUNTIF() function is used for counting cells with unique values in a range that meet a certain criterion, or condition.

COUNTIFS Function (multiple criteria)

The COUNTIFS() function is an extended version of the COUNTIF() function which is used to conditionally count items/ cells based on certain criteria. 

How to Count Cells that Contain Text Strings

When you have a large data set with text strings, you may need to find or count data based on their text content. You may know to do this with numerical values, but also know that this can be done to ant cells that contain text strings.

How To Merge Cells In Excel

Merging is a useful function in MS Excel which is used more often to make title/larger cells or also to combine

Conditional Formatting in Excel

Conditional Formatting is a widely used tool of Excel that provides pre-determined formatting to be applied to a cell or range of cells. The formatting may depend on the cell value or the content of it

Finding minimum, maximum and average number in a list and counting the number of cells. 

Using the MIN(), MAX(), COUNT() and AVERAGE() functions on a list