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 […]

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 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 EXPON.DIST function

The EXPON.DIST function calculates the exponential distribution representing an outcome in the form of probability. This function was introduced in Excel […]

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 […]

How to create a candlestick chart

The candlestick chart allows you to plot price movements of stocks, derivates, bonds and currencies. A black candlestick in Excel […]

How to use the CHISQ.DIST function

The CHISQ.DIST function calculates the probability of the chi-squared distribution. Use this function to check if a hypothesize is valid. It […]

How to use the CHIDIST function

The CHIDIST function calculates the probability of the chi-squared distribution. Use this function to check if a hypothesize is valid. The […]

How to use the BINOM.DIST function

The BINOM.DIST function calculates the individual term binomial distribution probability, use this function when the success probability is constant through […]

How to use the BINOMDIST function

The BINOMDIST function calculates the individual term binomial distribution probability, use this function when the success probability is constant through […]

How to use the BETA.INV function

The BETA.INV function calculates the inverse of the cumulative beta distribution. This function has replaced the BETA.INV function and was […]

How to create a Box and Whisker chart

The Box and Whisker chart allows you to plot distributions in statistics, it also displays local minimum, first quartile, median, […]

How to use the BETAINV function

The BETAINV function calculates the inverse of the beta distribution. This function is outdated and replaced by the BETA.INV function […]

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 […]