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...
Tagged: excel tutuorial
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...
Pareto Analysis With Excel
Pareto Analysis is commonly used in reporting and everybody seems to like it. It is probably because most people understand it. That’s why I...
Interactive Report With Slicers
Here is another nice report that can be filtered dynamically. This kind of reports are pretty impressive for people who doesn’t know how easy they...
Excel Gantt Chart (Conditional Formatting)
Do you need an Excel Gantt Chart to track progress of your project or plan or production schedule? Here is a very quick and...
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,...
