Excel Functions - Free Excel Tutorial

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

March 22, 2020

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

August 27, 2018

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

August 23, 2018

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

May 12, 2018

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

May 12, 2018

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

May 12, 2018

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

May 12, 2018

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

May 12, 2018

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

May 11, 2018

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

May 11, 2018

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 »