Excel Functions

Conditional Formatting Multiple Text Values in Excel (4 Easy Ways)

Consider a dataset of Product Sales, where we have text value columns named Region, City, Category, and Product. We want to conditionally format the ...

How to Trim Right Characters and Spaces in Excel (5 Ways)

Sometimes data cells may have additional characters attached to the right which is not required.   In the sample dataset the ...

How to Check If a Value Is in List in Excel (10 Ways)

Consider a dataset about some products of a company. We will check whether specific values in the Product column exist. Method 1 - Using ...

How to Calculate the Average in Excel – 11 Methods

Download Practice Workbook Download the Excel workbook. Calculate Average.xlsx Method 1 - Calculating the Simple Arithmetic Average of ...

How to Use Left Trim Function in Excel: 7 Easy Ways

Some spreadsheets like the following sample dataset require us to trim data from the left. Here, we need to trim the Color from the given Product ...

How to Remove the Dollar Sign in Excel – 7 Methods

The pre-formatted dataset shows the dollar sign ($) before the Price value. Method 1- Using the Format Cells Feature to Remove the Dollar ...

How to Use the SUMIF Function between Two Values in Excel

The dataset used for these methods contains three columns with the product ID, prices of the products, and delivery dates of a company's products.  ...

How to Use The SUMIFS Function to SUM Values in a Date Range in Excel -11 Examples

The Excel SUMIFS Function The SUMIFS function is used to find the sum of a range of values with given conditions. Generic Syntax: ...

How to Use SUMIF with Text in Excel (9 Easy Ways)

This tutorial uses a dataset for Product Name, Salesperson, and Profit, as shown below: Download Practice Workbook You can download the ...

How to Use the SUMIF with OR Logic in Excel (10 Methods)

Below is a dataset of sales information. The dataset has three columns: Region, Product Name, and Price. Each column represents the sales amount of a ...

SUMIF vs SUMIFS in Excel (A Comparative Analysis)

This is an overview. The SUMIF Function in Excel The SUMIF function sums a given range based on one condition only. It adds the values if ...

How to Use the SUMIFS for a Date Range with Multiple Criteria – 7 Methods

This is an overview of the method and the sample dataset. In this sample dataset you want to find the total sales over the dates. Method ...

How to Use IFERROR with VLOOKUP in Excel: 5 Different Methods

Method 1 - Replace #N/A with Custom Text Search for a student whose name isn’t in the list, you want to show custom text such as “Not found”. Enter ...

How to Sum Colored Cells in Excel (4 Ways)

There’re no built-in Excel functions that sum up the colored cells in Excel by themselves. However, there are a few ways to implement this kind of ...

How to Use 3D SUMIF for Multiple Worksheets in Excel

The sample Excel Workbook contains three Worksheets named Jan, Feb, and March. In each sheet, the B4:D9 cells contain the Employee, Project, and ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo