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.

It’s time to decide the best way to display your links on a page. If you are using MOSS, you have what I consider five options: Links List, Content Editor Web Part, Content Query Web Part, Summary Links Web Part, and I Need to.. Web Part. It really comes down to how many links are you trying to display?

focus is on End User topics including SharePoint Project Planning, Governance, and Design. Additionally, I’ve co-authored a book with Nicola Young focused on solving business problems with MOSS.