Beginning Pivot Tables in Excel 2007
Book Review

By Dale Farris, Reviews Coordinator Golden Triangle PC Club October 2007 General Overview Beginning Pivot Tables in Excel 2007 explains what Pivot Tables are, how you can benefit from using them, how to create them and modify them, and how to use their enhanced features. Using a Pivot Table in Microsoft Office Excel 2007 is a quick and exciting way to slice and dice a large amount of data. Carefully explains the benefits of using Pivot Tables for fast data analysis Provides a step-by-step approach to those new to Pivot Tables Offers tips and tricks that cannot be found elsewhere What You Will Learn Summarize thousands of records in a Pivot Table with a few clicks of the mouse Quickly change the Pivot Table layout to view a different summary of the data Filter a Pivot Table to focus on one region or the top 10 products Add colors or icons to highlight the high or low results Use calculations to enhance the Pivot Table summaries Create visual impact with a pivot chart About the Apress Beginning Series The Beginning series from Apress is the right choice to get the information you need to land that crucial entry-level job. These books will teach you a standard and important technology from the ground up because they are explicitly designed to take you from “novice to professional.” You will start your journey by seeing what you need to know, but without needless theory and filler. You will build your skill set by learning how to put together real-world projects step by step. So whether your goal is your next career challenge or a new learning opportunity, the Beginning series from Apress will take you there. Table of Contents The twelve (12) chapters include: 1)    Introducing Pivot Tables 2)    Creating a Pivot Table 3)    Modifying a Pivot Table 4)    Summarizing Data 5)    Formatting a Pivot Table 6)    Sorting and Filtering in a Pivot Table 7)    Creating a Pivot Table From External Data 8)    Updating a Pivot Table 9)    Creating Calculations in a Pivot Table 10)  Enhancing Pivot Table Formatting 11)  Creating a Pivot Chart 12)  Printing and Extracting Data From a Pivot Table The Appendix explains key skills in downloading the Excel files, saving files, etc. Target Readers This book is for Excel users who want to learn about Pivot Tables. If you work with financial data, logistics records, sales orders, customer service reports, web site statistics, resource tracking, event planning, or any other set of records, a Pivot Table can help you review, analyze, monitor, and report on the data. When your reporting requirements change, you can make minor adjustments to the Pivot Table, instead of starting a worksheet summary from scratch. Book Contents 295 pages; about the author; acknowledgments; introduction; figures; tips; tables; screenshots; detailed index Note also that the book provides you with the information you need to access from the www.apress.com site all the sample files explained in the book. This means you can easily follow along with the author's explanation on your own machine and complete all the steps he fully describes in the book. Author Debra Dalgleish About the Author Debra Dalgleish is a computer consultant in Mississauga, Ontario, Canada, serving local and international clients. Self-employed since 1985, she has extensive experience in designing complex Excel and Access applications, as well as sophisticated Word forms and documents. She has led hundreds of Microsoft Office corporate training sessions, from beginner to advanced level. In recognition of her contributions to the Excel newsgroups, she has received the Microsoft Office Excel MVP award each year since 2001. You can find a wide variety of Excel tips and tutorials, and sample files, on her Contextures website: www.contextures.com/tiptech.html. ISBN September 2007 - First Edition ISBN10: 1-59059-890-3 ISBN13: 978-1-59059-890-0 List Price $34.99 $17.50 - eBook Price About Apress Apress is a publishing company devoted to meeting the needs of programming professionals. Apress' unique approach to computer book publishing grew out of conversations between Dan Appleman and Gary Cornell, Apress' founders, who believe that too many programming books are of such low quality that they are a complete waste of time. Computer professionals need quality books that are not just rehashes of documentation. The "A" in Apress stands for The Author's Press, and their books have "The Expert's Voice." Apress acquires manuscripts of the highest quality by attracting the best authors and technical experts that the world has to offer. Apress makes authors partners in the publishing process, doesn't impose a "house style" on authors, and doesn't make them conform to a series that straightjacket's them. Apress also makes sure that authors are treated equitably. Another key feature of the Apress approach to publishing books is taken from the software industry. Apress treats the technical review process as seriously as the best software companies treat the quality assurance process. Apress is convinced that the innovations listed above make it possible for them to produce the highest quality books, recruit the highest quality authors, and publish titles that information technology professionals need and want. The Apress management team ensures that the distribution and fulfillment of Apress titles is second to none, and that the capital is available to move aggressively and take advantage of any publishing opportunities that arise. To accomplish this, Apress has entered into a partnership with Springer-Verlag, one of the world's most respected publishing houses. Springer-Verlag is convinced that Apress will be the publisher of quality trade computer paperbacks in the years to come. Apress will continue to publish titles of the highest quality, and has compiled a team of authors that reads like a veritable "Who's Who" list of the computing industry. The company founders have published over 200 software titles by leading software professionals, all of whom have "The Expert's Voice." Publisher Contact Cheryl Martinez Marketing Coordinator Apress 2855 Telegraph Avenue, Suite 600 Berkeley, California 94705 510-549-5930 ext. 129 FAX 510-549-5939 cheryl@apress.com www.apress.com