User Posts: Prantick
0
Example of Relative Cell Reference in Excel (3 Uses)
0

Relative Cell Reference in Excel is one kind of cell reference where the referred cell changes when it is copied, moved or used in an array. It is a very ...

0
How to Group Duplicates in Excel (3 Methods)
0

Sometimes our Excel dataset may have duplicate values. These duplicates can be just multiple entries of the same data. To find out how many duplicates our ...

0
Dealing with Time Format in Excel (5 Suitable Ways)
0

In Excel time and date is stored as a regular number which is known as date serial number. But we can use the formatting features of Excel to display time in ...

0
How to Use VBA DateSerial Function in Excel
0

DateSerial function is an Excel time and date function which can be used in VBA to get a date from a specified year, month and day value. From this article, ...

0
How to Copy and Paste in Excel Using VBA (7 Methods)
0

Copy and Paste is the most frequent task done in Excel. In addition to worksheet functions, we can also copy and paste data in VBA. In this article, I’ll show ...

0
How to Calculate Exponential Moving Average in Excel
0

Exponential Moving Average is widely used for forecasting future data and smoothening stock price movement. If you want to know what an exponential moving ...

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

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

0
How to Use TRUNC Function in Excel (4 Examples)
0

The TRUNC function in Excel truncates a number to a specified number of digits. It is under the category of Excel Math and Trigonometry function. The function ...

0
How to Use MODE Function in Excel (4 Examples)
0

The MODE function, an Excel Statistical function returns the most frequently occurring number from an array or set of numbers. MODE.SNGL function along with ...

0
How to Use CODE Function in Excel (5 Examples)
0

The CODE function, an Excel Text function returns a numeric code for the first character of a text string. The returned numeric code is based on the character ...

0
How to Use TIMEVALUE Function in Excel (4 Examples)
0

Excel TIMEVALUE function (a date & time function) converts a text time in a decimal number between 0 (12:00:00 AM) to 0.999988426 (11:59:59 PM). The text ...

0
How to Use CHAR Function in Excel (6 Suitable Examples)
0

Excel CHAR function (a Text function) gives a specific character when a valid number is given as the input. Some characters are hard to find, you can easily ...

0
7 Types of Lookup You Can Use in Excel
0

One of the frequent uses of Excel is looking up for a value in a table or data range. In Excel, we have 4 dedicated lookup functions. Besides that, we can ...

0
How to Select Row in Excel If Cell Contains Specific Data (4 Ways)
0

Sometimes you may need to select an entire row based on any specific data in a cell of that row. You can do the task in multiple ways. In this article, I’ll ...

0
If Cell is Blank Then Show 0 in Excel (4 Ways)
0

In Excel, if there is no data in any cell, it normally remains blank. But you can display 0 in the blank cells by following some techniques. In this article, ...

Browsing All Comments By: Prantick
ExcelDemy
Logo