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 Statistical Functions

List of Excel Statistical Functions: AVERAGE Function MEDIAN Function MODE Function STDEV Function VAR Function COUNT Function ...

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 ...

List of Complex Functions in Excel (10+ Functions)

A complex number is a combination of real numbers and imaginary numbers represented in x+iy format. Where x is the real part and y is the coefficient ...

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 ...

Excel Information Functions

Excel Information Functions: Knowledge Hub CELL Function IFERROR Function ISBLANK Function ISERROR Function ISEVEN Function ...

Excel TIME Functions

List of Excel TIME Functions TIME NOW HOUR MINUTE SECOND TIMEVALUE NETWORKDAYS EDATE EOMONTH << Go Back ...

Excel Sum with VLOOKUP

Excel Sum with VLOOKUP: Knowledge Hub How to Sum All Matches with VLOOKUP in Excel Use VLOOKUP to Sum Multiple Rows in Excel How to ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo