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...
Category: Advanced
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,...
