Excel 2007 PivotTables and PivotCharts

Excel 2007 PivotTables and PivotCharts
ISBN-10
0470169710
ISBN-13
9780470169711
Category
Computers
Pages
300
Language
English
Published
2007-07-02
Publisher
John Wiley & Sons
Author
Peter G. Aitken

Description

Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you.

Other editions

Similar books

  • Excel 2007 Pivot Tables (Tech 102)
    By Tim Hill

    This handy guide teaches you how to use Excel's most powerful feature to crunch large amounts of data, without having to write new formulas, copy and paste cells, or reorganize rows and columns.

  • Excel 2007 PivotTables Recipes: A Problem-Solution Approach
    By Debra Dalgleish

    In this book, Debra Dalgleish, Microsoft Office Excel MVP since 2001 as well as an expert and trainer in Excel, brings together a one-stop resource for anyone curious about representing, analyzing, and using their data with PivotTables and ...

  • Excel 2016 Pivot Table Data Crunching
    By Michael Alexander, Bill Jelen

    Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these books will • Dramatically increase your productivity—saving you 50 hours a year or more • Present proven, ...

  • Excel Pivot Tables And Charts
    By Peter G.Aitken

    This book addresses this need by providing complete coverage of Excel PivotTables and pivot charts starting with the simplest and most basic uses and working up to complex and sophisticated scenarios.

  • EXCEL 2007 CHARTS MADE EASY
    By Kathy Jacobs, Curt Frye, Doug Frye

    Create advanced charts and graphs Present compelling graphical representations of data integrate with PowerPoint and Word Excei2007 Charts IVIae EASY Kathy Jacobs Curtis Frye Douglas Frye Excel® 2007 Charts Made EASY Kathy Jacobs Curt ...

  • Pivot Table Data Crunching: Microsoft Excel 2010
    By Michael Alexander, Bill Jelen

    Not any more! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand.

  • Excel 2007 Charts
    By John Walkenbach

    Excel, the top number-crunching tool, now offers a vastly improved charting function to help you give those numbers dimension and relativity. John Walkenbach, a.k.a.

  • The Unofficial Guide to Microsoft Office Excel 2007
    By Julia Kelly, Curt Simmons

    Find out what the manual doesn't always tell you in this insider's guide to using Excel in the real world. What are the secrets of pro users? Are there shortcuts for repetitive tasks?

  • Excel Pivot Tables Recipe Book: A Problem-Solution Approach
    By Debra Dalgleish

    Readers of this book will be able to do more, and more quickly The book goes beyond basic explanations and includes real-world troubleshooting, performance and security information not provided elsewhere

  • Excel 2007 Data Analysis For Dummies
    By Stephen L. Nelson

    Shows ordinary users how to tap the rich data analysis functionality of Excel, make sense of their organization's critical financial and statistical information, and put together compelling data presentations Now revised with over 30 ...