Listen free for 30 days

Excel Pivot Tables: Beginner's Comprehensive Guide to Get Started and Learn Excel Pivot Tables

Narrated by: Dave Wright
Length: 3 hrs and 22 mins
5 out of 5 stars (25 ratings)

Regular price: £13.79

£7.99/month after 30 days. Cancel anytime

Summary

Pivot tables appear very complex to many Excel users - and rightly so, considering the very powerful results they can generate. But that is as far removed from the truth as the day is from the night. When you understand how pivot tables work, you’ll wonder why you didn't given them more of a chance.

Then there are those who have tried to learn how to use pivot tables by using the help file in Excel, yet they failed to grasp them. Others have invested time and money to get instruction manuals or tutorials that attempt to explain this powerful Excel tool, but because of the somewhat complex style of presentation of such manuals, it becomes difficult to comprehend and further discourages those who are willing to learn. Even some of the tutorials that are relatively easy to read do not contain real-life applications of pivot table functions. It’s a bit like learning abstract things that don’t really have any meaningful impact on your life.

In this guidebook, I have presented all the steps you will need to understand and use Excel’s pivot tables. I have taken the time to build this comprehensive guide from scratch, to finish with step-by-step instructions, to help you conceptualize what is being taught in this guide. I have left no stone unturned in order to give you the very best explanation with regards to pivot tables.

If you follow the easy to implement steps in this guidebook, it is my promise to you that your Excel work output will drastically increase, thereby saving you time and unnecessary hassle. By the time you really get the hang of using pivot tables, you will see how the information you generate using them will greatly impact positively on decision-making and saving time, both for you and for your organization (if you use Excel for a company). Aside from giving you clear and easy steps to perform each task, I have also included likely scenarios where you may find a use for the pivot table functions explained in this audiobook. 

Many times, users who attempt to use pivot tables, and other complex tools, tend to get frustrated when they have to follow a method that does not give them room for customization. I have been there, so I understand exactly how it feels. That is why in this guidebook, you do not only get steps on the “how-to” of pivot tables; I also give you tips and workarounds that will save you a lot of headaches and frustration.

Listen today and enhance your knowledge pertaining to Excel Pivot Tables!

©2019 Joshua Ross (P)2019 Rhoma

What members say

Average customer ratings

Overall

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

Performance

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

Story

  • 5 out of 5 stars
  • 5 Stars
    24
  • 4 Stars
    1
  • 3 Stars
    0
  • 2 Stars
    0
  • 1 Stars
    0
Sort by:
  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars

wonderful !

Wonderful book! This kept my interest from beginning to end. Would love to see more from this author.

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

suggest it

This is an extraordinary amateurs manual about excel.This book tips and traps is great and straightforward all programming language.Best book for ever I suggest it.

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

grea learn

Excellent book for anyone wanting to learn Excel! The book is very well written and has useful examples.I found this book to be an excellent introduction to using in Excel and provides plenty of examples and references to dig deeper. I like the way this is written and the details that the author provides in it are easy to understand. I absolutely love this and would highly recommend this book.

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

Great book

I own the previous book from this author! This is a huge book and a wonderful reference -- detailed and elegant. Thanks!

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

Good

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

Perfect guide

Brilliant!! Great info! Spot on tips and very methodical.Look no further! This is your guide right here!

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

Knowlegeble book

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

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

Interesting book

Excellent book for an absolute beginner who wants to understand the terms and get introduced to the subject. Would definitely recommend to all beginners.

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

Amazing book

I am really enjoying this book and am learning a great deal, especially about the Strategies and Techniques , that I never knew before.

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

must listen to it

Well presented and packed full of helpful information. I've found it very informative. By reading this book i have learned lot about the subject. If anyone interested in the subject should read.

Sort by:
  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
  • Britto
  • 09-04-19

Helpful book

It is a very short book that you can read in one sitting and can be used as a tutorial, study guide, or whatever suits your needs to use excel for.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
  • Kamal
  • 09-04-19

Valuable

This is an easy read and you don't have to be an expert with pivot tables to start with. It will be a great resource and I'm sure it is something I will refer to many times.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
  • juju
  • 09-04-19

Interesting

There are a couple of simple little tricks which are going to make my life easier and there is an excellent section on presentation which will make me look like a rock star!

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
  • Paul
  • 09-04-19

An excellent source for building pivot tables.


Being able to download the workbook on which to practice is key. Reading AND doing makes learning much more "sticky".

An excellent source for building pivot tables.
excellent book, its helping me at work!

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
  • Losliya
  • 09-04-19

Good job

Excellent work it’s a damn good resource that anyone will use . I really think his system works rather well

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
  • Dhoni
  • 09-04-19

GOOD

Very good introduction to pivot tables and some of the common problems you can face when building them. Nice structure to lessons.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
  • Anonymous User
  • 09-04-19

Amazing

I am following this book instruction now I can proper use of Microsoft Excel. Especially thanks to the author

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
  • Anonymous User
  • 09-04-19

best

By far this is the best book I came across on Excel pivot tables. Unlike others where the content is so riddled and filled with fluff, the Author has managed to put it in a concise and 'to the point'.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
  • Arshi
  • 08-04-19

Useful book

The book was perfectly written for beginners for easier understanding. All the information was so easy to understand.

  • Overall
    5 out of 5 stars
  • Performance
    5 out of 5 stars
  • Story
    5 out of 5 stars
  • reddy
  • 08-04-19

Helpful book

I really enjoyed learning about using a pivot table. I would recommend this book and read more books from this author.