Category: Advanced

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

Excel Slicer Calendar

Here is a calendar which you can manage your daily agenda with ease. It is very easy to make and use this excel slicer calendar....

Custom Excel Autofill Lists

As we saw in Excel Autocomplete and Autofill post, excel is very helpful in data inputting matters. It helps you for inputting data in several...

Custom Number Formats In Excel

Sometimes you need to deal with very large numbers with alot of digits. They are hard to read at a glance, messes your table layouts,...