0

How to Get Excel Sheet Name (2 Methods)

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)

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)

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)

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)

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)

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

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

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

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)

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)

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)

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)

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)

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)

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 