if you use ms sql server start with installing the olap server and olap services, then go through the tutorial and sample application.
Integrating those cubes with excel is very simple, use a pivot table after you've built the cubes and just 'point' excel to the data source for your cube.