Articles liés à Excel 2013 Pivot Tables: Including the "Data Model":...

Excel 2013 Pivot Tables: Including the "Data Model": Smart Data Analysis - Couverture souple

Poleg, Maayan; Barak, Sharon

 
9781511820875: Excel 2013 Pivot Tables: Including the "Data Model": Smart Data Analysis
Couverture souple
ISBN 10 : 151182087X ISBN 13 : 9781511820875
Editeur : CreateSpace Independent Publishing Platform, 2015

Synopsis

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!

Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

À propos de l'auteur

Maayan Poleg holds an MA in Education Administration. She instructs and develops Excel's applications since 1996. Maayan has an extensive knowledge and experience in the field of VBA training You can contact Maayan at: Maayan@excel-vba.guru

Les informations fournies dans la section « A propos du livre » peuvent faire référence à une autre édition de ce titre.

Éditeur
CreateSpace Independent Publishing Platform
Date d'édition
2015
Langue
anglais
ISBN 10 
151182087X
ISBN 13 
9781511820875
Reliure
Broché
Numéro d'édition
1
Nombre de pages
180
Coordonnées du fabricant
Manufactured by Amazon on behalf of the author
https://www.amazon.fr/hz/contact-us

c/o Amazon Media EU S.à.r.l., 38 Avenue John F. Kennedy
Luxembourg
L-1855
Luxembourg