Using SharePoint Lists as a data source in … well Excel

I am being asked to provide weekly data updates and …. I hate paperwork, especially when no matter how many of these I create, no one looks at them but they keep telling me that thisor that column is missing. Well SharePoint Lists are a perfect place to keep the action log and the updates for those actions, but people want to keep using Excel. It  is mainly because they don’t know how or what sharepoint lists do – but Excel – they know. My question to be answered is “how can I work in sharepoint and do a query to get a report that they will [never] be happy with”. Lets explore this. I have office 2013 and SharePoint 2013 now.