Excel 2013 Pivot Tables: Including the "Data Model" (full color): Smart Data Analysis (In Everyday Language, Band 2) - Softcover

Poleg, Maayan; Barak, Sharon

 
9781511954877: Excel 2013 Pivot Tables: Including the "Data Model" (full color): Smart Data Analysis (In Everyday Language, Band 2)
Softcover
ISBN 10: 1511954876 ISBN 13: 9781511954877
Verlag: CreateSpace Independent Publishing Platform, 2015

Inhaltsangabe

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 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 tablePerform 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 itemChange The Report Structure o Switching columns and rows o Adding columns or rows o Adding a page break between itemsFormat your Pivot Tables o Add totals and Subtotals o Sort o Filter You 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!

Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.

Verlag
CreateSpace Independent Publishing Platform
Erscheinungsdatum
2015
Sprache
Englisch
ISBN 10 
1511954876
ISBN 13 
9781511954877
Einband
Taschenbuch
Auflage
1
Anzahl der Seiten
180
Kontakt zum Hersteller
Manufactured by Amazon on behalf of the author
https://www.amazon.de/hz/contact-us

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

Weitere beliebte Ausgaben desselben Titels

9781511820875: Excel 2013 Pivot Tables: Including the "Data Model": Smart Data Analysis (In Everyday Language, Band 2)

Vorgestellte Ausgabe

ISBN 10:  151182087X ISBN 13:  9781511820875
Verlag: CreateSpace Independent Publishi..., 2015
Softcover