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 […]
Latest blog articles
The image above shows top 10% values using conditional formatting applied to cell range B2:G13. Cell range B2:G13 contains 72 […]
Chart gridlines are great for making the chart data more readable and detailed, Excel allows you to add major and […]
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 […]
The FTEST function calculates the value from an F-test. The value shows if the variances from two data sets are […]
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 […]
The image above shows top 10 values using conditional formatting applied to cell range B2:G13. How to format Select cell […]
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 […]
The FDIST function calculates the F probability of the right-tailed distribution for two tests. This function is outdated and is […]
The image above demonstrates a line chart containing two data series and two y-axes, one for each data series. I […]
The conditional formatting formula applied to cell range F3:F13 highlights all cells containing text. Here is how I did it: […]
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 […]
The COVAR function calculates the covariance meaning the average of the products of deviations for each pair in two different […]
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 […]
The COTH function calculates the hyperbolic cotangent of a hyperbolic angle. The function has been available since Excel 2013. Formula […]
The XOR function was introduced in Excel 2013 and calculates the logical exclusive OR meaning if at least one of the […]
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 […]
Welcome! I am 