Sage 200 Business Intelligence is a powerful tool to enable you to query your Sage data directly from Excel and then to "slice and dice" that data for better management decisions.
The video tutorial link below takes you through setting up a report for stock sales and margins and in the process shows you some of the tools that can be used within BI.