Advanced Excel Part 2 - Core-CT

← Back to document page

1 | P a g e Advanced Excel part 2 Instructor Notes September 16, 2016 1) INDEX and MATCH ........................................ ........................................ ........................................ ........ 1 2) Dynamic Tables - Introduction ........................................ ........................................ .............................. 3 3) SUMIFS using a Table ........................................ ........................................ ........................................ .... 5 4) Running Totals (Run_Tot) ........................................ ........................................ ..................................... 6 5) Dashboard / 7 6) INDEX/MATCH: Dynamic Table ........................................ ........................................ ........................... 10 7) SUMIF.

Advanced Excel Part 2 Instructor Notes ... Excel does not consider upper or lower case lettering (c) Excel does not look at formatting 4) Running Totals (Run_Tot) a. SUMIFS can also be used with dynamic tables in a more traditional sense: using the standard argument structure.

  Excel, Advanced, Part, Advanced excel part 2