SharePoint also provides some very sophisticated capabilities for dashboarding, reporting and analysis via Excel Services and PerformancePoint.

The EWA web part allows you to incorporate the charts and tables from Excel that are driving your business into a dashboard page in SharePoint. Perhaps on one page you would like to display one chart with product sales YTD and another chart with revenue dollars per Sales Representative. Using the EWA web part you would be able to do this; the charts could be located in the same spreadsheet or in separate spreadsheets.

There are so many things as an end user you can do with Excel Services however it can be hard to get started. There are not a lot of resources out there for end users to begin using Excel Services, so I aim to fix that. Over the next few months, I will be writing a blog series on how to best utilize Excel Services. This first post will cover the basics, what is it and what you need to do to get started. After that we will move on to more complex stuff like parameters, promoting pivot tables, connecting filters to your charts and tables.

The question of the day comes from Michael:
I am using WSS 3.0 and Excel version xp.I am trying to display a Excel web part. I have tried, read and downloaded everything and i have come to the conclusion I can’t. Is my suspision correct?
Michael – Excel Services are a part of MOSS, so if you are [...]