What do you think?
Rate this book
Mastering Excel: Pivot Tables
Pivot tables are THE indispensable skill you need to know to master Excel. They are the workhorses of Excel. You have 100,000 rows of data by invoice, product, salesperson and you are getting bombarded with questions. Who’s the highest earner? Which product sold the most in the last seven days. After this lesson, you’ll be able to answer those questions in seconds.This lesson is focused on this incredibly power tool.I walk you through all the steps to create a pivot table, how to work with pivot charts, using Excel tables effectively with Pivot Tables, how to create calculations in Pivot Tables, and much more.As always, I explain all the steps in plain English. The lessons are geared towards the average Excel user that just wants to improve their skill set without having to suffer through hours of technical, confusing instruction.Included in the book is a link to download a free workbook so readers can follow along with the exercises at their own pace.
72 pages, Paperback
First published April 1, 2013
99 people are currently reading
40 people want to read
About the author
Mark Moore
199 books3 followersLibrarian note:
There is more than one author in the GoodReads database with this name
This profile may contain books from multiple authors of this name.
There is more than one author in the GoodReads database with this name
This profile may contain books from multiple authors of this name.
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 3 of 3 reviews
October 28, 2021
Covers the basics of MS Excel Pivots succinctly enough.
I have some experience of MS Excel and so there's not much here that's new to me, for which I was glad. Without prior experience I would have struggled. The screenshots don't always match up with the text and the text is sometimes a little short on depth. That said, if you are new to this then it should give you an adequate intro to the subject provided you download the worksheets from the author's website (assuming they are still available).
My advice is: if you're new to the subject, don't go into this book without MS Excel in front of you. This isn't something you can read whilst walking around a lake. Well, it is, but you won't learn effectively.
I have some experience of MS Excel and so there's not much here that's new to me, for which I was glad. Without prior experience I would have struggled. The screenshots don't always match up with the text and the text is sometimes a little short on depth. That said, if you are new to this then it should give you an adequate intro to the subject provided you download the worksheets from the author's website (assuming they are still available).
My advice is: if you're new to the subject, don't go into this book without MS Excel in front of you. This isn't something you can read whilst walking around a lake. Well, it is, but you won't learn effectively.
August 30, 2018
Easy going
Well written and explained book on very useful and hot topic for me. Pivot tables can save so much time and make your work much more effective.Thanks!
Well written and explained book on very useful and hot topic for me. Pivot tables can save so much time and make your work much more effective.Thanks!
August 5, 2019
Sometimes I feel like I need to be a rocket scientist to use any aspect of Microsoft Excel. This short book is a good reference when building pivot tables. I recommend you read the entire book before attempting your first pivot table, and then proceed step-by-step.
I think this is a pretty decent book that it covers it in depth. I wish I had this when I attempted my first one; as it is, I felt like a newbie when I read this book again, so take that in to consideration. If you are a newbie to pivot tables, or if you just want to learn more about pivot tables, this might be a good book to reference and/or use.
One or two typos; but they were only upper/lower case and run-on sentence variety, and would not affect understanding of how to create pivot tables.
Three stars.
I think this is a pretty decent book that it covers it in depth. I wish I had this when I attempted my first one; as it is, I felt like a newbie when I read this book again, so take that in to consideration. If you are a newbie to pivot tables, or if you just want to learn more about pivot tables, this might be a good book to reference and/or use.
One or two typos; but they were only upper/lower case and run-on sentence variety, and would not affect understanding of how to create pivot tables.
Three stars.
Displaying 1 - 3 of 3 reviews