Kindle Price: $20.44

Save $16.35 (44%)

Promotions apply when you purchase

These promotions will be applied to this item:

Some promotions may be combined; others are not eligible to be combined with other offers. For details, please see the Terms & Conditions associated with these promotions.

eBook features:
  • Highlight, take notes, and search in the book
  • In this edition, page numbers are just like the physical edition
Read with our free app
You've subscribed to ! We will preorder your items within 24 hours of when they become available. When new books are released, we'll charge your default payment method for the lowest price available during the pre-order period.
Update your device or payment method, cancel individual pre-orders or your subscription at
Your Memberships & Subscriptions

Buy for others

Give as a gift or purchase for a team or group.
Learn more

Buying and sending eBooks to others

  1. Select quantity
  2. Buy and send eBooks
  3. Recipients can read on any device

These ebooks can only be redeemed by recipients in the US. Redemption links and eBooks cannot be resold.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the authors

Bill Jelen
+ Follow
Michael Alexander
+ Follow
See all
Something went wrong. Please try your request again later.

Excel 2013 Pivot Table Data Crunching (MrExcel Library) 1st Edition, Kindle Edition

by Bill Jelen (Author), Michael Alexander (Author) Format: Kindle Edition
4.3 4.3 out of 5 stars 92 ratings
See all formats and editions

CRUNCH ANY DATA, FROM ANY SOURCE, QUICKLY AND EASILY, WITH EXCEL 2013 PIVOT TABLES!

Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control!

 

Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power. In just the first seven chapters, you learn how to generate complex pivot reports complete with drill-down capabilities and accompanying charts. Then, you go even further, discovering how to build a comprehensive, dynamic pivot table reporting system for any business task or function.

 

Learning advanced pivot table and pivot chart techniques for Excel 2013 or the newest Office 365 has never been easier. You’ll find simple, step-by-step instructions, real-world case studies, even complete, easy recipes for solving your most common business analysis problems.

 

•   Create, customize, and change your pivot tables and pivot charts

•   Transform gigantic data sets into crystal-clear summary reports

•   Summarize and analyze data even faster with new Excel 2013 recommended pivot tables

•   Instantly highlight your most (and least) profitable customers, products, or regions

•   Quickly filter pivot tables using slicers

•   Use dynamic dashboards using Power View to see exactly where your business stands right now

•   Revamp analyses on the fly by simply dragging and dropping fields

•   Build dynamic self-service reporting systems your entire team can use

•   Use PowerPivot or the Data Model to create pivot tables from multiple data sources and worksheets

•   Work with and analyze OLAP data, and much more

 

About MrExcel Library:  Every book in the MrExcel Library pinpoints a specific set of crucial Excel tasks and presents focused skills and examples for performing them rapidly and effectively. Selected by Bill Jelen, Microsoft Excel MVP and mastermind behind the leading Excel solutions website MrExcel.com, these
books will

•   Dramatically increase your productivity—saving you 50 hours a year or more

•   Present proven, creative strategies for solving real-world problems

•   Show you how to get great results, no matter how much data you have

•   Help you avoid critical mistakes that even experienced users make

 

 CATEGORY: Spreadsheets

COVERS: Microsoft Office Excel 2013

 

Read more Read less
Previous page
  1. ISBN-13
    978-0789748751
  2. Edition
    1st
  3. Sticky notes
    On Kindle Scribe
  4. Publisher
    Que Publishing
  5. Publication date
    January 7, 2013
  6. Part of series
    MrExcel Library
  7. Language
    English
  8. File size
    97243 KB
  9. See all details
Next page
Due to its large file size, this book may take longer to download
Next 5 for you in this series See full series
Total Price: $149.70
By clicking on the above button, you agree to Amazon's Kindle Store Terms of Use

Editorial Reviews

About the Author

Bill Jelen, Excel MVP and the host of MrExcel.com, has been using spreadsheets since 1985, and he launched the MrExcel.com website in 1998. Bill was a regular guest on Call for Help with Leo Laporte and has produced more than 1,500 episodes of his daily video podcast, Learn Excel from MrExcel. He is the author of 38 books about Microsoft Excel and writes the monthly Excel column for Strategic Finance magazine and his Excel tips appear regularly in CFO Excel Pro newsletter and CFO Magazine. Before founding MrExcel.com, Bill Jelen spent 12 years in the trenches, working as a financial analyst for the finance, marketing, accounting, and operations departments of a $500 million public company. He lives near Akron, Ohio with his wife, Mary Ellen.

Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 15 years of experience consulting and developing Office solutions. Mike has been named a Microsoft MVP for his ongoing contributions to the Excel community. In his spare time, he runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips to the Office community.

Product details

  • ASIN ‏ : ‎ B00AXYKNAK
  • Publisher ‏ : ‎ Que Publishing; 1st edition (January 7, 2013)
  • Publication date ‏ : ‎ January 7, 2013
  • Language ‏ : ‎ English
  • File size ‏ : ‎ 97243 KB
  • Simultaneous device usage ‏ : ‎ Up to 5 simultaneous devices, per publisher limits
  • Text-to-Speech ‏ : ‎ Enabled
  • Screen Reader ‏ : ‎ Supported
  • Enhanced typesetting ‏ : ‎ Enabled
  • X-Ray ‏ : ‎ Not Enabled
  • Word Wise ‏ : ‎ Not Enabled
  • Sticky notes ‏ : ‎ On Kindle Scribe
  • Print length ‏ : ‎ 434 pages
  • Customer Reviews:
    4.3 4.3 out of 5 stars 92 ratings

About the authors

Follow authors to get new release updates, plus improved recommendations.
Previous page
  1. Bill Jelen

    Bill Jelen

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Bill Jelen is the host of MrExcel.com and the author of 60 books about Microsoft Excel including Excel Gurus Gone Wild, Pivot Table Data Crunching, and Excel 2019 Inside Out. He has made over 80 guest appearances on TV’s Call for Help with Leo Laporte and was voted guest of the year on the Computer America radio show. He writes the Excel column for Strategic Finance magazine.

    He has produced over 2200 episodes of his daily video podcast Learn Excel from MrExcel. Before founding MrExcel.com in 1998, Jelen spent twelve years “in the trenches”, as a financial analyst for the accounting, finance, marketing, and operations departments of a publicly held company. Since then, his company automates Excel reports for hundreds of clients around the world. The website answers over 30,000 questions a year – for free – for readers all over the world.

    In his free time, Jelen is a rocket launch photographer for We Report Space.

    See more on the author's page
  2. Michael Alexander

    Michael Alexander

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Mike Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. He has more than 16 years experience consulting and developing Office solutions. Michael has been named a Microsoft MVP for his ongoing contributions to the Excel community. Visit him at www.datapigtechnologies.com.

    See more on the author's page
Next page

Customer reviews

4.3 out of 5 stars
4.3 out of 5
92 global ratings

Top reviews from the United States

Yah Man
5.0 out of 5 stars Great Investment for your life!
Reviewed in the United States on July 26, 2013
Verified Purchase
I received this book two days ago, and am about half way through. I had NO experience with pivot tables this book has been a life saver. This book has taught me not only how to do pivot tables with excel hands on examples (that you download at Mr. Excel website) but has also taught me how to think critically, why is this important to do, or why does this need to go here and not there. This hands on and theory approach is the best way of learning new concepts. I truly believe that a 10 year old could learn how to do pivot tables with this book it is that well written. The examples are great with data cleaning all the way to VBA programing. This book I would recommend without doubt if you are in need or want to learn pivot tables. I feel confident that in less than 2 days that I will put it on a resume as a technical skill. Best $30 I have ever spent and I would consider this a great investment for your life!
19 people found this helpful
Helpful
 Report
Wendoll
4.0 out of 5 stars Very nice reference manual
Reviewed in the United States on June 22, 2015
Verified Purchase
Great reference guide as well as a nice, self-training manual. Written in a way that the reader doesn't feel intimidated from all the details, as long as they have basics of excel under their belt before purchasing this manual.
Helpful
 Report
Lawrence J Merrick
5.0 out of 5 stars Great for fully understanding Pivot Tables
Reviewed in the United States on May 4, 2014
Verified Purchase
I am a long term Excel user, (after many years using Lotus 123 and visicalc before that). I realized I needed to fully understand what I could do with Pivot Tables and how to make full use of the their features. This was the perfect companion for me while I was taking on a new complex excel project. While I had a rudimentary understanding of Pivots, this provided me with the extra knowledge to take my skills to the next level. Excel continues to add new features that continue our need to stay current, this worked for me. I am not sure how this book would be for a novice or beginning excel user, but if you really need to understand the power of Pivot Tables -- it is great.
9 people found this helpful
Helpful
 Report
Ted Simpson
5.0 out of 5 stars Real in-depth resource for Excel Pivot Tables
Reviewed in the United States on October 14, 2013
Verified Purchase
This is a really thorough description and analysis of Excel pivot tables and charts, and the use of them to analyze data. Well written with plenty of practical examples of their use.

Just browsing it will equip you with a broader knowledge of the wide applicability of this powerful tool. You can often eliminate dozens of lines of VBA code with their use.

I learned a great deal from just the first few days of quick reads of this book. Highly recommended.
9 people found this helpful
Helpful
 Report
Raymond H Dugan
3.0 out of 5 stars Resourceful.
Reviewed in the United States on March 24, 2015
Verified Purchase
Resourceful.
Helpful
 Report
Gabe Nequer
4.0 out of 5 stars Another good Mr. Excel reference
Reviewed in the United States on May 29, 2015
Verified Purchase
Great reference to have near the desk if you want to jump start pivot table skills. Allows for reader to jump around as needed or read front to back. Overall another strong addition from Mr. Excel books.
Helpful
 Report
Mike Excelisfun
5.0 out of 5 stars Amazing PivotTable book!
Reviewed in the United States on March 5, 2013
Verified Purchase
I have bought every version of this book and it is THE book to get if you want to know about PivotTables! I laearned so many of the tricks that I know from Mr Excel and this book!

--excelisfun
8 people found this helpful
Helpful
 Report
Gilbert Baca
5.0 out of 5 stars For beginners to intermediate users of BI
Reviewed in the United States on April 11, 2016
Verified Purchase
Great book, probably more for a beginner with some experience in BI and graphing. If you're an experienced BI data grapher you probably won't get too much more out of this than you would just surfing the web, searching for solutions. It's a great resource, learned much, already put lots into practice.
Helpful
 Report

Top reviews from other countries

Translate all reviews to English
Nicácio Sales
5.0 out of 5 stars Tabelas dinâmicas um novo caminho para especialistas.
Reviewed in Brazil on July 3, 2020
Verified Purchase
Aqui o modelador de Planilhas em Excel pode seguramente aprender e aprimorar as técnicas de modelagem de tabelas dinâmicas inteligentes. Inserindo fórmulas em Campos calculados é possível agregar soluçōes mais eficazes as suas planilhas, sem correr o risco de um usuário inexperiente e desavisado destruir suas tão queridas fórmulas. Bom demais para os desenvolvedores de soluçōes inteligentes e ágeis em Excel.
Report
Rafiullah
5.0 out of 5 stars First Class Book on Pivot Tables
Reviewed in the United Kingdom on November 11, 2017
Verified Purchase
The first half of the book details the core principles of pivot table use, including creating Pivot Tables, customizing a Pivot Table, grouping and filtering, performing calculations and using Pivot Charts. The second half includes more advanced topics such as PowerPivot and Dax, Olap cubes, and VBA.

I have so far read the first half of the book and it is excellent. There are examples to go through with the supplied data (easy to download). There are enough good, easy to read screenshots to make this process easy. The topics are covered in depth but concisely, the authors have extremely detailed knowledge of the subject matter and have great clarity.

Overall, if you are interested in pivot tables this book is highly recommended.
One person found this helpful
 Report
CYBERSUN
5.0 out of 5 stars GREAT BOOK FROM THE MASTER
Reviewed in Canada on November 19, 2016
Verified Purchase
Great book from the MASTER! Excellent presentation of the concepts needed to work with large DB/Tables
Report
Amazon Customer
5.0 out of 5 stars Excellent
Reviewed in India on March 31, 2017
Verified Purchase
Very nice and informative book. Pivot tables are something which are powerful and can't be ignored if you want to derive hidden meanings and trends out of huge data.
Report
lister_yu
5.0 out of 5 stars Excellent
Reviewed in Germany on March 27, 2014
Verified Purchase
Even I am not a native speaker, this is the book to get for pivot tables - had a look at many othe books but none was as useful as this one.
Report

Report an issue


Does this item contain inappropriate content?
Report
Do you believe that this item violates a copyright?
Report
Does this item contain quality or formatting issues?
Report