This video demonstrates how to use the RELATEDTABLE function in Excel's Power Pivot add-in.
------------------------