作者:Debra Dalgleish
出版日期:September 24, 2007
出版社:Apress
页数:295
ISBN:ISBN-10: 1590598903 ISBN-13: 978-1590598900
文件格式:PDF
Product Description
Beginning PivotTables in Excel 2007 explains what PivotTables are, how you can benefit from using them, how to create them andmodify them, and how to use their enhanced features. Using a PivotTable in Microsoft Office Excel 2007 is a quick and exciting way toslice and dice a large amount of data.
Carefully explains the benefits of using Pivot Tables for fast data analysisProvides a step-by-step approach to those new to Pivot TablesOffers tips and tricks that cannot be found elsewhereWhat you’ll learnSummarize 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.Who is this book for?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, eventplanning, or any other set of records, a Pivot Table can help youreview, analyze, monitor, and report on the data. When your reportingrequirements change, you can make minor adjustments to the Pivot Table,instead of starting a worksheet summary from scratch.
About the Apress Beginning SeriesThe Beginning series from Apress is the right choice to get theinformation you need to land that crucial entry-level job. These bookswill teach you a standard and important technology from the ground upbecause they are explicitly designed to take you from �novice toprofessional.� Youll start your journey by seeing what you need toknowbut without needless theory and filler. Youll build your skill setby learning how to put together real-world projects step by step. Sowhether your goal is your next career challenge or a new learningopportunity, the Beginning series from Apress will take you thereit isyour trusted guide through unfamiliar territory!
Related Titles from ApressExcel PivotTables Recipe Book: A Problem-Solution ApproachBeginning Excel What-If Data Analysis Tools: Getting Started with Goal Seek, Data Tables, Scenarios, and SolverBeginning SharePoint with Excel: From Novice to ProfessionalExcel 2007: Beyond the ManualExcel as Your DatabaseDefinitive Guide to Excel VBA, Second EditionAbout 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.