All articles in 'Interview Questions' Category

How can you analyze 1mn+ rows data – Excel Interview Question – 02

How can you analyze 1mn+ rows data – Excel Interview Question – 02

As part of our Excel Interview Questions series, today let’s look at another interesting challenge. How can you analyze more than 1 million rows data in Excel?

You may know that Excel has a physical limit of 1 million rows (well, its 1,048,576 rows). But that doesn’t mean you can’t analyze more than a million rows in Excel.

The trick is to use Data Model.

Continue »

VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01

Published on Aug 15, 2019 in Interview Questions, Learn Excel
VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01

This is part of our Excel Interview Questions series.

VLOOKUP or INDEX+MATCH? When you should use each function and why?

This is such a great question to ask in interviews. So in my first installment of Excel interview questions, let me answer it.

Continue »