User Posts: Al Arafat Siddique
0
How to Get Excel Sheet Name (2 Methods)
0

This article illustrates 2 convenient ways to get the sheet name in Excel. The sheet name is a name property of the Worksheet Object in Excel. Download ...

0
How to Use Number Format Code in Excel (13 Ways)
0

This article illustrates the use of number format code in Excel to change the appearance of a number. The actual number doesn’t change, shown in the formula ...

0
How to Use COUNTIF with SUBTOTAL in Excel (2 Methods)
0

In this article, we’ll illustrate how to use the COUNTIF function with the SUBTOTAL function in Excel to count filtered data using two convenience methods. ...

0
How to Use Cell References in Excel Formula (3 Ways)
0

The use of cell references in an Excel formula is very important when formulas are copied and pasted to other cells. Excel worksheet is made of cells and we ...

0
How to Format Text Using Excel VBA (12 Methods)
0

In this article, we’ll illustrate how to change the format of a text in Excel using VBA code. While working with a large amount of information, formatting text ...

0
How to Use VBA AutoFill in Excel (11 Examples)
0

Using autofill in Excel with VBA is a great tool to use while working with data that is repetitive or in a sequential pattern. Excel gives us several options ...

0
How to Use Excel Date Shortcut
0

This article illustrates how using Excel date shortcut makes dealing with dates in Excel easier. While making reports, budgets, calendars, and project ...

0
How to Use the VBA DateAdd Function in Excel
0

The VBA DateAdd function is under the date and time category of Excel’s VBA functions. By using this function we can add or subtract years, months, days, ...

0
How to Perform the What If Analysis with Data Table in Excel
0

In this article, we’ll illustrate the use of the What If Analysis with data table and how it is useful to make financial decisions. Download the Practice ...

0
How to Convert Date to Number in Excel (4 Methods)
0

In many situations, we need to convert Date to Number in Excel to accomplish a calculation. Working with Date and Time values is one of the trickiest parts of ...

0
How to Use LN Function in Excel (9 Examples)
0

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

0
How to Use RATE Function in Excel (3 Examples)
0

The RATE function in Excel is a financial function that calculates the interest rate per period of an annuity to pay off a loan or the rate of return needed to ...

0
How to Use PV Function in Excel (3 Examples)
0

The Excel PV function is a financial function that calculates the present value of an investment: the total amount that a series of future investments is worth ...

0
How to Lock Columns in Excel (4 Methods)
0

The feature in Excel to lock columns is very useful to protect a confidential file from an unauthorized person while sharing information. Even working by ...

0
How to Collapse Rows in Excel (6 Methods)
0

The feature in Excel to collapse rows makes them disappear from the display. You may have a lot of rows in your dataset but don’t need to work with them all at ...

Browsing All Comments By: Al Arafat Siddique
ExcelDemy
Logo