Excel 2013 Pivot Tables: Including the "Data Model" (full color): Smart Data Analysis (In Everyday Language)

Poleg, Maayan; Barak, Sharon

ISBN 10: 1511954876 / ISBN 13: 9781511954877

Editore: CreateSpace Independent Publishing Platform, 2015

Riguardo questo articolo

Print on Demand.

Codice articolo I-9781511954877

Dati bibliografici

• Titolo: Excel 2013 Pivot Tables: Including the "Data Model" (full color): Smart Data Analysis (In Everyday Language)
• Editore: CreateSpace Independent Publishing Platform
• Data di pubblicazione: 2015
• Lingua: Inglese
• ISBN 10: 1511954876
• ISBN 13: 9781511954877
• Rilegatura: Brossura
• Condizione: New

Descrizione articolo

Riassunto

Excel 2013 Pivot Tables

Including the "Data Model"

A 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 data

While reading the book and using the practice files, you will know to:

Create a Pivot TableoSelect data from the current fileoSelec data from another Excel fileoChange the data sourceoCreate a pivot table based on a dynamic data tablePerform Calculations:oUse sum, average, minimum, maximum and countoShow Percentage of a column total, row total and Grand totaloDisplay the running totaloGroup numeric and date dataoUse calculated field and calculated itemChange The Report StructureoSwitching columns and rowsoAdding columns or rowsoAdding a page break between itemsFormat your Pivot TablesoAdd totals and SubtotalsoSortoFilterYou will also know to•Add slicers and to manipulate then•Add a timelines and to manipulate it•Add charts to your pivot tables•Use the new and innovative feature: "The Data Model"And, of course, You will learn some cool tips and tricks!