Excel Functions Archives - Page 34 of 40

How to Use DAY Function in Excel (3 Ideal Examples)

Nov 11, 2025

Excel provides several functions to maximize and speed up your productivity. One such function is the DAY function of Excel. Today I am going to show ...

How to Use DAY Function in Excel (3 Ideal Examples)

How to Use the HOUR Function in Excel (7 Examples)

Jul 13, 2024

Quick View of the HOUR Function in Excel In the following picture, you can see a quick view of the HOUR function. Syntax & Argument ...

How to Use the HOUR Function in Excel (7 Examples)

How to Use NETWORKDAYS Function in Excel (6 Examples)

May 15, 2024

The image below illustrates the functionality of the Excel NETWORKDAYS function. Introduction to the NETWORKDAYS Function Function ...

How to Use NETWORKDAYS Function in Excel (6 Examples)

How to Use the DATEVALUE Function in Excel (6 Methods)

Jul 10, 2024

The screenshot below provides an overview of this article demonstrating the application of the DATEVALUE function in Excel. Introduction ...

How to Use the DATEVALUE Function in Excel (6 Methods)

Fix Excel Date Not Formatting Correctly (8 Quick Solutions)

Jul 3, 2024

Here's an overview of fixing the date format in Excel. You can use the Text to Columns feature to extract and format dates from cells. Fix ...

Fix Excel Date Not Formatting Correctly (8 Quick Solutions)

Advanced Filter with Multiple Criteria in Excel (15 Suitable Examples)

Jun 26, 2024

Example 1 - Advanced Filter for AND Criteria Below is our sample dataset. We’re going to extract data for all devices made in the USA and devices ...

Advanced Filter with Multiple Criteria in Excel (15 Suitable Examples)

Using the Sum, OFFSET and MATCH Functions in Excel – 4 Examples

Aug 10, 2024

Download Practice Workbook Download the workbook. Sum Using OFFSET and MATCH Functions.xlsx The sample dataset showcases the sales ...

Using the Sum, OFFSET and MATCH Functions in Excel – 4 Examples

How to Filter Multiple Rows in Excel: 11 Suitable Methods

May 20, 2024

Method 1 - Using Sort and Filter Command to Filter Multiple Rows Step 1: ➤ Select the headers of the table. ➤ Under the Home tab, select the ...

How to Filter Multiple Rows in Excel: 11 Suitable Methods

Dynamic Range for Multiple Columns with Excel OFFSET

Jun 9, 2024

A dynamic range expands automatically when you update the raw data in the range. In this article, we’ll discuss the ways to apply the OFFSET function ...

Dynamic Range for Multiple Columns with Excel OFFSET

How to Filter with Multiple Criteria in Excel (4 Easy Ways)

Jun 27, 2024

Excel FILTER Function: Overview We have the years, the host countries, the champion countries, and the runners-up countries of all the FIFA World ...

How to Filter with Multiple Criteria in Excel (4 Easy Ways)

Dynamic Named Range Based on Cell Value in Excel

Jun 3, 2024

The basic idea of naming a range is the simple — we will use the Name Manager from the Formula tab. For each method, we are going to use the same ...

Dynamic Named Range Based on Cell Value in Excel

How to Sort Columns in Excel Without Mixing Data (6 Methods)

Jul 22, 2024

Dataset Overview Suppose you have a basic table containing the names of students and their respective scores in three courses. In this scenario, ...

How to Sort Columns in Excel Without Mixing Data (6 Methods)

How to Sort Multiple Columns in Excel (5 Quick Methods)

May 15, 2024

We will use the sample dataset below for illustration. Watch Video – Sort Multiple Columns in Excel Method 1 - Using ...

How to Sort Multiple Columns in Excel (5 Quick Methods)

How to Sum Last 5 Values in a Row in Excel (5 Handy Approaches)

Aug 4, 2024

Download the Practice Workbook Finding Sum of Last 5 Values.xlsm 5 Simple Methods to Sum Last 5 Values in a Row in Excel We have a ...

How to Sum Last 5 Values in a Row in Excel (5 Handy Approaches)

How to Get Top 10 Values Based on Criteria in Excel

Jun 1, 2024

We'll use a dataset with student Names and marks in Physics, Chemistry and History. Note that this article uses Excel 365. Some functionalities may ...