PivotTables are very helpful tool for Data handling. They are time saving and can help make Decisions faster.
Categories
What is a Pivot table in Excel
Categories
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
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
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
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.
Categories
Use COUNTA function in Excel
In this tutorial, we will learn how to use COUNTA function, this function is used to count the number of cells, it only count cells with data and does not count any empty cell. Microsoft Excel 2021 is used.
Categories
Use COUNT function in Excel
In this tutorial, we will learn how to count the number of cells with numerical values in a specified cell range. COUNT function is used to count the number of cells. Microsoft Excel 2021 is used.
Categories
Use SUMIF function in Excel
In this tutorial, we will learn how to use SUMIF function in MS Excel. This function adds the values in a range that meet a specified criteria or condition.
In this tutorial, we will learn how to use TRANSPOSE function and copy, paste & transpose to switch rows and columns.
Categories
Use SUM function in Excel
In this tutorial, we will learn how to use SUM function in Excel. This function is used to add all the values in the range cells. You may add individual numbers, cell references, ranges or combination of all three. Microsoft Excel 2021 is used.