This book consolidates all the best functionality of pivot tables into one guide that provides you with a meaningful tutorial, offering practical solutions to day-to-day problems. Within just the first 2 chapters, you will be creating basic pivot tables, increasing productivity, and producing reports in minutes instead of hours. Within the first 6 chapters, you will learn how to use pivot tables to quickly highlight your top 10 customers or bottom 5 products in profitability; quickly create analysis comparing sales this period to last period by product or region or both; easily summarize daily transactional data by month or quarter. | business utions Develop your Excel expertise instantly with proven techniques PivotTable J Data Crunching for Microsoft Office Excel 2007 Bil Mr. Excel Jelen and Michael Alexander . 1 2 3 4 5 6 7 8 9 10 11 12 A ntents at a Glance Pivot Table Data Crunching for Office Excel HHi Introduction .1 Pivot Table Creating a Basic Pivot Customizing a Pivot Controlling the Way You View Your Pivot Performing Calculations Within Your Pivot Using Pivot Charts and Other Analyzing Disparate Data Sources with Pivot Tables .167 Sharing Pivot Tables with Working with and Analyzing OLAP Enhancing Your Pivot Table Reports with Macros .215 Using VBA to Create Pivot Common Pivot Table Issues and Finding Pivot Table Commands on the Ribbon .315 Bill Jelen Michael Alexander CJUE 800 E. 96th Street Indianapolis Indiana 46240 Pivot Table Data Crunching for Microsoft Office Excel 2007 Copyright 2007 by Pearson Education Inc. All rights reserved. No part of this book shall be reproduced stored in a retrieval system or transmitted by any means electronic mechanical photocopying recording or otherwise without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein. International Standard Book Number 0-7897-3601-2 Library of Congress Cataloging-in-Publication data is on file. Printed in the United States of America First Printing December 2006 09 08 07 06 4 3 2 1 Trademarks All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Que Publishing cannot attest to the accuracy of this information. Use of a .
