How to Add or Subtract Based on Cell Value in Excel (3 Ways)

The sample dataset has 2 columns: Month, and Sales. We added a few conditions in a smaller table below it. Method 1 - Use of IF Function ...

How to Use Excel AVERAGEIF with Multiple Criteria (5 Examples)

The sample dataset has 4 columns: States, Product, Quantity, and Sales. Method 1 - Applying AND & AVERAGEIF Functions for Multiple ...

SUMPRODUCT for Counting with Multiple Criteria in Excel (3 Examples)

Microsoft Excel offers a variety of methods for counting multiple conditions. We may do this by filtering data using PivotTable or the COUNTIF ...

How to Calculate Average If Number Matches Criteria in Excel

In our day to day life, we often face the necessity of calculating average. In Microsoft Excel, we can do that quite easily. But sometimes we have to ...

How to Use Code 9 with Excel CHAR Function (2 Easy Examples)

You have come to the right place if you are looking for some unique tips for using the Excel CHAR 9 function. There are several ways to use the Excel ...

How to Apply Excel Number Format in Thousands with Comma

We have a dataset of 5 large numbers. We'll format those numbers in Excel number format in thousands with commas. Step 1 - Prepare Your ...

How to Create an ANOVA Table in Excel – 3 Methods

Introduction to ANOVA in Excel ANOVA is the abbreviation of Analysis of Variance. In Excel, it is a method to obtain the values required to test the ...

Excel AVERAGEIF with ‘Greater Than’ and ‘Less Than’ Criteria

Example 1 - Excel AVERAGEIF with ‘Greater Than’ Criteria To find the average for marks greater than 90, enter the following formula in cell H5. ...

Using Excel VLOOKUP to Return Multiple Values in One Cell Separated by Comma

  In this example we need to look up the value in cell F5 within the range B5:D12 and return multiple comma-separated values in cell G5. ...

How to Create a Hierarchy of the State City and Zip Code in Excel

To express an address, usually we need state, city name, and code. In a state, there are several cities. And under one city there are several zip ...

How to Convert Column to Row with Comma in Excel (3 Ways)

Method 1 - Using TEXTJOIN Function Using the TEXTJOIN function is one of the most efficient ways to convert column to row with comma. The TEXTJOIN ...

How to Make an Interactive Calendar in Excel (2 Easy Ways)

The sample dataset below will be used for illustration. Method 1 - Making Interactive Monthly Calendar in Excel Step 1: Open a new ...

How to Change Date Alignment in Excel: 8 Simple Methods

Method 1 - Change Date Alignment with Text to Columns Feature STEPS: Select the date range D5:D8. Go to Data > Data Tools > Text to ...

How to Calculate Average Days in Excel (2 Easy Ways)

In Excel, when we need to calculate the average days of different dates depending on our data set, you may find it somewhat difficult. This article ...

How to Align Currency Symbol in Excel: 3 Easy Ways

Method 1 - Using Accounting Number Format to Align Currency Symbol Highlight the range or cell then select Accounting as Number Format from the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo