Latest Blog Posts - Page 490 of 587

How to Delete Hidden Rows in Excel: 3 Methods

Jul 6, 2024

Method 1 - Utilizing the ‘Inspect Document’ Option to Delete Hidden Rows in Excel Hide the highlighted rows, select the rows. Right-click on ...

How to Delete Hidden Rows in Excel: 3 Methods

How to Use Year Function in Excel VBA (5 Suitable Examples)

Nov 11, 2025

The Year function in Excel VBA is under the Date and Time category functions. If we use it in a VBA code, it extracts the year from the date which we ...

How to Use Year Function in Excel VBA (5 Suitable Examples)

How to Use VBA MONTH Function in Excel (7 Suitable Examples)

Jul 30, 2024

The MONTH function falls under the Date or Time category. The MONTH function works both in worksheet and VBA Macros. It takes only one argument. ...

How to Use VBA MONTH Function in Excel (7 Suitable Examples)

Example with Absolute Cell Reference in Excel (4 Apllications)

Nov 11, 2025

In this article, we will let you know what absolute cell reference in Excel is and describe it with 4 useful examples. What is Absolute Cell ...

Example with Absolute Cell Reference in Excel (4 Apllications)

How to Calculate Time in Excel (17 Possible Ways)

Jul 3, 2024

For illustration, we will use the sample dataset below. Method 1 - Calculate Time Difference in Excel Using Operator ⏩ In cell E4, type ...

How to Calculate Time in Excel (17 Possible Ways)

How to Timesheet Formula in Excel: 5 Methods

May 28, 2024

Method 1 - Excel Timesheet Formula: Using Simple Subtraction Apply the simple arithmetic subtraction formula within this Excel timesheet. To do ...

How to Timesheet Formula in Excel: 5 Methods

How to Find Duplicates in Excel Workbook (5 Methods)

Jun 16, 2024

Suppose there are two sheets in the workbook named Sheet1 and Sheet2. Sheet1 represents the employee name with their states while Sheet2 displays the ...

How to Find Duplicates in Excel Workbook (5 Methods)

How to Use SLN Function in Excel (3 Examples)

Nov 11, 2025

The SLN function, an Excel Financial function, calculates the depreciation of an asset for one time period using the straight line method for ...

How to Use SLN Function in Excel (3 Examples)

How to Use the Advanced Filter in VBA (A Step-by-Step Guideline)

Jul 4, 2024

In this article, we'll demonstrate how to use Excel's Advanced Filter in VBA. Excel Advanced Filter Overview Advanced Filter is a tool ...

How to Use the Advanced Filter in VBA (A Step-by-Step Guideline)

How to Use EoMonth in Excel VBA (5 Examples)

Jul 7, 2024

Download Practice Workbook Uses of EoMonth.xlsm Overview of EoMonth Function in VBA ⏺ Function Objective Returns the serial number for ...

How to Use EoMonth in Excel VBA (5 Examples)

Mortgage Calculations with an Excel Formula – 5 Examples

Aug 10, 2024

Example 1- Formula to calculate the Monthly Mortgage Payment in Excel Consider that you want to start a business and take a loan: $150,000 (C7). ...

Mortgage Calculations with an Excel Formula – 5 Examples

Why Concatenate Isn’t Working in Excel (3 Common Reasons and Solutions)

Jul 28, 2024

Dataset Overview We'll use the below dataset containing the lists of first names and last names to investigate why Concatenation is not working: ...

Why Concatenate Isn’t Working in Excel (3 Common Reasons and Solutions)

How to Merge Duplicates in Excel (6 Ways)

Jul 6, 2024

We'll use the following table to demonstrate how to merge duplicates in Excel. Method 1 - Using the IF Function to Merge Duplicates with ...

How to Merge Duplicates in Excel (6 Ways)

How to Delete Filtered Rows in Excel?

Nov 11, 2025

Excel provides the user with a great functionality named Filter which helps us to only view the data we need while hiding all the non-relevant data. ...

How to Use the VBA DatePart Function in Excel (7 Examples)

Nov 11, 2025

One of the most important and widely used functions that we encounter while working with VBA is the DatePart function of VBA. Today in this article, ...