Excel 2013 pivot table data crunching /

Jelen, Bill.

Excel 2013 pivot table data crunching / by Bill Jelen, Michael Alexander. - New Delhi : Pearson education, 2013. - iv, 417 p. : ill. ; 24 cm - MrExcel Library .

Includes index.

CHAPTER 1: Introduction ------------------
CHAPTER 2: Pivot table fundamentals ----------------------
CHAPTER 3: Creating a basic pivot table --------------------
CHAPTER 4: Customizing a pivot table ---------------------
CHAPTER 5: Controlling the way you view your pivottable -------------------------
CHAPTER 6: Performing calculations within your pivot tables -----------------------
CHAPTER 7: Using pivot charts and other visualizations --------------------
CHAPTER 8: Analyzing disparate data sources with pivottables -----------------------
CHAPTER 9: Sharing pivottables with others --------------------
CHAPTER 10: Working with and analyzing olap data ---------------------
CHAPTER 11: Mashing up data with powerpivot -------------------
CHAPTER 12: Powerview -----------------------
CHAPTER 13: Enhancing pivottables with macros ---------------------
CHAPTER 14: Using VBA to create pivot tables --------------------
CHAPTER 15: Advanced pivottable tips and tricks --------------------
CHAPTER 16: Dr. Jekyll and Mr. GetPivotData ------------------
Index -----------------------.

9789332523968(pbk)

2012049161


Microsoft Excel (Computer file)


Business--Computer programs.
Business intelligence--Computer programs.

005.54 / JEL-E 2013 4003