First steps – project management
3. Step away from the spreadsheet – common errors in using spreadsheets, and their ramifications
Measuring loans and accounting for variation
Visits and how to organize the data into columns
Browsed items and avoiding false conclusions
5. Getting the most out of your raw data
Make it easy stupid! Absolute and relative formulas
Typical error messages and what they mean
Using a table to populate a validation list
Creating a PowerPivot PivotTable
The difference between a measure and a calculated column
9. How to create your own desktop library cube
Using MS Access to create a merged dataset
Linking PowerPivot to the merged dataset
3.128.226.121