How to use the ROUNDDOWN function
What is the ROUNDDOWN function? The ROUNDDOWN function calculates a number rounded down based on the number of digits to […]

Calculate the number of weeks between given dates
This article demonstrates Excel formulas that calculate complete weeks between two given dates and weeks and days between two given […]

Rearrange values using formulas
The picture above shows data presented in only one column (column B), this happens sometimes when you get an undesired […]

Hover with mouse cursor to change stock in a candlestick chart
This article demonstrates how to change chart series while hovering with mouse cursor over a series name. The image above […]

Change chart axis range programmatically
This article demonstrates a macro that changes y-axis range programmatically, this can be useful if you are working with stock […]