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