PowerPivot for the data analyst : Microsoft Excel 2010 / Bill Jelen
Material type:
TextSeries: MrExcel libraryPublication details: Indianapolis, Ind. : Que, c2010Description: xiii, 311 p. : ill. ; 24 cmISBN: - 9780789743152 (pbk.)
- 0789743159
| Item type | Current library | Call number | Copy number | Status | Date due | Barcode | |
|---|---|---|---|---|---|---|---|
|
|
UMPLIB PEKAN | HF5548.4.M523 J454 2010 (Browse shelf(Opens below)) | 1 | Available | 0000063753 |
Includes bibliographical references and index
Downloading and installing PowerPivot -- The promise of PowerPivot -- Why wouldn't I build every future pivot table in PowerPivot? -- Getting your data into PowerPivot -- Creating and managing relationships -- Using data sheet view -- Building pivot tables -- Cool tricks native to pivot tables --Cool tricks new with PowerPivot -- Using DAX for aggregate functions -- Using DAX for date magic -- Named sets, GetPivotData, and cube formulas -- Final formatting : making the report not look like Excel -- Upgrading to PowerPivot server