No Nonsense Excel Pivot Tables Pro Course

With real Companies examples learn the best tricks of Excel Pivot Tables in Just 1 Hour. Improve Decision Making Skills.

4.55 (1878 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
19,255
students
1 hour
content
Nov 2016
last update
$44.99
regular price

What you will learn

Format the data for better pivot tables

Analyze the same data from different perspectives

Create Dynamic Charts

Create Pivot tables with ease

Description

Working with large data can be stressful and time consuming, also sometimes you have to dig down too much just to get simple statistics. This course will make you analyze data a lot more quick and efficient using pivot tables. The content of this course will not only make you faster, will make you improve in the decision making process because you will be able to see statistics that are almost impossible to see just using normal tables.

Analyze any type of data using pivot tables with practical examples

  • Format any type of data to create better and cleaner pivot tables.
  • Practice with 6 real life practical examples.
  • Create pivot tables with ease.
  • Group data fields manually to have a better perspective.
  • See your results in percentages, numbers and a lot more formats.
  • Learn how to create and easily use Pivot Charts.
  • Use powerful filters to dig down your data.
  • Customize you original data to create very powerful Pivot Tables.

Quicker than you ever imagine

Pivot Tables are not difficult nor advanced tools, you cannot believe how easy is to create and manipulate them. If you use excel to process any type of data in you personal life, job or any other project, this course will bring you efficient solutions with 6 real life practical examples. 

Contents and overview

Forget theoretical explanations and slow, long and boring examples and learn in just 1 hour, 10 lessons and 6 practical examples everything you need to know about pivot tables. 

The learning method used in this course brings easy and digestible explanations while you work simultaneously with me in every single lesson.  

When you finish the course you will create pivot tables in less than 5 minutes with clean and good quality data, also you will be able to visualize your data with dynamic pivot charts. 

As a bonus you will learn some tips, tricks and hacks, that made me succeed in a lot of problems and situations in my professional experience and will help you more than you imagine in yours. 

Content

Introduction

Introduction

Before creating Pivot Tables

Format the data

Create your first Pivot Table

Create a Pivot Table

Create Customizable Groups

Use Custom Groups

Powerful Filters

Use Slicers and Timeline

Custom Ranges

Create custom ranges

Create Pivot Charts and see Hidden Statistics

Create Pivot Charts
Customize the data

Conclusion

Final Lesson
Conclusion

Screenshots

No Nonsense Excel Pivot Tables Pro Course - Screenshot_01No Nonsense Excel Pivot Tables Pro Course - Screenshot_02No Nonsense Excel Pivot Tables Pro Course - Screenshot_03No Nonsense Excel Pivot Tables Pro Course - Screenshot_04

Reviews

Ana
October 20, 2023
Excellent!! Very easy to understand and to follow. Provided a lot of practice sheets. Very good. I recommend. Thank you!
Zahid
April 26, 2021
An excellent tutorial on Pivot table that gets to point straight with no fluff. Offers practical examples. Easy to follow and
Simon
February 10, 2021
Very good for adjusting the way pivot tables show data, not much on how to manipulate it within the pivot table. Fun though and learned some good stuff.
Sony
February 1, 2021
Very informative, great for introduction to Pivot table. Sometimes went a little too fast, but not too bad. Would appreciate if more practice materials were provided. Thank you for the great lessons!
Lakhvinder
January 30, 2021
This was an amazing quick course on pivot tables. The trainer is completely right practice, practice is the key.
Teju
November 3, 2020
Full of demo, quick and easy, hardly any theory which was great. Great and fast way to learn creating pivot tables. loved it!
Barbara
November 2, 2020
Rispetto alle mie conoscenze, l'ho trovato un po' troppo basico. Comunque ottimo per approcciarsi alle pivot. Molto chiaro!
Veronica
October 11, 2020
I did not finish yet the course, but so far, I am learning lot of useful shortcuts and understanding better how to arrange the fields for a good table design.
Syed
July 5, 2020
This course was well worth investing a couple hours. Recommend for anybody who wants to get good at pivot tables.
Roody
July 3, 2020
I love this course. I have learnt in a short period of time so much. Teacher's explanation were very clear and precise. Thank you very much
Rawad
June 25, 2020
I liked it and learned some of points in pivot table that make it easier for me and future.. thanks Udemy
Rubas
June 15, 2020
Javier explains the concept and practical examples of Pivot table and chart very effectively. I also enjoyed the tips and tricks discussed in between. Highly recommended for anyone who wishes to improve their data representation.
Marta
June 2, 2020
This course is absolutely amazing. It is brilliantly delivered with the exact amount of information needed to master the pivot table function in a reasonable period of time. Highly recommended!
Darshan
May 25, 2020
the course was good for beginners and someone who wish to expand his skills, i want to know where i can connect to ask when i have any query.
Sudhir
May 14, 2020
It’s a very intact course focused over pain point of Pivot Table, which one could only learn over the time by coming across them. But this course is like learning from others’ mistakes, a perfect summarisation of one’s experiences.

Charts

Price

No Nonsense Excel Pivot Tables Pro Course - Price chart

Rating

No Nonsense Excel Pivot Tables Pro Course - Ratings chart

Enrollment distribution

No Nonsense Excel Pivot Tables Pro Course - Distribution chart
1007630
udemy ID
11/9/2016
course created date
8/14/2019
course indexed date
Bot
course submited by