 |
Beginning Pivot Tables in Excel 2007 View Larger Image | Debra Dalgleish
Apress, Paperback, Published September 2007, 320 pages, ISBN 1590598903 | List Price: $34.99
Our Price: $21.50
You Save: $13.49 (39% Off)
| | | Availability: In-Stock |
Read an excerpt:
Chapter 1: Introducing Pivot Tables
Excerpt provided courtesy of Apress. Copyright © Apress, Inc. Written permission from the publisher is required for any use of this material.
|
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
Beginning PivotTables in Excel 2007 explains what PivotTables are, how
you can benefit from using them, how to create them and modify them, and how
to use their enhanced features. Using a PivotTable 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 PivotTables for fast data analysis
- Provides a step-by-step approach to those new to PivotTables
- Offers tips and tricks that cannot be found elsewhere
What you'll learn
- Summarize thousands of records in a PivotTable with a few clicks of the
mouse.
- Quickly change the PivotTable layout to view a different summary of the
data.
- Filter a PivotTable 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 PivotTable summaries.
- Create visual impact with a pivot chart.
Who is this book for?
This book is for Excel users who want to learn about PivotTables. 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 PivotTable can help you review, analyze, monitor, and report on the
data. When your reporting requirements change, you can make minor adjustments
to the PivotTable, instead of starting a worksheet summary from scratch.
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'll start
your journey by seeing what you need to know—but without needless theory
and filler. You'll 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—it
is your trusted guide through unfamiliar territory!
Table of Contents
About the Author
About the Technical Reviewer
Acknowledgments
Introduction
Chapter 1 Introducing Pivot Tables
Chapter 2 Creating a Pivot Table
Chapter 3 Modifying a Pivot Table
Chapter 4 Summarizing Data
Chapter 5 Formatting a Pivot Table
Chapter 6 Sorting and Filtering in a Pivot Table
Chapter 7 Creating a Pivot Table from External Data
Chapter 8 Updating a Pivot Table
Chapter 9 Creating Calculations in a Pivot Table
Chapter 10 Enhancing Pivot Table Formatting
Chapter 11 Creating a Pivot Chart
Chapter 12 Printing and Extracting Data from a Pivot Table
Appendix Key Skills
Index
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.
|
|
