Pivot Table Data Crunching et plus d'un million d'autres livres sont disponibles pour le Kindle d'Amazon. En savoir plus
Actuellement indisponible.
Nous ne savons pas quand cet article sera de nouveau approvisionné ni s'il le sera.
Vous l'avez déjà ?
Repliez vers l'arrière Repliez vers l'avant
Ecoutez Lecture en cours... Interrompu   Vous écoutez un extrait de l'édition audio Audible
En savoir plus
Voir cette image

[Pivot Table Data Crunching] [by: Michael Alexander] (Anglais) Broché – 1 août 2005

Voir les 4 formats et éditions Masquer les autres formats et éditions
Prix Amazon Neuf à partir de Occasion à partir de
Format Kindle
"Veuillez réessayer"
"Veuillez réessayer"

Devenez auteur avec Kindle Direct Publishing Devenez auteur avec Kindle Direct Publishing

Actuellement indisponible. Nous ne savons pas quand cet article sera de nouveau approvisionné ni s'il le sera.

Offres spéciales et liens associés

Descriptions du produit

Become a savvy Microsoft Excel user. Pivot tables are a great feature in Excel that help you organize and analyze data, but not many Excel users know how to use pivot tables. Pivot Table Data Crunching offers a comprehensive review of all the functionalities of Pivot Tables from author Bill Jelen, otherwise known as Mr. Excel from , and Michael Alexander, a Microsoft Certified Application Developer. The authors' practical scenarios and real-world advice demonstrate the benefits of Pivot Tables and how to avoid the common pitfalls of every day data crunching. Each solution presented in the book can be accomplished with resources available in the Excel interface, making Pivot Table Data Crunching a beneficial resource for all levels of Excel users.

Détails sur le produit

En savoir plus sur les auteurs

Découvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.

Dans ce livre (En savoir plus)
Parcourir et rechercher une autre édition de ce livre.
Première phrase
Imagine that Excel is a large toolbox that contains different tools at your disposal. Lire la première page
En découvrir plus
Parcourir les pages échantillon
Couverture | Copyright | Table des matières | Extrait | Index | Quatrième de couverture
Rechercher dans ce livre:

Commentaires en ligne

Il n'y a pas encore de commentaires clients sur Amazon.fr
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoiles

Commentaires client les plus utiles sur Amazon.com (beta)

Amazon.com: 34 commentaires
42 internautes sur 43 ont trouvé ce commentaire utile 
An excellent book for both all the newbie and expert alike. 28 décembre 2005
Par Darryl Collins - Publié sur Amazon.com
Format: Broché Achat vérifié
On the Excel Developer Mailing list that I subscribe to there are many talented and generous people whom freely share their Excel knowledge and experience with others less skilled. Numerous of them are MVP's.

Now when folks like Bob Umlas and Jon Peltier (whom are MVP Excel experts in their own rights) say a book is worth looking at, well, I definitely am keen to check it out.

Bill "Mr. Excel" Jelen and Michael Alexander's book on getting the best out of Pivot tables was recommended to me by Jon Peltier ([...] ) and what a great piece of advice it turned out to be.

Pivot table are one of Excel's most powerful features, and yet many users never harness the potential and power of this wonderful tool. I use pivot tables a lot and thought I had a good understanding of them, but this book has taken my productivity to a whole new level. Reading this book and understanding the concepts within has definitely been a "wow" experience for me.

The style of writing is excellent and extensive screenshots and notes make it easy to follow the necessary processes to quickly and painless achieve the desired outcome.

This book covers everything from the history of the Pivot table and data basics, right through to complex tasks involving calculated pivot fields, pivot charts and extracting data from external data sources such as an SQL database or OLAP cube.

Importantly the authors also explain in great detail the potential for risk and data errors and how to minimise the chances of errors being generated. A worthwhile process for anyone using excel.

Actually I loved the way the book was interesting and useful for all skill levels. Even if you had never created a pivot table before this book is very accessable and easy to follow. And for people like myself who are advanced Excel users, there is still an amazing amount of clever techniques to maximise the power of pivot tables.

As a professional excel developer this book has definitely added value to work and (more importantly) to the end products I produce for my clients. A "wow! That is great!" client is a happy client.
42 internautes sur 44 ont trouvé ce commentaire utile 
Not really for advanced users 4 mars 2006
Par BlazerHorn - Publié sur Amazon.com
Format: Broché Achat vérifié
I was encouraged by other reviewer's comments that this book was useful to beginners AND experts, but I disagree. I consider myself a fairly advanced user/macro developer, and was hoping this book would help me take my Pivot Table skills to another level. The book is laid out well - and DOES cover its topics thoroughly - but it is really more of a book for intermediate excel users who may have little to no experience with Pivots.
48 internautes sur 51 ont trouvé ce commentaire utile 
So you think you know Pivot Tables? Learn from the Master! 30 novembre 2005
Par Bob Umlas - Publié sur Amazon.com
Format: Broché
I am an Excel MVP and pretty much know Excel inside out, yet I learned so many cool things from this wonderful book! I was often confused knowing the difference between calculated fields and calculated items, but this book really cleared that up for me. I can't think of any piece of using pivot tables which was either left out or glossed over. The book will make you a pivot table master! Highly recommended, whether you're a beginner or an Excel guru!
16 internautes sur 16 ont trouvé ce commentaire utile 
Why and when to make a pivot table 26 octobre 2005
Par W Boudville - Publié sur Amazon.com
Format: Broché
The most cogent reasons for using this book are given in its first chapter. Namely why use a pivot table? And when to recognise when you might want to do so. While it is hard to strictly demarcate these questions, they are useful in focusing on the key issues.

For why to use, it is to reduce the chance of manual error, by letting you be able to automate several or even many steps. This also permits greater productivity. From having less occasion to redo erroneous steps, and from doing faster analysis. For when, it might be due to having a large data set, or to having to find certain relationships within this.

Given the above, the rest of the book proceeds to show how to make a pivot table. There is a clear description of the anatomy of the table, which helps greatly when going through the book.
20 internautes sur 21 ont trouvé ce commentaire utile 
Pivot Tables a-Go-Go 13 mars 2006
Par MacroWriter - Publié sur Amazon.com
Format: Broché Achat vérifié
Do you use Pivot Tables in your work? Do you need to quantify the data returned by the Pivot Table?

This is the best reference I have found on Pivot Tables. Though I have been using Excel for over 10 years (since version 2.0), I found useful examples my first day.

I found out that I could do complex mathematical functions directly against the pivot data without building a second table or writing crazy macros.
Ces commentaires ont-ils été utiles ? Dites-le-nous

Rechercher des articles similaires par rubrique


Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?