Excel Functions

How to Use the CONCAT Function in Excel – 7 Examples

Quick View: Download Practice Workbook CONCAT Function.xlsm Overview of the CONCAT Function Syntax: =CONCAT(Text1, …) ...

Excel Function Categories

Excel Function Categories: Knowledge Hub Excel LOOKUP and Reference Functions Excel Date Functions Use of Excel Database Functions DGET, ...

Use of PERMUTATIONA Function in Excel (4 Simple Examples)

In this article, we will explore how to use the PERMUTATIONA function in Excel to generate phone numbers, pin codes, license plate numbers, and even ...

How to Use EVEN Function in Excel (5 Examples)

The EVEN function in Excel is a tool that can round up a number to the nearest even integer. It takes one argument, which is the number you want to ...

How to Use DSTDEVP Function in Excel (2 Suitable Examples)

Are you looking for an Excel function that will return the standard deviation of the entire population and also match the given criteria? In this ...

How to Use Excel DMAX Function (2 Easy Examples)

Excel is a powerful software as it has predefined functions and numerous features. These functions make the excel experience smoother and more ...

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 NPER Function in Excel (3 Relevant Examples)

Financial analysts frequently want to know the duration of repayment time while making a business deal. Therefore, if you are a financial analyst, ...

How to Use AVEDEV Function in Excel (2 Suitable Examples)

Excel has one of the best usages in statistics. Average Deviation is an important term in statistics that can be directly measured in Excel with the ...

How to Use the DPRODUCT Function in Excel – 6 Examples

This is an overview:   The DPRODUCT Function in Excel Syntax: =DPRODUCT(database,field,criteria) Arguments: ...

How to Use NOMINAL Function in Excel

Microsoft Excel is a handy software. We use Excel functions for our education, business, and financial analyses. Moreover, in light of the effective ...

How to Use DB Function in Excel (2 Ideal Examples)

When we assess any asset of a business, depreciation cost means the decrement of the value of the asset. The DB function is a Financial Function in ...

How to Use DVAR Function in Excel (2 Suitable Examples)

You can employ the Excel database functions to help you when using an Excel dataset. Sometimes, you may need to find the variance due to some ...

How to Use ODD Function in Excel (4 Easy Examples)

There are lots of functions in Excel to perform specific tasks. One of them is this ODD function. We use this function to get odd values. In this ...

How to Use DEVSQ Function in Excel (3 Suitable Examples)

In this article, we will show how to use the DEVSQ function in Excel. The DEVSQ function is used to calculate the sum of squares of deviations of ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo