Basic Excel for Analysts Part 1 – SUMIF, VLOOKUP, INDEX+MATCH, NESTED IF

In part 1 of Basic Excel for Analysts, Dr. Sridhar Pappu shows the power of excel for creating dashboards, and explains how and when to use the following formulas: SUMIF, VLOOKUP, INDEX+MATCH, NESTED IF.

Other posts of the series

  1. Basic Excel for Analysts Part 1 - SUMIF, VLOOKUP, INDEX+MATCH, NESTED IF
  2. Basic Excel for Analysts Part 2 - Arithmetic and Text Operations
One Comment
  1. Pingback: Basic Excel for Analysts Part 1 – SUMIF, VLOOKUP, INDEX+MATCH, NESTED IF

Leave a Reply

Your email address will not be published. Required fields are marked *