This is a new function is Excel 2013. So if you are on an older version, you are out of luck. I tried to pull up the attached spreadsheet that has a Mac version of Excel 2010, and I received the dreaded #NAME? error.
In the video, Oz du Soleil mentions that most explanations of this functions are programming examples. So he offers this explanation of XOR. The example reminds me of College/University, where different combinations of prerequisites can be met to satisfy the requirement.
The scenario is the attached spreadsheet and video is where a teacher must agree to teach EITHER:
Please log in again. The login page will open in a new window. After logging in you can close it and return to this page.