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

This is an overview: Download Practice Workbook Download the Excel file. Using SUMIFS Function with Multiple Criteria.xlsx ...

### COUNTIF Multiple Criteria (All Things You Need to Know)

The image below is an overview of using the COUNTIF function with multiple criteria in Excel. Download Practice Workbook COUNTIF ...

### Issues with the VLOOKUP Function – 10 Solutions

This is an overview: Download Practice Workbook Download the practice workbook. VLOOKUP.xlsx   Solution 1 - The ...

### How to VLOOKUP a Range in Excel – 7 Examples

Download Practice Workbook Download the worksheet. Performing VLOOKUP in Range.xlsx Example 1 - Applying the VLOOKUP ...

### 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)

1 - FV Function (Future Value) The FV function is an Excel financial function that is used to calculate the future value of an investment based on a ...

### 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 the CONCAT Function in Excel – 7 Examples

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

### IF with ISERROR Function in Excel: 4 Practical Examples

Here's an overview of using the IF and ISERROR functions to check a car's unit price depending on the amount of available stock. What Is ...

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