Tagged: excel tutuorial

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

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

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