Excel 2013 Pivot Tables: Including the "Data Model" (full color): Smart Data Analysis: Volume 2 (In Everyday Language) - Tapa blanda

Poleg, Maayan; Barak, Sharon

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

Sinopsis

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!

"Sinopsis" puede pertenecer a otra edición de este libro.

Reseña del editor

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 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 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!

"Sobre este título" puede pertenecer a otra edición de este libro.

Editorial
CreateSpace Independent Publishing Platform
Año de publicación
2015
Idioma
Inglés
ISBN 10 
1511954876
ISBN 13 
9781511954877
Encuadernación
Tapa blanda
Número de edición
1
Número de páginas
180
Contacto del fabricante
Manufactured by Amazon on behalf of the author
https://www.amazon.es/hz/contact-us

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

Otras ediciones populares con el mismo título

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

Edición Destacada

ISBN 10:  151182087X ISBN 13:  9781511820875
Editorial: CreateSpace Independent Publishi..., 2015
Tapa blanda