In the part 2 of the series you can see how easy it is to use the PowerPivot addon for Excel 2010 to connect to an OData feed and analyze the published data directly in Excel.
Accessing an OData feed from Excel PowerPivot
The video is hi-res, so 720p and full screen view is recommended.
You can also view the past and future episodes of the OData series.