Excel 2007 PivotTables and PivotCharts (Mr. Spreadsheet's Bookshelf)

Excel 2007 PivotTables and PivotCharts (Mr. Spreadsheet's Bookshelf), 9780470104873 (0470104872), John Wiley & Sons, 2007

Microsoft Excel is a powerful and popular program for organizing and analyzing data. One of its most powerful capabilities is PivotTables, which enable you to pull meaningful information from huge masses of seemingly meaningless data. The name PivotTable comes from one of the most powerful features of Excel—the ability to quickly and easily “pivot” the data to view them in different ways.

Given all their power, PivotTables (and the related PivotCharts) are necessarily somewhat complex. You can’t get something for nothing, after all, and in order to make the most of these powerful tools you need a good understanding of what they are and how they work. That’s where this book comes in. Excel PivotTables and Charts covers the topic from A to Z, starting with the basics and moving on to the most advanced and sophisticated aspects of PivotTables. The book uses a lot of illustrations and real-world examples to make it easier for you to relate the information to your own work.

This book does not assume that the reader has any prior experience with PivotTables. It starts at square one and moves on from there. However, even those who do have previous PivotTable experience may well find the book useful for dealing with the more arcane aspects of PivotTables or with the many changes that are present in the latest version of Excel. The book is written specifically for Excel 2007.

Comments

Amazing Books

Undocumented Secrets of MATLAB-Java Programming

CRC Press, 2011

For a variety of reasons, the MATLAB^®-Java interface was never fully documented. This is really quite unfortunate: Java is one of the most widely used programming languages, having many times the number of programmers and programming resources as MATLAB. Also unfortunate is the popular claim that while MATLAB is a fine...

Scripting Your World: The Official Guide to Second Life Scripting

Sybex, 2008

Find complete information about Second Life scripting and gain access to more than 50 previously unpublished ready-to-use scripts in Scripting Your World: The Official Guide to Second Life Scripting. Learn how to script Second Life behaviors, grouped into categories like avatar movement, communications, prim and object control,...

Windows XP Unleashed

Sams Publishing, 2001

Windows XP Unleashed guides the advanced reader through nearly every Windows XP topic imaginable giving ideas and solutions practical to typical problems encountered by professionals. Examples of topics covered are:

* Installations, use, and maintenance;
* Performance tuning;
* Optimizing memory;
* Detailed registry...

Jewels of the Middle Way: The Madhyamaka Legacy of Atisa and His Early Tibetan Followers (22) (Studies in Indian and Tibetan Buddhism)

Wisdom Publications, 2019

Jewels of the Middle Way documents an important tradition of Madhyamaka and provides insight into both the late Indian Buddhist blend of Madhyamaka and tantra and the Kadampa school founded by the Indian Buddhist master Atisa.

This book presents a detailed contextualization of the Madhyamaka (Middle Way) school in...

Handbook of Plastic Optics

John Wiley & Sons, 2005

This volume is the only book to describe in detail all aspects of plastic optics from design issues to production technology and quality control aspects. Throughout, the focus is firmly set on practical applications, making this an indispensable source of information for all those working in optics research and development.

Topics...

Current Practice in Environmental Reporting: The Chemicals Industry

Woodhead Publishing, 2001

Environmental reporting is still in its infancy, having emerged only in the latter part of the 1980s. Companies are under increasing pressure to be transparent and accountable in the whole spectrum of their business. In recent years, a number of companies have seen the need to introduce environmental reporting, placing environmental...