Excel Functions

Excel XLOOKUP Function

Excel XLOOKUP Function was added into Excel as a beta feature in August 2019 and is now accessible exclusively in Microsoft 365. (as of July 2021). However, if you fall into this category and often deal with big sets of data in Excel, understanding this method is worthwhile. In this lesson, we will demonstrate how… read more »

Excel UNIQUE Function

The guide demonstrates how to use the UNIQUE function and dynamic arrays in Excel to create unique values. You’ll learn how to use a basic formula to locate unique values inside a column or row, across many columns, and depending on criteria, among other things. Excel 365’s introduction of the Excel UNIQUE formula altered everything!… read more »

Excel SORT Function

The excel sort function is one of the most useful new features in Excel. It is one of many functions that make advantage of Excel’s new dynamic array calculation engine, which enables Excel to spill results from a single formula across numerous cells. SORT function in Excel The SORT function in Excel sorts the contents… read more »

Excel TRANSPOSE Function

Excel TRANSPOSE formula allows you to rotate (swap) values from rows to columns and vice versa in Excel. Its goal, as a component of the Excel lookup and reference functions, is to arrange data in the appropriate manner. To run the formula, pick the precise size of the transposed range and hit the CSE key… read more »

How to Calculate Retirement Date and Remaining Years refer to Birth Date in Excel

Every company has its own police about the retirement date for employees. Suppose employees will be retired from a certain age of 60, how can we calculate the retirement date for everyone base on their birthdays? Actually, there are several functions can calculate the retirement date in excel, you can use them in proper formula,… read more »

Converting Week Number to Date

This post will guide you how to convert a week number to a date with a formula in Excel. How do I calculate a date from a week number and a year with formula in Excel. Or how to get week number from a given date with formula in Excel. Convert Week Number to Date… read more »

Excel Vlookup From Another Workbook

This post will guide you how to lookup value from another workbook in Excel. How do I use VLOOKUP function across multiple workbooks in Excel. How to vlookup a value from another workbook with a formula in Excel. Excel Vlookup From Another Workbook Before we use the VLOOKUP function to look for a value in… read more »

Excel DVARP Function

This post will guide you how to use Excel DVARP function with syntax and examples in Microsoft excel. Description The Excel DVARP Function will get the variance of a population based on the entire population of numbers in a column in a list or database based on a given criteria. And the DVARP function can… read more »

Excel DVAR Function

This post will guide you how to use Excel DVAR function with syntax and examples in Microsoft excel. Description The Excel DVAR Function will get the variance of a population based on a sample of numbers in a column in a list or database based on a given criteria. The DVAR function is a build-in… read more »

Excel DSUM Function

This post will guide you how to use Excel DSUM function with syntax and examples in Microsoft excel. Description The Excel DSUM Function will add the numbers in a column or database that meets a given criteria. And so you can use the DSUM function to add the numbers in a field of records in… read more »

Excel DSTDEVP Function

This post will guide you how to use Excel DSTDEVP function with syntax and examples in Microsoft excel. Description The Excel DSTDEVP returns the standard deviation of a population based on the entire population of numbers in a column or database that match the given criteria. The DSTDEVP function is a build-in function in Microsoft… read more »

Excel DSTDEV Function

This post will guide you how to use Excel DSTDEV function with syntax and examples in Microsoft excel. Description The Excel DSTDEV returns the standard deviation of a population based on a sample of numbers in a column or database that match the given criteria. The DSTDEV function is a build-in function in Microsoft Excel… read more »

Excel DMIN Function

This post will guide you how to use Excel DMIN function with syntax and examples in Microsoft excel. Description The Excel DMIN returns the minimum value from a database or a column of a list that matches the specified conditions. The DMIN function is a build-in function in Microsoft Excel and it is categorized as a… read more »

Excel DPRODUCT Function

This post will guide you how to use Excel DPRODUCT function with syntax and examples in Microsoft excel. Description The Excel DPRODUCT returns the product of values from a set of records that match criteria that you specify. The DPRODUCT function is a build-in function in Microsoft Excel and it is categorized as a Database… read more »

Excel XIRR Function

This post will guide you how to use Excel XIRR function with syntax and examples in Microsoft excel. Description The Excel XIRR function returns the internal rate of return for a series of cash flows that is not necessarily periodic. And if you want to get the internal rate of return for a series of… read more »

Excel VDB Function

This post will guide you how to use Excel VDB function with syntax and examples in Microsoft excel. Description The Excel VDB function calculates the depreciation of an asset for a specified period based on the double declining balance method. And it will return a numeric value. The VDB function is a build-in function in… read more »

Excel SYD Function

This post will guide you how to use Excel SYD function with syntax and examples in Microsoft excel. Description The Excel SYD function calculates the sum-of-years’digits depreciation of an asset for a specified period. And it will return a numeric value. The SYD function is a build-in function in Microsoft Excel and it is categorized… read more »

Excel SLN Function

This post will guide you how to use Excel SLN function with syntax and examples in Microsoft excel. Description The Excel SLN function calculates the depreciation of an asset for one period based on the straight line depreciation. And it will return a numeric value. The SLN function is a build-in function in Microsoft Excel… read more »

Excel PV Function

This post will guide you how to use Excel PV function with syntax and examples in Microsoft excel. Description The Excel PV function returns the present value of a loan or investment based on constant payments and a constant interest rate. So you can use the PV function to get the present value based on… read more »

Excel RATE Function

This post will guide you how to use Excel RATE function with syntax and examples in Microsoft excel. Description The Excel RATE function returns the interest rate per payment period of an annuity. The RATE function is a build-in function in Microsoft Excel and it is categorized as a Financial Function. The RATE function is… read more »

Sidebar