Category: Advanced

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...

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 – 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...