Taking Excel to a New Level with SharePoint
In This Chapter
Homing in on SharePoint as the perfect place for Excel spreadsheets
Developing powerful data-analysis tools using Excel and publishing them to SharePoint
Discovering the power of SharePoint Excel Services
Understanding REST-based Excel Web services in SharePoint
Once a new technology starts rolling, if you’re not part of the steamroller, you’re part of the road.
— Stewart Brand
The Microsoft Office Excel product has to be one of the most beloved — and most used — programs in data analysis history. As a consultant, I’m always amazed when I walk into a client’s office and discover how vital Excel is to the organization. Excel provides an easy way for anyone to become a data analyst — but keeping the analysis consistent is difficult if everyone in an organization uses Excel in isolation.
Recognizing the importance (and familiarity) of Excel, Microsoft has taken the tool to a new level by integrating it with SharePoint. Using Excel and SharePoint in unison results in a powerful — and governable — solution that both ...