Listen free for 30 days

Excel Pivot Tables: Basic Beginners Guide to Learn Excel Pivot Tables for Data Analysis and Modeling

By: MG Martin
Narrated by: Peter Prova
Length: 1 hr and 21 mins
5 out of 5 stars (25 ratings)

£7.99/month after 30 days. Cancel anytime

Summary

Most organizations and businesses use Excel to perform data analysis. These organizations also use it for modeling. There are numerous features and add-ins that Excel offers, which make it easier to perform data analysis and modeling. A Pivot Table is one such feature provided by Excel.

You can analyze a million rows of data within a few clicks, show the required results, create a pivot chart or report, drag the necessary fields around, and highlight the necessary information. It is imperative that people who use Excel are well versed with using pivots. If you are looking to learn more about what a pivot table is and how you can use it for data analysis, you have come to the right place. 

Over the course of the book, you will learn more about the Pivot Table:

  • Insert a Pivot Table
  • Drag Fields in a Pivot
  • Sort Data in a Pivot
  • Working with Tables
  • Focus on Auditing the Data
  • Refreshing the Pivot
  • Accessing the Data
  • Source Data Fields
  • And many more....

If you have been looking forward to learning Excel Pivot Tables, grab a copy of this book today to help you begin your journey. What are you waiting for?

©2019 MG Martin (P)2019 MGC Publishing

What members say

Average customer ratings

Overall

  • 5 out of 5 stars
  • 5 Stars
    21
  • 4 Stars
    4
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0

Performance

  • 5 out of 5 stars
  • 5 Stars
    20
  • 4 Stars
    5
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0

Story

  • 5 out of 5 stars
  • 5 Stars
    21
  • 4 Stars
    4
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0

Reviews - Please select the tabs below to change the source of reviews.

Sort by:
Filter by:
  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

best guide

I hope this book is able to help you very much. This book gave me a lot of information about excel pivot. This is more than my expectations, thanks author for such a great book!

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

Loved it

Loved the book and listening to MG Martin was thoroughly enjoyable. I will definitely be following the strategy and advice given here.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

easy to follow

In this book you will get some easy and useful tips about excel pivot tables. The content of this book was excellent and easy to follow.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

GOOD

This book will help you learn and understand more about excel pivot tables. The book was perfectly written in a very simple way for better and easier understanding.

  • Overall
    4 out of 5 stars
  • Performance
    4 out of 5 stars
  • Story
    4 out of 5 stars

beginners guide

I have never listen to such an easy, but comprehensive Excel learning book in my life. This is a perfect guide to learn the basic purposes of the concept and how it can help you be more effective in a number of different ways.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

informative guide

This book was so much informative about pivot tables. In this book you will learn so many things about this programming.

  • Overall
    4 out of 5 stars
  • Performance
    4 out of 5 stars
  • Story
    4 out of 5 stars

useful for all users

An elegantly composed book which has total data and loaded with learning book about Excel pivot table for beginners.

  • Overall
    4 out of 5 stars
  • Performance
    4 out of 5 stars
  • Story
    4 out of 5 stars

listening towards it

I listen to this book and can recommend to beginners and as well as experts because I also learn many new tips.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

valuable book

A well written book which has complete information and full of learning book about Excel pivot table.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

user friendly

I would give this book five stars, I would definitely recommend the book as an extremely readable and user-friendly.

Sort by:
Filter by:
  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Pradeep
  • Pradeep
  • 01-08-19

best

This is a fantastic technical walkthrough of the excel. If you read it cover to cover and use a highlighter, I guarantee that you will become a better content.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Anonymous User
  • Anonymous User
  • 01-08-19

interesting book

This book is just brilliant. Lots of effective info are in this book. i was amazed when getting that information. Just wow.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Faji
  • Faji
  • 01-08-19

Best guide

This book is very very effective . I just love this book. I will highly recommend this book. I was amazed when see lots of info in a single book.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Anonymous User
  • Anonymous User
  • 01-08-19

5start

I will give this book 5 stars. I learned everthing of excel from this book. Author explained every single thing very clearly with some proper explanations.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for Veer Singh
  • Veer Singh
  • 31-07-19

Detailed guide

Detailed book for the user. Arrived extremely fast and work out perfectly for me. Thanks a lot!!!

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for GUNA
  • GUNA
  • 31-07-19

loved it

Loved it..I encourage everyone who wants to truly be healthy to listen and learn!! Great .

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for footlose
  • footlose
  • 31-07-19

Wonderful

This is a wonderful book. I would recommend it to anyone with a firm grasp of the basics, or as a tune-up for advanced users.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for e man
  • e man
  • 31-07-19

Useful

The author has presented such a useful book for me, Personally, i was looking for this book for so long. Thanks to my friend who give this book. Really felt good to listen to it.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for durbar
  • durbar
  • 31-07-19

Awesome book

Awesome book. One of my favs for helping me understand the concept better. Excellent author, too!

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
Profile Image for cutter
  • cutter
  • 31-07-19

User friendly

I would give this book five stars, I would definitely recommend the book as an extremely readable and user-friendly.