Removing Personal Information From Workbooks
Excel stores user information on your workbooks in the background. This information consists of author info, creation date, change log and anything else that...
Category: Advanced
Excel Task Manager
Here is a task manager with a progress bar. You can input your daily tasks, give priorities, mark them partially or fully completed and see...
Data Analysis With Pivot Table Part – 2/2
(This is the second part of Data Analysis With Pivot Table Part – 1/2 post) You can also customize your pivot tables with custom...
Data Analysis With Pivot Table Part – 1/2
Pivot table is without a doubt the number one tool for data analysis in excel. Previously I’ve made an introductory post for pivot table. Now...
Customizing Comments
Default excel comments are somewhat ugly as we all know. That strange color and font definately aren’t most fancy stuff. But you can do alot...
Index-Match Combination
We all love and use Vlookup Function very much. It is a great way to find and fetch values from big lists easily. But Vlookup...
