CreateSpace Independent Publishing Platform, 2015. — 155 p. in color. — (In Everyday Language). — ISBN: 1511954876, 151182087XA pivot table is a simple, yet powerful technique, that enables Excel's users to transform data overload into meaningful and organized knowledge.With pivot tables you can:
See the data in dozens of different ways with a simple mouse drag
Perform fast calculations with no need for formulas
Focus on another part of the data each time and get a clear picture
Show more trends and patterns
Create dozens of reports and charts to analyze your dataWhile reading the book and using the practice files, you will know to:
Create a Pivot Table o Select data from the current file o Selec data from another Excel file o Change the data source o Create a pivot table based on a dynamic data table Perform Calculations: o Use sum, average, minimum, maximum and count o Show Percentage of a column total, row total and Grand total o Display the running total o Group numeric and date data o Use calculated field and calculated item Change The Report Structure o Switching columns and rows o Adding columns or rows o Adding a page break between items Format your Pivot Tables o Add totals and Subtotals o Sort o FilterYou will also know to:
Add slicers and to manipulate then
Add a timelines and to manipulate it
Add charts to your pivot tablesUse the new and innovative feature: "The Data Model" And, of course, You will learn some cool tips and tricks!
