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

Excel Statistical Functions

Nov 11, 2025

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

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

List of Complex Functions in Excel (10+ Functions)

Nov 11, 2025

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

List of Complex Functions in Excel (10+ Functions)

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