X Axis Labels Below Negative Values
You want x axis labels below negative values, but when you have positive and negative values on same chart, x axis labels gets placed in...
Author: melih
Export Table From PDF to Excel
Here is another easy way to export table from pdf to Excel. This method solves age old problem of exporting data tables from pdf to...
Excel Comparison Chart With One Vertical Axis
A comparison chart is useful for comparing series with each other while comparing them with their targets simultaneously. In this post, I will show you...
Why Weeknum Function Returns Wrong Value ?
This year WEEKNUM Function returns wrong value if you are using it as usual. Because Excel considers the week containing 1st of January as week...
Fill Series
If you ever had to create a series of numbers or a numbered list in Excel, you probably did so by dragging the fill handle...
IFS Function
With IFS Function you don’t need to deal with nested IF functions anymore. IFS is an if function that can take multiple conditions.
