Picture 1 of 1

Have one to sell?

Sell it yourself

Pivot Table Data Crunching for Microsoft Office Excel 2007 by Jelen, Bill, Alex

Condition:

Good

Price:

US $3.79

ApproximatelyS$ 5.17

Postage:

Free Economy Postage. See detailsfor shipping

Located in: Boston, Massachusetts, United States

Delivery:

Estimated between Mon, 6 May and Fri, 10 May to 43230

Returns:

30 days return. Seller pays for return shipping. See details- for more information about returns

Coverage:

Read item description or contact seller for details. See all detailsSee all details on coverage

(Not eligible for eBay purchase protection programmes)

Seller information

mtwyouth (316653)
99% positive feedback

Registered as a Business Seller

Report this item - opens in new window or tab

Seller assumes all responsibility for this listing.

eBay item number:296152270068

Last updated on Apr 26, 2024 01:42:11 SGTView all revisionsView all revisions

All net proceeds will support More Than Words Inc.

More Than Words is a nonprofit social enterprise that empowers youth who are in the foster care system, court involved, homeless, or out of school to take charge of their lives by taking charge of a ...

Official eBay for Charity listing. Learn more
This sale benefits a verified non-profit partner.

Item specifics

Condition: Good: A book that has been read but is in good condition. Very minimal damage to the cover including ... Good: A book that has been read but is in good condition. Very minimal damage to the cover including scuff marks, but no holes or tears. The dust jacket for hard covers may not be included. Binding has minimal wear. The majority of pages are undamaged with minimal creasing or tearing, minimal pencil underlining of text, no highlighting of text, no writing in margins. No missing pages. See all condition definitionsopens in a new window or tab

Book Title: Pivot Table Data Crunching for Microsoft Office Excel 2007

Genre: Computers & Technology

Subject: New, Used & Rental Textbooks

ISBN: 9780789736017

Publication Year: 2006

Type: Textbook

Format: Perfect

Language: English

Publication Name: Pivot Table Data Crunching for Microsoft Office Excel 2007

Item Height: 0.7in

Author: Michael Alexander, Bill Jelen

Item Length: 9.1in

Publisher: Pearson Education

Item Width: 7.1in

Item Weight: 19.6 Oz

Number of Pages: 360 Pages

About this product

Product Information

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 formulas By the end of the book, you will truly be a pivot table guru, automating pivot tables using VBA, creating pivot tables with external data in OLAP cubes, and even creating dynamic reporting systems so that your managers can answer their own queries with a few mouse clicks. Take advantage of the numerous pivot table recipes Create powerful summary reports in seconds Build ad-hoc query tools with ease Enhance your Executive Reporting Filter reports to top 10 customers or products Add dynamic charts to reports Quickly summarize daily data by month, quarter, or year Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 Pivot Table Fundamentals . . . . . . . . . . . . . . . . . . . . . . . . . . . .11 2 Creating a Basic Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . .21 3 Customizing a Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . . . .45 4 Controlling the Way You View Your Pivot Data . . . . . . . . . . . .83 5 Performing Calculations Within Your Pivot Tables . . . . . . . . 117 6 Using Pivot Charts and Other Visualizations . . . . . . . . . . . . .141 7 Analyzing Disparate Data Sources with Pivot Tables . . . . . . 167 8 Sharing Pivot Tables with Others . . . . . . . . . . . . . . . . . . . . . .189 9 Working with and Analyzing OLAP Data . . . . . . . . . . . . . . . . 201 10 Enhancing Your Pivot Table Reports with Macros . . . . . . . . .215 11 Using VBA to Create Pivot Tables . . . . . . . . . . . . . . . . . . . . . 231 12 Common Pivot Table Issues and Questions . . . . . . . . . . . . . .291 A Finding Pivot Table Commands on the Ribbon . . . . . . . . . . . .315"

Product Identifiers

Publisher

Pearson Education

ISBN-10

0789736012

ISBN-13

9780789736017

eBay Product ID (ePID)

57193450

Product Key Features

Author

Michael Alexander, Bill Jelen

Publication Name

Pivot Table Data Crunching for Microsoft Office Excel 2007

Format

Perfect

Language

English

Publication Year

2006

Type

Textbook

Number of Pages

360 Pages

Dimensions

Item Length

9.1in

Item Height

0.7in

Item Width

7.1in

Item Weight

19.6 Oz

Additional Product Features

Lc Classification Number

Hf5548.4.M523j454

Table of Content

Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 1 Pivot Table Fundamentals . . . . . . . . . . . . . . . . . . . . . . . . . . . .11 2 Creating a Basic Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . .21 3 Customizing a Pivot Table . . . . . . . . . . . . . . . . . . . . . . . . . . . .45 4 Controlling the Way You View Your Pivot Data . . . . . . . . . . . .83 5 Performing Calculations Within Your Pivot Tables . . . . . . . . 117 6 Using Pivot Charts and Other Visualizations . . . . . . . . . . . . .141 7 Analyzing Disparate Data Sources with Pivot Tables . . . . . . 167 8 Sharing Pivot Tables with Others . . . . . . . . . . . . . . . . . . . . . .189 9 Working with and Analyzing OLAP Data . . . . . . . . . . . . . . . . 201 10 Enhancing Your Pivot Table Reports with Macros . . . . . . . . .215 11 Using VBA to Create Pivot Tables . . . . . . . . . . . . . . . . . . . . . 231 12 Common Pivot Table Issues and Questions . . . . . . . . . . . . . .291 A Finding Pivot Table Commands on the Ribbon . . . . . . . . . . . .315

2007

Target Audience

Trade

Topic

Desktop Applications / Spreadsheets, Enterprise Applications / General

Lccn

2006-038440

Dewey Decimal

005.54

Dewey Edition

Illustrated

Yes

Genre

Computers

Item description from the seller

Seller assumes all responsibility for this listing.

eBay item number:296152270068

Last updated on Apr 26, 2024 01:42:11 SGTView all revisionsView all revisions

Postage and handling

Item location:

Boston, Massachusetts, United States

Post to:

Afghanistan, Albania, Algeria, Andorra, Angola, Anguilla, Antigua and Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan Republic, Bahamas, Bahrain, Bangladesh, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bosnia and Herzegovina, Botswana, Brazil, Brunei Darussalam, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde Islands, Cayman Islands, Central African Republic, Chad, Chile, China, Colombia, Costa Rica, Cyprus, Czech Republic, Côte d'Ivoire (Ivory Coast), Democratic Republic of the Congo, Denmark, Djibouti, Dominican Republic, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Fiji, Finland, France, Gabon Republic, Gambia, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guatemala, Guinea, Guinea-Bissau, Guyana, Haiti, Honduras, Hong Kong, Hungary, Iceland, India, Indonesia, Ireland, Israel, Italy, Jamaica, Japan, Jordan, Kazakhstan, Kenya, Kiribati, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Liechtenstein, Lithuania, Luxembourg, Macau, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Mauritania, Mauritius, Mexico, Moldova, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Namibia, Nauru, Nepal, Netherlands, New Zealand, Nicaragua, Niger, Nigeria, Norway, Oman, Pakistan, Panama, Papua New Guinea, Paraguay, Peru, Philippines, Poland, Portugal, Qatar, Republic of Croatia, Republic of the Congo, Romania, Rwanda, Saint Kitts-Nevis, Saint Lucia, Saint Vincent and the Grenadines, San Marino, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia, Slovenia, Solomon Islands, South Africa, South Korea, Spain, Sri Lanka, Suriname, Swaziland, Sweden, Switzerland, Taiwan, Tajikistan, Tanzania, Thailand, Togo, Tonga, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Turks and Caicos Islands, Uganda, United Arab Emirates, United Kingdom, Uruguay, Uzbekistan, Vanuatu, Vatican City State, Vietnam, Wallis and Futuna, Western Samoa, Worldwide, Yemen, Zambia, Zimbabwe

Excludes:

Barbados, French Guiana, French Polynesia, Guadeloupe, Libya, Martinique, New Caledonia, Reunion, Russian Federation, Ukraine, Venezuela

Change country:

Postal Code:

Postage and handling	To	Service	Delivery*See Delivery notes
Free postage	United States	Economy Postage (USPS Media MailTM)	Estimated between Mon, 6 May and Fri, 10 May to 43230
US $4.99 (approx S$ 6.81)	United States	Expedited Postage (USPS Priority Mail®)	Estimated between Wed, 8 May and Mon, 13 May to 43230

Notes - Delivery *Estimated delivery dates include seller's handling time, origin ZIP Code, destination ZIP Code and time of acceptance and will depend on shipping service selected and receipt of cleared payment. Delivery times may vary, especially during peak periods.

Handling time

Will usually ship within 1 business day of receiving cleared payment.

Taxes

Taxes may be applicable at checkout. Learn moreLearn more about paying tax on eBay purchases.