Chandoos Top 10 Analyst Functions

Question 0

VLOOKUP

Answer 0

search for a value in a table and return a corresponding value

=VLOOKUP(what you want to lookup, table, column from which you want the output, is your table sorted?)

can only search on left most column.

Question 1

SUMIFs

Answer 1

Easy to sum on multiple conditions

sum up a set of values that meet several conditions.

=sumif( what you want to sum, condition columns)

Question 2

Index+Match Formulas

Answer 2

lookup on any column and return corresponding value from any other column.

=INDEX(list of values, MATCH(what you want to lookup, lookup column, is your lookup column sorted?))

Question 3

Nesting Formulas

Answer 3

Nesting formulas helps us express complex business logic & rules with ease. As an analyst, you must learn the art of nesting.