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

3,86 valoración promedio
( 14 valoraciones por Goodreads )
 
9780470591611: Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets

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.

"Sinopsis" puede pertenecer a otra edición de este libro.

From the Back Cover:

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 135 key techniques with Excel PivotTables and PivotCharts, including:

  • Creating a table for a PivotTable report

  • Converting a PivotTable to regular data

  • Changing the Report Filter layout

  • Formatting PivotTable cells

  • Displaying a data table with a PivotChart

  • Performing PivotTable calculations

  • Building formulas for PivotTables

  • Filtering records with Query criteria

  • Creating an OLAP cube data source

  • Learning VBA basics for PivotTables

  • High-resolution screen shots demonstrate each task

  • Succinct explanations walk you through step by step

  • Two-page lessons break big topics into bite-sized modules

  • "Apply It" and "Extra" sidebars highlight useful tips

About the Author:

Paul McFedries is a full-time technical writer. Paul has been authoring computer books since 1991 and he has more than 70 books to his credit. Paul’s books have sold more than three million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Excel 2010; Excel 2010 Visual Quick Tips; Teach Yourself VISUALLY Windows 7; and Teach Yourself VISUALLY Office 2008 for Mac. Paul is also the proprietor of Word Spy (www.wordspy.com and twitter.com/wordspy), a Web site that tracks new words and phrases as they enter the language. Paul invites you to drop by his personal Web site at www.mcfedries.com or to follow him on Twitter at twitter.com/paulmcf.

"Sobre este título" puede pertenecer a otra edición de este libro.

Los mejores resultados en AbeBooks

1.

Paul McFedries (Web Developer)
Editorial: John Wiley and Sons
ISBN 10: 0470591617 ISBN 13: 9780470591611
Nuevos Cantidad: > 20
Librería
INDOO
(Avenel, NJ, Estados Unidos de America)
Valoración
[?]

Descripción John Wiley and Sons. Estado de conservación: New. Brand New. Nº de ref. de la librería 0470591617

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 14,72
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 2,98
A Estados Unidos de America
Destinos, gastos y plazos de envío

2.

Paul McFedries
Editorial: John Wiley and Sons Ltd, United Kingdom (2010)
ISBN 10: 0470591617 ISBN 13: 9780470591611
Nuevos Cantidad: 10
Librería
The Book Depository US
(London, Reino Unido)
Valoración
[?]

Descripción John Wiley and Sons Ltd, United Kingdom, 2010. Online resource. Estado de conservación: New. 2nd Revised edition. Language: English . Brand New Book. 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. Nº de ref. de la librería AAH9780470591611

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 18,41
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

3.

McFedries, Paul
Editorial: Visual (2010)
ISBN 10: 0470591617 ISBN 13: 9780470591611
Nuevos Paperback Cantidad: 1
Librería
pickabook
(San francisco, CA, Estados Unidos de America)
Valoración
[?]

Descripción Visual, 2010. Paperback. Estado de conservación: New. Nº de ref. de la librería mon0000168867

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 15,25
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,40
A Estados Unidos de America
Destinos, gastos y plazos de envío

4.

McFedries
ISBN 10: 0470591617 ISBN 13: 9780470591611
Nuevos Cantidad: 2
Librería
Pbshop
(Wood Dale, IL, Estados Unidos de America)
Valoración
[?]

Descripción 2010. PAP. Estado de conservación: New. New Book.Shipped from US within 10 to 14 business days. Established seller since 2000. Nº de ref. de la librería IB-9780470591611

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 16,98
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,40
A Estados Unidos de America
Destinos, gastos y plazos de envío

5.

McFedries
Editorial: Visual
ISBN 10: 0470591617 ISBN 13: 9780470591611
Nuevos PAPERBACK Cantidad: > 20
Librería
Mediaoutlet12345
(Springfield, VA, Estados Unidos de America)
Valoración
[?]

Descripción Visual. PAPERBACK. Estado de conservación: New. 0470591617 *BRAND NEW* Ships Same Day or Next!. Nº de ref. de la librería NATARAJB1FI933749

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 17,16
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 3,40
A Estados Unidos de America
Destinos, gastos y plazos de envío

6.

Paul McFedries
Editorial: John Wiley & Sons
ISBN 10: 0470591617 ISBN 13: 9780470591611
Nuevos Paperback Cantidad: 14
Librería
THE SAINT BOOKSTORE
(Southport, Reino Unido)
Valoración
[?]

Descripción John Wiley & Sons. Paperback. Estado de conservación: New. New copy - Usually dispatched within 2 working days. Nº de ref. de la librería B9780470591611

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 13,46
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 7,87
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

7.

McFedries, Paul
Editorial: John Wiley and Sons Ltd (2010)
ISBN 10: 0470591617 ISBN 13: 9780470591611
Nuevos Tapa blanda Cantidad: 1
Librería
Valoración
[?]

Descripción John Wiley and Sons Ltd, 2010. Estado de conservación: New. 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. Series: Visual Blueprint. Num Pages: 304 pages, ill. BIC Classification: UFCE. Category: (P) Professional & Vocational. Dimension: 231 x 187 x 17. Weight in Grams: 610. . 2010. 2nd Edition. Paperback. . . . . . Nº de ref. de la librería V9780470591611

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 21,68
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Irlanda a Estados Unidos de America
Destinos, gastos y plazos de envío

8.

Paul McFedries
Editorial: John Wiley and Sons Ltd, United Kingdom (2010)
ISBN 10: 0470591617 ISBN 13: 9780470591611
Nuevos Cantidad: 10
Librería
The Book Depository
(London, Reino Unido)
Valoración
[?]

Descripción John Wiley and Sons Ltd, United Kingdom, 2010. Online resource. Estado de conservación: New. 2nd Revised edition. Language: English . Brand New Book. 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. Nº de ref. de la librería AAH9780470591611

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 21,94
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

9.

McFedries, Paul
Editorial: John Wiley and Sons Ltd
ISBN 10: 0470591617 ISBN 13: 9780470591611
Nuevos Tapa blanda Cantidad: 1
Librería
Kennys Bookstore
(Olney, MD, Estados Unidos de America)
Valoración
[?]

Descripción John Wiley and Sons Ltd. Estado de conservación: New. 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. Series: Visual Blueprint. Num Pages: 304 pages, ill. BIC Classification: UFCE. Category: (P) Professional & Vocational. Dimension: 231 x 187 x 17. Weight in Grams: 610. . 2010. 2nd Edition. Paperback. . . . . Books ship from the US and Ireland. Nº de ref. de la librería V9780470591611

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 22,66
Convertir moneda

Añadir al carrito

Gastos de envío: GRATIS
A Estados Unidos de America
Destinos, gastos y plazos de envío

10.

McFedries, Paul
Editorial: John Wiley and#38; Sons (2010)
ISBN 10: 0470591617 ISBN 13: 9780470591611
Nuevos Cantidad: 14
Librería
Books2Anywhere
(Fairford, GLOS, Reino Unido)
Valoración
[?]

Descripción John Wiley and#38; Sons, 2010. PAP. Estado de conservación: New. New Book. Shipped from UK in 4 to 14 days. Established seller since 2000. Nº de ref. de la librería FW-9780470591611

Más información sobre esta librería | Hacer una pregunta a la librería

Comprar nuevo
EUR 13,10
Convertir moneda

Añadir al carrito

Gastos de envío: EUR 10,21
De Reino Unido a Estados Unidos de America
Destinos, gastos y plazos de envío

Existen otras copia(s) de este libro

Ver todos los resultados de su búsqueda