Excel Functions

How to Use TIMEVALUE Function in Excel (4 Examples)

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). ...

How to Use TREND Function in Excel (3 Examples)

The TREND function is a Statistical function in Excel. This article will show you how to use Excel’s TREND function with 3 examples. ...

How to Use IPMT Function in Excel (8 Examples)

The IPMT function in Excel is used to find the interest payment of a loan amount for a certain period. In this article, you will get to know the ...

How to Use Excel HYPERLINK Function?

The HYPERLINK function belongs to the Excel Lookup and Reference functions category. The function aids in the linking of data across several ...

How to Use SIN Function in Excel (6 Easy Examples)

The SIN function is used to determine the sine of angles in Excel. By default, the SIN function accepts the angles in radians. However, with the help ...

How to Use QUARTILE Function in Excel (5 Suitable Examples)

The QUARTILE function is a built-in function in Excel that is categorized as a Statistical Function. Quartiles are values that split your data into ...

How to Use Excel SLOPE Function (5 Quick Examples)

Microsoft Excel provides various types of functions to make the work more convenient. Excel SLOPE function is one of them. In this article, we will ...

How to Use Excel DSUM Function (4 Appropriate Examples)

Excel DSUM function is a Database sum function. The DSUM function calculates the sum of specified fields following specified criteria. It takes three ...

How to Use CHAR Function in Excel (8 Suitable Examples)

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 ...

How to Use TTEST Function in Excel (5 Methods)

The TTEST Function in Excel is categorized as a Statistical Function. The function is frequently used to compare the probability of two samples ...

How to Use the Excel UNIQUE Function to Extract Unique Values (20 Examples)

In large datasets, duplicate values or repeated occurrences of the same values can be a common issue. To address this, you can utilize the Excel ...

How to Use Excel WEEKNUM Function (5 Examples)

The Excel WEEKNUM function helps users to determine the week number of a provided date efficiently. It enables users to extract and manipulate week ...

FORECAST Function in Excel (with other Forecasting Functions)

Excel offers many useful features and functions that reduce our workload significantly. For example, Excel can predict future output based on past ...

How to Use YEARFRAC Function in Excel (7 Ways)

In Microsoft Excel, the YEARFRAC Function is used to find the fraction of the year represented by the real value of whole days between two dates. ...

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 ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo