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

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

How to use the PDURATION function

The PDURATION function calculates how many periods required by an investment to reach a given amount based on a percentage […]

How to use the CONCATENATE function

The CONCATENATE function lets you add text strings into one single text string. The function has been replaced by the […]

Convert column number to column letter

Use the following formula to convert a column number to a column letter: =LEFT(ADDRESS(1, B3, 4), MATCH(B3, {1; 27; 703})) […]

Get date ranges from a schedule

The above picture shows you two formulas that extract names (column B) and date ranges (column C and D) based […]

How to replace part of formula in all cells

This article explains how to substitute part of a formula across all cells in a worksheet. It is easier than […]

Copy data from workbooks in folder and subfolders

I will in this article demonstrate a macro that automatically opens all workbooks in a folder and subfolders, one by […]

Extract unique distinct records from two data sets

The picture above shows an array formula in cell B9:C13 that extracts unique distinct records from two tables in cell […]