Save As Single File Webpage (MHTML)
There are several ways to protect your files or having them viewed on web browsers. But MHTML format makes both possible at once. When you...
Beat Excel! Get to next level in Excel!
Power Pivot
Power Pivot takes the power of relational database queries to your desktop. Only requirement is Excel 2010 or 2013. And knowing how to use it...
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...
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...
