Picture 1 of 1
Picture 1 of 1
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) by Bi
US $40.40
Condition:
3 available
Shipping:
Located in: Fairfield, Ohio, United States
Delivery:
Estimated between Fri, Jun 28 and Wed, Jul 10 to 43230
Returns:
Payments:
Special financing available. See terms and apply now- for PayPal Credit, opens in a new window or tab
Earn up to 5x points when you use your eBay Mastercard®. Learn moreabout earning points with eBay Mastercard
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:395377795778
Item specifics
- Condition
- ISBN-13
- 9780137521838
- Book Title
- Microsoft Excel Pivot Table Data Crunching (Office 2021 and Micro
- ISBN
- 9780137521838
- Subject Area
- Computers
- Publication Name
- Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)
- Publisher
- Pearson Education
- Item Length
- 9.1 in
- Subject
- Desktop Applications / General, Desktop Applications / Spreadsheets
- Publication Year
- 2021
- Series
- Business Skills Ser.
- Type
- Textbook
- Format
- Trade Paperback
- Language
- English
- Item Height
- 1.4 in
- Item Weight
- 32.3 Oz
- Item Width
- 7.4 in
- Number of Pages
- 544 Pages
About this product
Product Identifiers
Publisher
Pearson Education
ISBN-10
0137521839
ISBN-13
9780137521838
eBay Product ID (ePID)
15050426830
Product Key Features
Number of Pages
544 Pages
Language
English
Publication Name
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)
Subject
Desktop Applications / General, Desktop Applications / Spreadsheets
Publication Year
2021
Type
Textbook
Subject Area
Computers
Series
Business Skills Ser.
Format
Trade Paperback
Dimensions
Item Height
1.4 in
Item Weight
32.3 Oz
Item Length
9.1 in
Item Width
7.4 in
Additional Product Features
Intended Audience
Scholarly & Professional
LCCN
2021-948294
Dewey Edition
23
Illustrated
Yes
Dewey Decimal
005.54
Table Of Content
Introduction CHAPTER 1 Pivot table fundamentals CHAPTER 2 Creating a basic pivot table CHAPTER 3 Customizing a pivot table CHAPTER 4 Grouping, sorting, and filtering pivot data CHAPTER 5 Performing calculations in pivot tables CHAPTER 6 Using pivot charts and other visualizations CHAPTER 7 Analyzing disparate data sources with pivot tables CHAPTER 8 Sharing dashboards with Power BI CHAPTER 9 Using cube formulas with the Data Model or OLAP data CHAPTER 10 Unlocking features with the Data Model and Power Pivot CHAPTER 11 Analyzing geographic data with 3D Map CHAPTER 12 Enhancing pivot table reports with macros CHAPTER 13 Using VBA or TypeScript to create pivot tables CHAPTER 14 Advanced pivot table tips and techniques CHAPTER 15 Dr. Jekyll and Mr. GetPivotData CHAPTER 16 Creating pivot tables in Excel Online
Synopsis
Learn how to use Excel pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you've never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power--including valuable improvements in Excel and in Office 365. Drawing on more than 45 combined years of Excel experience, Bill Jelen and Michael Alexander offer practical "recipes" for solving real business problems, help you avoid common mistakes, and present tips and tricks you'll find nowhere else., Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business! Even if you've never created a pivot table before, this book will help you leverage all their flexibility and analytical power-- including important recent improvements in Microsoft 365 Excel. Drawing on more than 30 years of cutting-edge Excel experience, MVP Bill Jelen ("MrExcel") shares practical "recipes" for solving real business problems, expert insights for avoiding mistakes, and advanced tips and tricks you'll find nowhere else. By reading this book, you will: Master easy, powerful ways to create, customize, change, and control pivot tables Transform huge datasets into clear summary reports Instantly highlight your most profitable customers, products, or regions Use the data model and Power Query to quickly analyze disparate data sources Create powerful crosstab reports with new dynamic arrays and Power Query Build geographical pivot tables with 3D Maps Construct and share state-of-the-art dynamic dashboards Revamp analyses on the fly by dragging and dropping fi elds Build dynamic self-service reporting systems Share your pivot tables with colleagues Create data mashups using the full Power Pivot capabilities in modern Excel versions Generate pivot tables using either VBA on the Desktop or Typescript in Excel Online Save time and avoid formatting problems by adapting reports with GetPivotData Unpivot source data so it's easier to work with Use new Analyze Data artificial intelligence to create pivot tables
LC Classification Number
HF5548.4.M523
ebay_catalog_id
4
Copyright Date
2022
Item description from the seller
Seller assumes all responsibility for this listing.
eBay item number:395377795778
Shipping and handling
Item location:
Fairfield, Ohio, United States
Ships to:
Afghanistan, Albania, Algeria, Andorra, Angola, Anguilla, Antigua and Barbuda, Argentina, Armenia, Aruba, Australia, Austria, Azerbaijan Republic, Bahamas, Bahrain, Bangladesh, Belarus, Belgium, Belize, Benin, Bermuda, Bhutan, Bolivia, Bosnia and Herzegovina, Botswana, Brazil, British Virgin Islands, Brunei Darussalam, Bulgaria, Burkina Faso, Burundi, Cambodia, Cameroon, Canada, Cape Verde Islands, Cayman Islands, Central African Republic, Chad, Chile, China, Colombia, Comoros, Cook Islands, Costa Rica, Cyprus, Czech Republic, Côte d'Ivoire (Ivory Coast), Democratic Republic of the Congo, Denmark, Djibouti, Dominica, Dominican Republic, Ecuador, Egypt, El Salvador, Equatorial Guinea, Eritrea, Estonia, Ethiopia, Falkland Islands (Islas Malvinas), Fiji, Finland, France, Gabon Republic, Gambia, Georgia, Germany, Ghana, Gibraltar, Greece, Greenland, Grenada, Guatemala, Guernsey, Guinea, Guinea-Bissau, Guyana, Haiti, Honduras, Hong Kong, Hungary, Iceland, India, Indonesia, Iraq, Ireland, Israel, Italy, Jamaica, Japan, Jersey, Jordan, Kazakhstan, Kenya, Kiribati, Kuwait, Kyrgyzstan, Laos, Latvia, Lebanon, Lesotho, Liberia, Liechtenstein, Lithuania, Luxembourg, Macau, Macedonia, Madagascar, Malawi, Malaysia, Maldives, Mali, Malta, Mauritania, Mauritius, Mayotte, Mexico, Moldova, Monaco, Mongolia, Montenegro, Montserrat, Morocco, Mozambique, Namibia, Nauru, Nepal, Netherlands, Netherlands Antilles, New Zealand, Nicaragua, Niger, Nigeria, Niue, Norway, Oman, Pakistan, Panama, Papua New Guinea, Paraguay, Peru, Philippines, Poland, Portugal, Qatar, Republic of Croatia, Republic of the Congo, Romania, Rwanda, Saint Helena, Saint Kitts-Nevis, Saint Lucia, Saint Pierre and Miquelon, Saint Vincent and the Grenadines, San Marino, Saudi Arabia, Senegal, Serbia, Seychelles, Sierra Leone, Singapore, Slovakia, Slovenia, Solomon Islands, Somalia, South Africa, South Korea, Spain, Sri Lanka, Suriname, Svalbard and Jan Mayen, Swaziland, Sweden, Switzerland, Taiwan, Tajikistan, Tanzania, Thailand, Togo, Tonga, Trinidad and Tobago, Tunisia, Turkey, Turkmenistan, Turks and Caicos Islands, Tuvalu, Uganda, United Arab Emirates, United Kingdom, Uruguay, Uzbekistan, Vanuatu, Vatican City State, Vietnam, Wallis and Futuna, Western Sahara, Western Samoa, Worldwide, Yemen, Zambia, Zimbabwe
Excludes:
APO/FPO, Alaska/Hawaii, Barbados, French Guiana, French Polynesia, Guadeloupe, Libya, Martinique, New Caledonia, Reunion, Russian Federation, US Protectorates, Ukraine, Venezuela
| Shipping and handling | Each additional item | To | Service | Delivery*See Delivery notes |
|---|---|---|---|---|
| Free shipping | Free | United States | Economy Shipping | Estimated between Fri, Jun 28 and Wed, Jul 10 to 43230 |
| Handling time |
|---|
| Will usually ship within 3 business days of receiving cleared payment. |
| Taxes |
|---|
| Taxes may be applicable at checkout. Learn moreLearn more about paying tax on eBay purchases. |
Sales Tax for an item #395377795778
Sales Tax for an item #395377795778
Seller collects sales tax for items shipped to the following states:
| State | Sales Tax Rate |
|---|
Return policy
| After receiving the item, contact seller within | Refund will be given as | Return shipping |
|---|---|---|
| 30 days | Money Back | Buyer pays for return shipping |
Refer to eBay Return policyopens in a new tab or window for more details. You are covered by the eBay Money Back Guaranteeopens in a new tab or window if you receive an item that is not as described in the listing.
Payment details
Payment methods
Seller feedback (1,025,745)
i***6 (139)- Feedback left by buyer.
Past 6 months
Verified purchase
Item as described, good price, well packaged, arrived slightly later than hoped (not in time for Christmas ) but the order was placed in a very busy shipping period. No issue with the seller’s speed of response and sending the item. Great seller!
l***a (3518)- Feedback left by buyer.
Past month
Verified purchase
Excellent seller. Timely shipping, safe packing, good communication, great price and as described. Thank you. A+++
o***b (144)- Feedback left by buyer.
Past month
Verified purchase
The seller is one of the best there is - high quality books, reasonable prices, securely packaged.
I do, however, recommend some changes to their shipping - they show a shipper (SortHub) on eBay, but the tracking # they email is for a different carrier. It’s difficult to know where my purchase is.
This time, it was delivered a week late. In the grand scheme of things not a big deal. But it shouldn’t be this difficult to accurately track my purchase.