Improve Decision Making Skills with Excel Pivot Tables
4.5 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Improve Decision Making Skills with Excel Pivot Tables to your Wishlist.

Add to Wishlist

Improve Decision Making Skills with Excel Pivot Tables

With real Companies examples learn the best tricks of Excel Pivot Tables in Just 1 Hour.
4.5 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
4 students enrolled
Last updated 11/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 8 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Format the data for better pivot tables
  • Analyze the same data from different perspectives
  • Create Dynamic Charts
  • Create Pivot tables with ease
View Curriculum
Requirements
  • Microsoft Office 2010, 2013 or 2016 (Recommended)
  • Microsoft Office 2007, 2010.
  • Basic Excel Knowledge
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. 

Who is the target audience?
  • Analysts
  • Students
  • Engineers
  • Teachers
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Introduction
1 Lecture 01:55
+
Before creating Pivot Tables
1 Lecture 06:36

In this lecture you will be able to format the data before creating a pivot table (create a good quality data). 

You will learn how to use tabular format, check values inconsistencies, clean the data and work with horizontal tables.

Preview 06:36
+
Create your first Pivot Table
1 Lecture 04:22

Create your first pivot table,

Learn the user interface of the pivot tables.

Lear the basic options of a pivot table. 

Preview 04:22
+
Create Customizable Groups
1 Lecture 06:14

Create customizable groups to visualize your data inside a pivot table.

Use Custom Groups
06:14
+
Powerful Filters
1 Lecture 04:43

Using the built in filters in Pivot Tables (Slicers and Timeline) you will be able to filter your pivot tables more efficient than ever. 

Use Slicers and Timeline
04:43
+
Custom Ranges
1 Lecture 03:34

Use custom ranges when you have numerical data that can be grouped. 

Create custom ranges
03:34
+
Create Pivot Charts and see Hidden Statistics
2 Lectures 13:26

Lear how to create different pivot charts and how to format them. 

Create Pivot Charts
04:54

Create custom columns to see hidden information inside your data. 

Customize the data
08:32
+
Conclusion
2 Lectures 07:01

Learn some cool and really usable tips and tricks.

Final Lesson
06:24

About the Instructor
Eng. Javier Polanco
4.5 Average rating
1 Review
4 Students
1 Course
Engineer

I am an hard working Industrial engineer with professional experience in inventory management & purchasing and procurement in the retail, wholesaling and import industries. In my professional experience I have come across with a lot of problems and situations that made me create creative and efficient solutions using resources (like excel) and a lot a creativity. 

This is the reason why I want to become an Online Teacher so I can teach the world all the tricks I've learned.

Also I am a Graphic Designer with experience in Adobe Photoshop and Illustrator.