Categories
Excel

What is a Pivot table in Excel

PivotTables are very helpful tool for Data handling. They are time saving and can help make Decisions faster.

Categories
Excel

Count Cells in Excel

In Excel, we can count cells in many ways using different functions. Cells can be counted for their numerical values, a criteria or we can count cells with a specific text.

Categories
Excel

Use COUNTIFS function in Excel

COUNTIFS function is used where we have multiple ranges of cells and a criteria has to be applied for every range of cell.

Categories
Excel

Count cells with text in Excel

In this tutorial, we will learn how to count cells that have text in them. We will use COUNTIF function for this. MS Excel 2021 is used.

Categories
Excel

Use COUNTIF function in Excel

In this tutorial, we will learn how to use COUNTIF function. COUNTIF function is used to count the number of cells that meet a given criteria or condition. MS Excel 2021 is used.

Use SUMIF function in MS Excel