Pivot Table Data Crunching for Microsoft Office Excel 2007

Name: Pivot Table Data Crunching for Microsoft Office Excel 2007
Availability: InStock
ISBN: 9780789736017

ISBN-10: 0789736012

ISBN-13: 9780789736017

Edition: 2007

Authors: Bill Jelen, Michael Alexander

List price: $34.99

30 day, 100% satisfaction guarantee!

Semester Rental: $19.09 Due date: 8/14/2024

Rental notice: supplementary materials (access codes, CDs, etc.) are not guaranteed with rental orders.

Buy used: $8.04

Marketplace

2 new & used from $2.82

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

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 or year in a few mouse clicks-all without knowing any…

Book details

List price: $34.99
Copyright year: 2007
Publisher: Pearson Education
Publication date: 12/26/2006
Binding: Paperback
Pages: 360
Size: 7.25" wide x 9.00" long x 0.75" tall
Weight: 1.232
Language: English

MICHAEL ALEXANDER is the pseudonym of a nurse who has previously worked in the UK and New Zealand.




Pivot table fundamentals



Creating a basic pivot table



Customizing a pivot table



Controlling the way you view your pivot data



Performing calculations within your pivot tables



Using pivot charts and other visualizations



Analyzing disparate data sources with pivot tables



Sharing pivot tables with others



Working with and analyzing OLAP data



Enhancing your pivot table reports with macros



Using VBA to create pivot tables



Common pivot table issues and questions



Finding pivot table commands on the Ribbon