Excel Function - Free Excel Tutorial

How to Lookup the Next Largest Value

This post will provide you with two different methods to lookup the next largest value in Excel: using a formula and using VBA code. While both methods achieve the same result, they differ in their implementation and can be used depending on your specific requirements. 1. Find the Next Largest Value Using Formula If you… read more »

How to get nth Match with One Criteria using INDEX/MATCH

This post will guide you how to get nth match based on one criteria with INDEX and MATCH in Excel. In the previous post, we used one excel formula to get the position of the nth occurrence of a value based on one criteria. 1. Get nth Match with One Criteria using INDEX/MATCH Formula At… read more »

Sort by Second or Third character in a Column

This post will guide you how to sort text string by second or third character in a Column in Excel. You may be want to sort a string in a Cell by the Second or last character in excel, how to quickly do it? You can use the Excel Formula or Text to Column feature… read more »

How to count the number of line breaks in a cell

This post explains that how to count the number of line breaks in a cell using excel formula. How do I count line breaks in a single cell in excel. In the previous post, we talked that how to count specific words in a cell and this post will guide you how to count line… read more »

How to Generate Random Passwords in Excel

This post will teach you how to quickly generate a random password with Formula in Excel. You can combine a series of worksheet functions to create a complex formula to generate a random password in Microsoft Excel. How do I create an random code generator in Excel. 1. Video: Generate Random Passwords or Letters 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 »

Excel PPMT Function

This post will guide you how to use Excel PPMT function with syntax and examples in Microsoft excel. Description The Excel PPMT function returns the payment amount on the principal for a given period for a loan or investment based on constant payments and a constant interest rate. So you can use PPMT function to… read more »

Sidebar