Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets

Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets, 9780470591611 (0470591617), Visual, 2010

Master two of the most powerful features of Excel

Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide.

Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work.

Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheets
Covers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and more
Uses step-by-step tutorials and easy-to-follow screenshots, a "learn by seeing" approach for visual learners

Practical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.

Comments

Amazing Books

Transactions on Data Hiding and Multimedia Security II (Lecture Notes in Computer Science)

Springer, 2007

Since the mid 1990s, data hiding has been proposed as an enabling technology for securing multimedia communication, and is now used in various applications including broadcast monitoring, movie fingerprinting, steganography, video indexing and retrieval, and image authentication. Data hiding and cryptographic techniques are often combined to...

Encyclopedia of World Poverty, 3 Volume Set

Sage Publications, 2006

The Encyclopedia of World Poverty provides extensive and current information, as well as insight into the contemporary debate on poverty. The three volumes of this state-of-the-art Encyclopedia contain over 800 original articles written by more than 125 renowned scholars. The entries contributing to this work explore poverty in various...

Focus On Curves and Surfaces (Focus on Game Development)

Course Technology PTR, 2002

This guide provides clear, practical explanations of curves and surfaces with the minimum of esoteric mathematical notation, making it far more accessible to work along with the material for a better understanding of the concepts.

This book is aimed at anyone...

Culture of Cells for Tissue Engineering (Culture of Specialized Cells)

John Wiley & Sons, 2006

Step-by-step, practical guidance for the acquisition, manipulation, and use of cell sources for tissue engineering

Tissue engineering is a multidisciplinary field incorporating the principles of biology, chemistry, engineering, and medicine to create biological substitutes of native tissues for scientific research or clinical use. Specific...

Raspberry Pi Cookbook for Python Programmers

Packt Publishing, 2014

Over 50 easy-to-comprehend tailor-made recipes to get the most out of the Raspberry Pi and unleash its huge potential using Python

Overview

Install your first operating system, share files over the network, and run programs remotely

Unleash the hidden potential of the Raspberry Pi's...

Introducing Microsoft® Silverlight(TM) 3

Microsoft Press, 2009

As the Web grows and evolves, so do the expectations of the Web user. When the first Web browser was developed, it was created to provide a relatively simple way to allow hyperlinking between documents. Then these early browsers were coupled with the cross-machine protocols encompassing the Internet, and suddenly documents stored on...