0:00 Intro
1:22 Scenario 1, merging 2 lists and removing all duplicates to leave unique entries.
7:31 Scenario 1, here we have 2 separate lists of students with different test results and we want to compare the results from both sheets, only for the students that exist in both lists.

Tutorials referred to in this video:

Lookup Functions
   • Excel References, Relative, Absolute ...  

Relative, Mixed and Absolute References
   • Excel References, Relative, Absolute ...  

Conditional Formatting
   • EXCEL, Conditional Formatting EXPLAIN...