Excel Functions

Excel ENGINEERING Functions; 50++ Functions: 8 Methods

Method 1 - Using the CONVERT Function to Convert Between Units of Measurement To convert a gram unit into a pound mass unit, follow the steps below: ...

How to Use Excel String Functions (Examples of 17 Functions)

  Function 1 – TEXT Function Syntax: =TEXT(value, format_text) Arguments Explanation: Argument Required/Optional ...

Excel Date Functions – A Complete Guide

This is an overview. . Download Practice Workbook Download the workbook here. Excel Date Functions.xlsx 1 - Insert ...

Using the Excel SUMIFS Function with Multiple Criteria – 5 Examples

With the SUMIFS function you can add numbers that fulfill more than one condition.  This is an overview: Download Practice Workbook ...

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

    70 Most Popular & Common Excel Functions by Alphabetical Order Function Name Objective AND Checks whether ...

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)

The table below is an overview of table array to lookup values in Excel. Download Practice Workbook Table Array.xlsx What Is ...

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 Not Equal Criteria: 5 Suitable Examples

Method 1 - Calculating Sum with Numeric Not Equal Single Criteria Use the following formula in a cell of your worksheet. =SUMIF(E5:E17, ...

Sum If Greater Than and Less Than Cell Value in Excel

Method 1 - Sum If Greater Than and Less Than from Same Value 1.1 Applying SUMIF Function for Greater Than and Less Than from Same Value You have to ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo