How to use the BETA.DIST function

The BETA.DIST function calculates the beta distribution. It represents outcomes in the form of probabilities. This function was introduced in Excel […]

This extensive list provides detailed information including syntax, arguments, return values and examples for most of the functions used in Excel.

The list is easy to search and lets you sort by function name or category.

This is a great place to start learning Excel functions.

How to use the BETA.DIST function

The BETA.DIST function calculates the beta distribution. It represents outcomes in the form of probabilities. This function was introduced in Excel […]

How to use the BETADIST function

The BETADIST function calculates the beta distribution representing an outcome in the form of probability. This function is in the compatibility […]

How to use the RANK.EQ function

The RANK.EQ function calculates the rank of a number in a list of numbers, based on its position if the […]

How to use the CONFIDENCE.T function

The CONFIDENCE.T function calculates the confidence range for a population mean using a Student's t distribution. Formula in cell C7: […]

How to create a histogram chart

The histogram chart lets you automatically group data values in intervals you specify, it is often used in statistics to show […]

How to use the CONFIDENCE.NORM function

The CONFIDENCE.NORM function calculates the confidence interval for a population mean. Formula in cell C7: =CONFIDENCE.NORM(C3,C4,C5) Excel Function Syntax CONFIDENCE.NORM(alpha,standard_dev,size) […]

How to create a combined Column and Line chart

The Column and Line combo chart is a great choice if you want to differentiate two data series and make […]

How to use the MODE.SNGL function

The MODE.SNGL function calculates the most frequent value in an array or cell range. Excel Function Syntax MODE.SNGL(number1,[number2],...) Arguments number1 […]

How to use the FLOOR.PRECISE function

The FLOOR.PRECISE function rounds a number down to the nearest integer or nearest multiple of significance. Excel Function Syntax FLOOR.PRECISE(number, […]

How to create a waterfall chart

The waterfall chart allows you to plot values as bars, however, depending on whether they are negative or positive […]

How to use the DOLLARFR function

The DOLLARFR function converts a decimal number to its equivalent in fractional numbers, used in securities denominated in dollars. Excel […]

How to create a doughnut chart

A doughnut chart is just like a pie chart showing the relationships of segments to a total except that the it […]

How to use the CUMIPMT function

The CUMIPMT function calculates the accumulated interest based on a start and end period on a loan. The image above shows […]

How to use the CUMPRINC function

The CUMPRINC function calculates the accumulated principal based on a start and end period on a loan. The image above shows […]

How to create a sunburst chart

(Click to expand image) The sunburst chart is great for showing relationships of hierarchical data and their sizes. Each ring corresponds […]

How to use the GROWTH function

The GROWTH function returns estimated exponential growth based on given data. It calculates the y-values for new x-values based on […]

How to use the ERROR.TYPE function

The ERROR.TYPE function returns a number that represents one of the error values in Excel. Formula in cell C3: =ERROR.TYPE(B3) […]

How to use the GEOMEAN function

The GEOMEAN function calculates the geometric mean. It represents the typical value of a set of numerical values based on the […]

How to use the RANGE.OFFSET property

The OFFSET property returns a Range object based on a row and column number. The image above shows a macro […]

How to use the SGN function [VBA]

The SGN function returns an integer that shows the sign of the number. Argument SGN returns Number greater than 0 (zero). […]

How to use the WORKDAY function

The WORKDAY function returns a date based on a start date and a given number of working days (nonweekend and […]

How to use the YEARFRAC function

The YEARFRAC function returns the fraction of the year based on the number of whole days between a start date […]

How to use the FIX function [VBA]

The FIX function removes the decimals from the argument. Excel Function VBA Syntax Fix(number) Arguments number Required. Is a Double or […]

How to use the INT function [VBA]

The INT function removes the decimals if the numeric value is above 0 (zero) and returns a negative integer less than […]

The pie chart is used to graph parts of a whole, the total of our numbers must be 100%. The […]

How to use the RANGE.FIND method

The Range.Find method returns a range object for the first cell that matches the lookup value. Macro used in workbook above The […]

The line chart lets you chart data points as a line, this chart type is useful if you have many […]

How to use the PRICEMAT function

The PRICEMAT function calculates the price per $100 nominal value of a bond that pays interest at maturity. Formula in […]

How to create a 100% stacked column chart

The 100% stacked column chart lets you graph values in a group. Each value in a group is a stacked […]