How to calculate the number of years between dates

The image above demonstrates the DATEDIF function calculating the number of complete years between two dates. Column B and column C […]

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.

Learn to build charts that let you visualize values in order to analyze and comprehend data.

Learn to format data based on a condition or criteria to make you more productive and effective.

How to calculate the number of years between dates

The image above demonstrates the DATEDIF function calculating the number of complete years between two dates. Column B and column C […]

How to use the F.TEST function

The F.TEST function calculates the two-tailed probability from an F-test, the value shows if the variances from two data sets […]

How to use the LBOUND and UBOUND functions

The Lbound and Ubound functions calculate the size of of an array. The Lbound returns the lower limit of an array and […]

How to add Error Bars in a chart

Enable error bars when you want to show, for example, standard deviations in a chart, Excel lets you insert error […]

How to use the NETWORKDAYS.INTL function

The NETWORKDAYS.INTL function calculate the number of working days between two dates, excluding weekends. It also allows you to ignore […]

How to count workdays between two dates

Excel contains a great function that easily counts the number of workdays between two dates, it even allows you to […]

How to use the JOIN function [VBA]

The JOIN function concatenates a set of substrings in an array, the image shows a user-defined function entered in cell […]

Highlight cells containing string [Conditional formatting]

Excel allows you to quickly highlight cells containing a given text string. How to apply Conditional Formatting Select cell range. […]

How to add a moving average to a chart

A moving average smooths out short-term variations to show a long-term trend or cycle. The chart above shows random values […]

How to use the FORECAST function

The FORECAST function calculates a value based on existing x and y values using linear regression. Use this function to […]

How to insert icons representing cell values [Conditional formatting]

Conditional formatting lets you insert icons based on cell values, the idea is to make the data easier to read, […]

How to use the INTERCEPT function

The INTERCEPT function returns a value representing the y-value where a line intersects the y-axis. The line is calculated using […]

How to add a linear trendline to a chart

Excel allows you to insert a linear chart trendline that displays a straight line calculated based on the method of […]

How to customize the chart legend

You can easily customize the font, font size, font color etc of the chart legend: Select legend. Go to tab […]

How to create a combined chart – Column and Line on secondary axis

The combination chart category lets you build a chart that has columns on the primary axis and the line on […]

How to create color scales [Conditional Formatting]

Color scales in conditional formatting applies a color to cells in a cell range based on their values, this lets you […]

How to use the F.DIST.RT function

The F.DIST.RT function calculates the right-tailed F probability for two tests. This function was introduced in Excel 2010 and has replaced […]

How to use the F.DIST function

The F.DIST function calculates the F probability for two tests. This function was introduced in Excel 2010 and has replaced […]

How to add Data Bars to your worksheet

Data bars allows you to insert a data bar into each cell in the selection, the size is based on […]

How to use the EXPONDIST function

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

How to add and customize chart data labels

The image above demonstrates data labels in a line chart, each data point in the chart series has a visible […]

How to customize chart tick marks

The image above shows tick mars in a line chart, there are two types of tick marks, major and minor […]

How to use the BINOM.INV function

The BINOM.INV function calculates the minimum value for which the binomial distribution is equal to or greater than a given […]

How to use the CRITBINOM function

The CRITBINOM function calculates the minimum value for which the binomial distribution is equal to or greater than a given […]

How to customize a chart data series

To change the looks of a data series simply double-click with left mouse button on the data series. If you […]

How to use the CHISQ.TEST function

The CHISQ.TEST function calculates the test for independence, the value returned from the chi-squared statistical distribution and the correct degrees […]

How to use the CHITEST function

The CHITEST function calculates the test for independence, the value returned from the chi-squared statistical distribution and the correct degrees […]

How to use the COVARIANCE.S function

The COVARIANCE.S function calculates the sample covariance meaning the average of the products of deviations for each pair in two […]

How to use the COVARIANCE.P function

The COVARIANCE.P function calculates the covariance meaning the average of the products of deviations for each pair in two different […]

How to create a sparkline – Win/Loss

A win/loss sparkline is a visual representation of a data series in only one cell, the image above shows a […]

How to customize chart axis titles

The x-axis and y-axis titles are just as easy to format and customize as the other chart elements. How to […]

How to customize the plot area

The plot area refers to the location of the chart that displays the actual data represented by lines, bars, columns, […]

How to customize the chart title

I recommend that the chart title is short and easy to understand. How to add a chart title Follow these […]

How to customize the chart area

The chart area contains all components. If you choose to format the chart area you can change things like border, […]

How to use the CHISQ.INV.RT function

The CHISQ.INV.RT function was introduced in Excel 2010 and calculates the inverse of the right-tailed probability of the chi-squared distribution. […]

How to create a sparkline – Column

A sparkline is a visual representation of a data series in only one cell, the image above shows sparklines next […]

How to use the CHISQ.INV function

The CHISQ.INV function was introduced in Excel 2010 and calculates the inverse of the left-tailed probability of the chi-squared distribution. […]

How to create a sparkline – Line

A sparkline is a visual representation of a data series in only one cell, the image above shows sparklines next […]

How to use the CHIINV function

The CHIINV function calculates the inverse probability of the chi-squared distribution. The CHIINV function is outdated and you will find […]

How to use the CHISQ.DIST.RT function

The CHISQ.DIST.RT function was introduced in Excel 2010 and calculates the right-tailed probability of the chi-squared distribution. It has replaced the […]