A Complete Guide to PivotTables

A Visual Approach - Learn how to use PivotTables to analyze your data and make better decisions.

Paul Cornell - Collection The Expert's Voice

339 pages, parution le 13/12/2004

Ajouter à une liste

Indisponible

Résumé

The more I chat with Microsoft Office Excel users, the more I discover that most folks don't know how powerful PivotTables are. This book shares my PivotTable skills with you to help you become a more productive Excel user. By the end of this book you'll be a PivotTable expert, quickly making better decisions based on the mountains of data that you encounter every day.

PivotTables help you combine and compare large amounts of data. You can easily rotate a PivotTable's rows and columns to analyze your data from different perspectives, and you can then drill into the specific data points for areas of interest. Specifically, you'll learn how to

Create PivotTables and manipulate PivotTables connected to data in Microsoft Office Excel workbooks
Use real-world techniques to analyze data using PivotTables
Analyze data in a more visual manner using PivotCharts
Programmatically automate creating and manipulating PivotTables and PivotCharts using Visual Basic for Applications code

Along the way, I'll provide you with a series of step-by-step tutorials, along with plenty of sample data, to help you become productive with PivotTables quickly and easily. In just a short time, you'll be analyzing data using PivotTables like a pro. I hope that you value this book as a great training resource and refer to it often as an indispensable guide to working with PivotTables.

L'auteur - Paul Cornell

Paul Cornell has been with Microsoft for five years, serving as an inside sales representative, a sales trainer, and a documentation specialist. For the last two-and-a-half years he has been working as a writer and an editor in Office User Assistance. He also currently works for the MSDN Online Office Developer Center and the Microsoft Office Business Intelligence initiative. His projects have included work on the Microsoft Office XP Visual Basic® for Applications Language Reference, the Microsoft Office XP Web Services Toolkit, the Microsoft Office XP Fabrikam 2.0 Solution Sample, and the Microsoft Data Analyzer Tutorial. He writes the "Office Talk" column for MSDN at http://msdn.microsoft.com/columns/office.asp and contributes to the "Office Power User Corner" column for the Microsoft Office Assistance Center at http://office.microsoft.com/assistance.

Autres livres de Paul Cornell

La mort de wolverine: prélude

Deadshot & les secret six - Tome 4

Découvrir tous les livres de Paul Cornell

Sommaire

About the Author
About the Technical Reviewer
Preface.
Acknowledgments
Introduction: PivotTables Are Powerful!
What Are PivotTables?
Creating PivotTables
Working with PivotTable Components Using PivotTables in the Real World
Working with PivotCharts
Analyzing Multidimensional Data with PivotTables
Programming PivotTables
PivotTable Differences Between Excel 2000, 2002, and 2003
Index

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Apress
Auteur(s)	Paul Cornell
Collection	The Expert's Voice
Parution	13/12/2004
Nb. de pages	339
Format	17,5 x 23,5
Couverture	Broché
Poids	700g
Intérieur	Noir et Blanc
EAN13	9781590594322
ISBN13	978-1-59059-432-2