Titolo: Excel 2013 Pivot Tables: Including the "Data Model": Smart Data Analysis (In Everyday Language)
Editore: CreateSpace Independent Publishing Platform
Data di pubblicazione: 2015
Lingua: Inglese
ISBN 10: 151182087X
ISBN 13: 9781511820875
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!

Informazioni sull?autore

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

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Descrizione libreria

50+ Million Books in stock & ready to ship! Excellent Prices, Service & Selection.

Visita la pagina della libreria

Informazioni sull?azienda del venditore

Condizioni di vendita e spedizione

Condizioni di vendita

When you see an item on our listing, it means we have it available in one of our warehouses right here right now, ready for same day or next day processing of your order. Over 50+ Million books in stock & ready to ship same day. Customer Service is a top priority for us, we want every customer to be 100% satisfied. We offer the world's largest selection of books, music and video. Maintaining an accurate inventory of more than 50+ Million items, we are able to ship your order the same day it is r...

Ulteriori informazioni

Diritto di recesso

Condizioni di spedizione

SUPER FAST SHIPPING!

Tariffe di spedizione nazionale per U.S.A.

Tariffe di spedizione nazionale per U.S.A.
Quantit� dell?ordine	Da 1 a 3 giorni lavorativi	Da 1 a 3 giorni lavorativi
Primo articolo	EUR 7.72	EUR 17.18

I tempi di consegna sono stabiliti dai venditori e variano in base al corriere e al paese. Gli ordini che devono attraversare una dogana possono subire ritardi e spetta agli acquirenti pagare eventuali tariffe o dazi associati. I venditori possono contattarti in merito ad addebiti aggiuntivi dovuti a eventuali maggiorazioni dei costi di spedizione dei tuoi articoli.