Excel Functions

How to Use the CONCAT Function in Excel – 7 Examples

The CONCAT function can be used to concatenate different values and ranges of cells. It can handle dynamic data from different sources. ...

How to Use ISNUMBER & MATCH Function in Excel (2 Methods)

Introduction to ISNUMBER Function Function Objective The ISNUMBER function checks whether the value of a cell is a number or not. ...

How to Use DPRODUCT Function in Excel (6 Practical Examples)

While working in Excel, we often need to use various Database Functions. The DPRODUCT function is one of the most widely used database functions in ...

How to Use EOMONTH Function in Excel (10 Ideal Examples)

Certainly, while working in Excel, we often have dates in the dataset and luckily, Excel has a palette of functions for dealing with dates in the ...

How to Use COMBIN Function in Excel (4 Examples)

Today, we are going to learn about the Excel COMBIN function. This tutorial will provide a complete overview of the COMBIN function in detail, the ...

44 Mathematical Functions in Excel (Download Free PDF)

1. The AVERAGE Function Function Objective: The AVERAGE function calculates the average of numbers in a range of cells. Syntax: ...

How to Use MMULT Function in Excel (6 Examples)

The MMULT function stands for “Matrix Multiplication”. It is a math and trigonometry function available in Microsoft Excel. The MMULT function ...

How to Use DGET Function in Excel: 4 Methods

Method 1 - Using the DGET Function with One Criterion in Excel Steps: Activate Cell C12. Type the following formula- ...

How to Use the Excel PMT Function – 4 Examples

  Introduction to the Excel PMT Function Summary The PMT function calculates the payment for a loan based on a constant interest rate. ...

How to Use PROB Function in Excel (3 Examples)

In many real-life situations in business or games, we need to predict the result or output. The PROB function in Excel is a quite useful tool to do ...

How to Use LOG Function in Excel: 10 Methods

Method 1 - Using LOG Function in Excel with Default Base Argument (Log10) Apply the LOG function without specifying the base argument; then it is ...

How to Use DCOUNTA Function in Excel (5 Examples)

When you need to count the number of non-empty cells in a given database, you may utilize the Excel DCOUNTA function. In this article, I’ll exhibit ...

How to Use the Excel GROWTH Function – 4 Methods

  GROWTH Function in Excel: Syntax Summary The GROWTH function is a statistical function in Excel. It is used to calculate predictive ...

How to Use the Excel SWITCH Function (5 Examples)

Method 1 - Using the Excel SWITCH Function to Switch Corresponding Cell Values Steps: Enter the following formula in cell F4: ...

How to Use Excel FREQUENCY Function (6 Examples)

Basics of FREQUENCY Function: Summary & Syntax Summary The Excel FREQUENCY function returns how often numeric values occurred within the ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo