Excel Pivot Tables |
|
|---|---|
| Preview: |
 |
| Details: | A high quality and detailed source of information on designing, maintaining and using Microsoft Excel Pivot Tables (Crosstabs, OLAP Cubes). It shows how to connect to a data source, use the data fields in a crosstab, perform custom calculations, subtotals, running totals, group the data, consolidate ranges and apply security to a Pivot Table. The great feature of that course is that it shows how to perform the tasks mentioned above both manually and programmatically (using VBA) when applicable. |
| Address: |
www.contextures.com/xlPivot01.html |
| Categories: | EXCEL COURSES |