Excel Functions Archives

How to Create Your Own Reusable Functions with Advanced LAMBDA Functions in Excel

Jan 21, 2025

In this article, we will show how to create your own reusable functions with advanced LAMBDA functions in Excel for complex tasks.

Excel ENGINEERING Functions; 50++ Functions: 8 Methods

Jul 6, 2024

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

Excel ENGINEERING Functions; 50++ Functions: 8 Methods

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

Jun 17, 2024

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

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

Excel Date Functions – A Complete Guide

Aug 8, 2024

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

Aug 10, 2024

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

Using the Excel SUMIFS Function with Multiple Criteria – 5 Examples

COUNTIF Multiple Criteria (All Things You Need to Know)

Jul 3, 2024

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

COUNTIF Multiple Criteria (All Things You Need to Know)

Issues with the VLOOKUP Function – 10 Solutions

Aug 14, 2024

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

Issues with the VLOOKUP Function – 10 Solutions

How to VLOOKUP a Range in Excel – 7 Examples

Aug 11, 2024

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

How to VLOOKUP a Range in Excel – 7 Examples

190+ Most Used Excel Functions List by Category

Jun 17, 2024

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

190+ Most Used Excel Functions List by Category

Top Financial Functions in Excel (15+ Functions)

Aug 5, 2024

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

Top Financial Functions in Excel (15+ Functions)

Logical Functions in Excel

Jul 31, 2024

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)

Jul 6, 2024

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

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

How to Use the CONCAT Function in Excel – 7 Examples

Aug 3, 2024

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

How to Use the CONCAT Function in Excel – 7 Examples

IF with ISERROR Function in Excel: 4 Practical Examples

Jul 8, 2024

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

IF with ISERROR Function in Excel: 4 Practical Examples

Excel SUMIF Not Equal Criteria: 5 Suitable Examples

May 29, 2024

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