Table of Contents How to use the PMT function How to use the PPMT function How to use the PRICEMAT function How to use the PV function How to use the RATE function 1. How to use the PMT function What is the PMT function? The PMT function returns the payment amount needed for borrowing a fixed sum of money based on constant payments (annuity) and interest rate. You can also use the PMT function to calculate the amount to save each period to reach a given sum, based on an interest rate and the number of periods. What is the principal? The principal is the amount you have to pay back and ..read more

Table of Contents How to use the ACCRINT function How to use the ACCRINTM function How to use the AMORLINC function How to use the CUMIPMT function How to use the CUMPRINC function How to use the DB function How to use the DDB function How to use the DOLLARFR function How to use the EFFECT function How to use the FV function How to use the IPMT function How to use the ISPMT function How to use the NOMINAL function How to use the NPER function How to use the PDURATION function 1. How to use the ACCRINT function What is the ACCRINT function? The ACCRINT function calculates the accrued intere ..read more

Table of Contents How to use the IMDIV function How to use the IMEXP function How to use the IMLN function How to use the IMLOG10 function How to use the IMLOG2 function How to use the IMPOWER function How to use the IMPRODUCT function How to use the IMREAL function How to use the IMSEC function How to use the IMSECH function How to use the IMSIN function How to use the IMSINH function How to use the IMSQRT function How to use the IMSUB function How to use the IMSUM function How to use the IMTAN function 1. How to use the IMDIV function The IMDIV function calculates the quotient of two com ..read more

Table of Contents How to use the DEC2BIN function How to use the DEC2HEX function How to use the DEC2OCT function How to use the DELTA function How to use the HEX2BIN function How to use the HEX2DEC function How to use the HEX2OCT function How to use the IMABS function How to use the IMAGINARY function How to use the IMARGUMENT function How to use the IMCONJUGATE function How to use the IMCOS function How to use the IMCOSH function How to use the IMCOT function How to use the IMCSC function How to use the IMCSCH function 1. How to use the DEC2BIN function The DEC2BIN function converts a de ..read more

Table of Contents How to use the NETWORKDAYS function How to use the NETWORKDAYS.INTL function How to use the NOW function How to use the SECOND function How to use the TIME function How to use the TIMEVALUE function How to use the TODAY function How to use the WEEKDAY function How to use the WEEKNUM function How to use the WORKDAY function How to use the YEAR function How to use the YEARFRAC function 1. How to use the NETWORKDAYS function The NETWORKDAYS function returns the number of working days between two dates, excluding weekends. It also allows you to ignore a list of holiday dates ..read more

Table of Contents How to use the DATE function How to use the DATEDIF function How to use the DATEVALUE function How to use the DAY function How to use the DAYS function How to use the EDATE function How to use the EOMONTH function How to use the HOUR function How to use the MINUTE function How to use the MONTH function 1. How to use the DATE function What is the DATE function? The DATE function returns a number that acts as a date in the Excel environment. Table of Contents Introduction Excel function syntax Function arguments DATE Function Example Add or subtract months and days Date f ..read more

Table of Contents How to use the BETADIST function How to use the BETAINV function How to use the BINOMDIST function How to use the CHIDIST function How to use the CHIINV function How to use the CHITEST function How to use the CONFIDENCE functionartif How to use the COVAR function How to use the CRITBINOM function How to use the EXPONDIST function How to use the FDIST function How to use the FLOOR function How to use the FORECAST function How to use the FTEST function How to use the GAMMADIST function How to use the LOGNORMDIST function How to use the MODE function How to use the PERCENTRANK ..read more

Table of Contents How to use the DAVERAGE function How to use the DCOUNT function How to use the DCOUNTA function How to use the DGET function How to use the DMAX function How to use the DMIN function How to use the DPRODUCT function How to use the DSTDEV function How to use the DSTDEVP function How to use the DSUM function How to use the DVARP function 1. How to use the DAVERAGE function What is the DAVERAGE function? The DAVERAGE function calculates an average based on values in a list or database that meet specific conditions. What is the average? It is also known as the mean. It is cal ..read more

Table of Contents How to use the CHOOSECOLS function How to use the CHOOSEROWS function How to use the DROP function How to use the EXPAND function How to use the HSTACK function How to use the TAKE function How to use the TOCOL function How to use the TOROW function How to use the VSTACK function How to use the WRAPCOLS function How to use the WRAPROWS function 1. How to use the CHOOSECOLS function What is the CHOOSECOLS function? The CHOOSECOLS function returns given columns from a cell range or array. The image above shows a set of values in cell range B2:D5, I have enetered a CHOOSECOL ..read more

What is the KURT function? The KURT function lets you calculate the kurtosis in Excel. The kurtosis shows the flatness of a distribution relative to a normal distribution. A high kurtosis tend to indicate large outliers in a distribution, whereas a small kurtosis indicate a flatter distribution. How is the kurtosis calculated in Excel? The math formula Excel uses to calculate the kurtosis is: Xi is each value in the data set. x ̅ is the average of all values. n is the number of values. s is the standard deviation. It is a measure of how spread out the values are. Note, Excel uses STDEV ..read more