Excel Functions

Excel ENGINEERING Functions (50++ Functions)

Excel Engineering Functions are the 54 Excel functions that are most preferably used in engineering applications. Engineers may find these Excel ...

Excel String Functions [Basics + Practical Example of 17 Functions]

In this article, we will explain 17 Excel string functions with all sorts of examples of every single function. Download Practice Workbook ...

Excel Date Functions: A Complete Guide

In this article, we'll take you on a journey through the diverse range of powerful Excel date functions. From simple functions like DATE, TODAY, and ...

Excel SUMIFS Multiple Criteria (All Applications)

In this article, you will learn how to use Excel SUMIFS function with multiple criteria. Here, you will see the application of AND, OR logic within ...

COUNTIF Multiple Criteria (All Things You Need to Know)

In this article, you’ll learn how to use the COUNTIF function in Excel with multiple criteria in different scenarios with 4 suitable examples. The ...

Issues with VLOOKUP

In this article, we are going to see how we can resolve the issues with VLOOKUP in the most efficient manner possible. Being one of the most popular ...

How to VLOOKUP a Range in Excel

In this article, we will learn how to VLOOKUP a range in Excel using different examples. Here, we will use grade marks as a range, discount charts as ...

190+ Most Used Excel Functions List by Category

In Excel, a function is a predefined formula that performs a specific calculation or task. Functions are built-in tools that allow you to automate ...

Top Financial Functions in Excel (15+ Functions)

Excel contains different financial functions designed to perform different financial calculations and analyses easily. Financial functions can ...

Logical Functions in Excel

Logical Functions in Excel IF AND OR NOT IFERROR IFNA XOR << Go Back to Excel Function Categories | Excel ...

Table Array in Excel (Create, Use and Fix Issues)

In this article, we will learn in detail about table array in Excel including using, and applying variables, with defined names, from another ...

How to Use CONCAT Function in Excel

In this article, we have talked about how to use the CONCAT function in Excel. We have demonstrated various examples of using the CONCAT function ...

IF with ISERROR Function in Excel: 4 Practical Examples

In this article, we are going to explore the combination of IF with the ISERROR function in Excel in different circumstances, such as finding unit ...

Excel SUMIF Function for Not Equal Criteria

In this article, we will know how to use Excel SUMIF not equal criteria. Excel's SUMIF function is a strong tool for computing sums based on ...

Sum If Greater Than and Less Than Cell Value in Excel

In Excel, you may apply multiple conditions to sum values. From them, the greater than and less than condition is mostly used. You can use both ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo