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 […]
Latest blog articles
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, […]
The DELTA function evaluates whether two numerical values are equal. This function is also known as the Kronecker Delta function, read […]
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 […]
The CSC function calculates the cosecant of an angle (radians). The CSC function returns the same value as 1/SIN(number). Formula in […]
The radar chart allows you to plot values based on a center point and outwards to categories you specify. Each […]
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 […]
Use the treemap chart when you want to compare segments to a total and you have categories in a hierarchy. […]
The IPMT function calculates the interest payment for a specific period for an investment based on repeated constant payments and a […]
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 […]
The PPMT function calculates the principal payment for a specific period for an investment based on repeated constant payments and a […]
The area chart is similar to the line chart except that the area below the line is filled, use this […]
The DB function calculates the depreciation of an asset for a given period using the fixed-declining balance method. Formula in […]
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) […]
The GCD calculates the greatest common divisor that divides all given arguments without a remainder. Formula in cell D3: =GCD(B3:B4) Excel […]
The bubble chart allows you to plot data just like the scatter chart but also the size of the bubbles. […]
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 […]
The GAMMA function calculates the GAMMA value. It is an extension of the factorial function, the argument is shifted down […]
The chart above contains no legend instead data labels are used to show what each line represent. How to build […]
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). […]
The scatter chart is great for charting numeric values in pairs, for example, coordinates. It lets you compare multiple data […]
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 […]
The image above shows you categories (countries) grouped into regions making this chart a lot cleaner and easier to read. How […]
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 […]
The SLOPE function calculates the slope of the linear regression line through coordinates. Formula in cell B10: =SLOPE(B3:B7,C3:C7) Excel Function […]
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 SKEW function calculates the skewness of a group of values with an asymmetric tail from its mean value. Formula in […]
The line chart lets you chart data points as a line, this chart type is useful if you have many […]
The PROB function calculates the probability that values in a range are between a given lower and upper limit. Probability […]
The bar chart is simply a column chart rotated 90 degrees right, this makes it great if you have long […]
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 […]
The PMT function returns the payment amount needed for borrowing a fixed sum of money based on constant payments and […]
The PHI function calculates a number of the density function for a standard normal distribution. Formula in cell C3: =PHI(B3) Excel […]
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 […]
Welcome! I am 