Since TFS 2005, you have had the ability to open work item queries in Microsoft Excel, allowing the user to view the query results in Excel, as well as make changes and push those changes back to TFS.

TFS 2010 uses SQL Server Reporting Services to provide reports, but because it uses data warehouse and analysis services to store reporting information, users can roll their own. We examine how to use ...

If you’re looking for a straightforward method to automate the generation of Excel reports, such as those for end-of-month financial results, there is a simple solution that can save you time ...

Data comes from all kinds of sources and Microsoft Power Query can you when you need to combine foreign data. It’s a bit easier than trying to do so in Microsoft Excel sometimes.