Latest Blog Posts

How to Call a Sub in VBA in Excel (4 Examples)

Example 1 - Call a Sub without Arguments from Another Sub in VBA in Excel We will call a Sub without any argument from another Sub in VBA. Sub1 ...

How to Use LN Function in Excel (9 Examples)

The LN function in Excel is a Math Function that returns the natural logarithm of a number. Here is an overview: Introduction to the LN ...

How to Use SIGN Function in Excel (7 Effective Examples)

Sometimes, we need the sign of any real number. Regarding the demand, Excel provides the SIGN function which returns the sign of number quickly. In ...

How to Use the YEARFRAC Function in Excel – 7 Methods

This is an overview:   The YEARFRAC Function in Excel  Function Objective The YEARFRAC function is used to calculate the fraction of ...

How to Use PRODUCT Function in Excel (With 9 Examples)

The PRODUCT function is used to multiply numbers in Excel. Usually, you can multiply numbers using the product sign (*) in between numbers. But that ...

How to Use the ABS Function in Excel – 12 Examples

This is an overview:   The ABS Function Function Objective: The ABS function is used to get the absolute value of a number. You ...

How to Use the XIRR Function in Excel (3 Methods)

  The following dataset has Periods, Cash Flow, and Date columns. Using this dataset, we will show 3 methods for using the XIRR function in ...

How to Hide Columns in Excel (6 Easy Ways)

Method 1 - Using the Home Tab from the Ribbon Select the column(s) you want to hide. Navigate to the Home tab on the ribbon. Go to the ...

Different Types of Lookup to Apply in Excel (8 Types)

Here's an overview of the functions and formulas for different types of lookups in Excel. What Is a Lookup in Excel? A lookup means ...

How to Return a Value in VBA Function (Both Array and Non-Array Values)

In this article, I’ll show you how you can return a value from a User-Defined Function in VBA in Excel. I’ll show you how to return an array value, a ...

How to Use the Excel EXP Function – 5 Examples

The Excel EXP function is also known as exponential function. EXP Function in Excel Summary The EXP function calculates and returns the ...

How to Use ROUNDUP Function in Excel (6 Examples)

Here's an overview of the ROUNDUP function and its most common uses. ROUNDUP Function: Syntax & Arguments ⦿ Function Objective The ...

How to Use Excel SHEET Function (6 Examples)

Microsoft Excel has a variety of functions and tools. The Excel SHEET function accepts only one argument, value, which can be a reference, a ...

How to Use Excel XOR Function (5 Suitable Examples)

Excel XOR Function: Syntax and Arguments ⦽ Function Objective: Performing exclusive OR function ⦽ Syntax: XOR(logical1, ,…) ⦽ ...

Best value How to Use Excel XOR Function (5 Suitable Examples)

How to Use ROUNDDOWN Function in Excel (5 Methods)

While working with numbers that have decimal parts in Excel we need to round down those numbers for ease of calculation or decimal parts of the ...

Close the CTA

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo