Excel INDEX Function Tips

Looking Up Number Values

There are five methods you can use to look up number values in excel. These include SUMPRODUCT, SUMIF, AGGREGATE, LOOKUP and a combination of INDEX & MATCH.

Using Index-Match Combination To Ease Up Lookup Process

Most of the time when we are stuck with lookup and return something process, we revert to VLOOKUP() and occasionally HLOOKUP(), according to the situation

Generating Random Data In 5 Minutes

When we are developing a model or trying to test some formula, we need data and when we don’t have one, we have to create it to suit our needs. This is frequently called dummy data.

Microsoft Excel: Using Conditional Formatting To Make Heat Map

A data set’s comparative view can easily be represented visually with the aid of a heat map

Top Formulas for Analysts

If you are wondering what the top ten formulas are, then you should really consider acknowledging the fact that there is no standard list of the perfect ten formulas for each individual.