Grouping, Sorting, Filtering, Slicers in Pivot Table
Suppose we have the following source data to build our simple Pivot table. Source Data: Pivot Table: Now let us …
Grouping, Sorting, Filtering, Slicers in Pivot Table Read More »
Borders and Gridlines in Microsoft Excel
In our blog today let’s talk about Borders and Gridlines. Starting with: Gridlines in Excel Do you have the assumption …
GETPIVOTDATA function for Pivot Table in MS-EXCEL
GETPIVOTDATA function helps users to extract values from a Pivot Table. You can use the GETPIVOTDATA function to prepare reports …
GETPIVOTDATA function for Pivot Table in MS-EXCEL Read More »
Fix Errors using VLOOKUP in Excel
Errors in VLOOKUP How to fix errors using VLOOKUP? There are mainly four types of errors that can occur while …
Filtering Techniques in Microsoft Excel
Filtering data in excel means seeing limited data according to your choice to make data analysis very fast and efficient. …
COUNTIF FUNCTION
Test Yourself Understanding COUNTIF Formula COUNTIF is a function for calculating the number of numerical cells that meet a certain criteria. COUNTIF …
COUNTIFS FUNCTION
Test Yourself Understanding COUNTIFS Formula COUNTIFS is a function for calculating the count of cells that meet multiple criteria. When corresponding cells …
AVERAGEIFS FUNCTION
Test Yourself Understanding AVERAGEIFS Function AVERAGEIFS is a function for calculating the average of cells that meet multiple criteria. When corresponding cells …
AVERAGEIF FUNCTION
Test Yourself Understanding AVERAGEIF Formula AVERAGEIF is a function for calculating the average of cells that meet a certain criteria. The AVERAGEIF …
SUMIFS FUNCTION
Test Yourself Understanding SUMIFS Formula SUMIFS is a function for calculating the sum of cells that meet multiple criteria. When …
