First Empty Cell In A Column (Excel VBA)
Locating first empty cell in a column is a common issue for alot of macros that are designed selecting cells or pasting values to orher...
Beat Excel! Get to next level in Excel!
Compound Interest Calculation In Excel
There is not a preset function for compound interest calculation in Excel. But here is an easy formula which can easily substitute for that.
Pivot Table Row Labels In the Same Line
It is a common issue for users to place multiple pivot table row labels in the same line. You may need to summarize data in...
Report Template With Hyperlink
Here is a very creative use of hyperlinks to achieve a tabular menu effect. Check the full post to learn how to make a report...
For Each Loop (Excel VBA)
For Each loop is for looping through each element in a collection. It is especially useful when you don’t know how many elements there is...
Save As Multipage PDF File
Would you like your reports to look like e-magazines with multiple pages? Here is how to do it. All you need to know is how...
