Excel Pivot Tables in a Nutshell

Learn how to use Excel Pivot Tables at work plus one killer trick.
4.3 (177 ratings) 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.
9,360 students enrolled
$200
Take This Course
  • Lectures 10
  • Contents Video: 28 mins
    Other: 3 mins
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2015 English

Course Description

Works with any Excel version!

Do you know why so many people use Pivot Tables in Excel?Many people use pivot tables in their daily work for fast, standardized requests. What does that even mean? Imagine you need to know the total sales of your business broken down to months. You don't need to filter that manually - pivot tables are the perfect tool to give you that answer every time fully automated!

This course contains downloadable xlsx-files attached to the lectures containing the formulas and data shown in the videos!

What you will learn

  • Build up a pivot table in 30 seconds
  • Practice with a more detailed example
  • What to do if you need more than two dimensions (you'll understand when you see it)
  • Advanced killer trick: Pull data from a pivot table into your individual report!

30 day full refund policy + no questions asked! (If bought via Udemy website. If you bought the course via App and are not satisfied, please contact me directly.)

What are the requirements?

  • Microsoft Excel in any version (works also with 2003, 2007, 2010)
  • The killer trick requires some Excel knowledge. The other tricks are pretty basic to learn.

What am I going to get from this course?

  • Know why people use Pivot Tables
  • Create an Excel Pivot Table in 30 seconds
  • Be able to pull data from a Pivot Table into your own reports

What is the target audience?

  • Anyone who wants to learn or to repeat the best Excel Pivot tricks professionals use every day
  • Interest in time-saving tricks for everyday use

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Welcome!
Article
Section 1: Introduction
Teaser Video
Preview
00:45
Introduction to the Course
Preview
01:08
Before We Go On
Article
Section 2: All You Need To Know About Pivot Tables
All You Need To Know To Build Your First Pivot Table
06:14
Another Detailed Example
08:00
How About A Table With More Than Two Dimensions?
02:09
Advanced Killer Trick - Bring Data Into Your Individualized Report
Preview
09:33
Section 3: Conclusion / BONUS
Wrap Up / Conclusion
Article
GET OTHER COURSES WITH 40% OFF
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Sebastian Glöckner, Make Things Happen!

Hi!

Do you know that feeling one day ahead of vacation when you sort out your
projects, send overdue emails and suddenly get a lot things done? For me every day should be as successful as that! And I would like to share enough knowledge with you to make that happen.

I work as a project manager, entrepreneur and management consultant for more than 15 years. I love to deconstruct systems, improve processes and bring projects to success (and did that already for various customers all over Europe).

Currently I work full time as a project manager and process expert. My daily business it to make things faster and manage multiple things at the same time.


I am into time- and self management. I love improving myself and assist others in working faster and with better results. 

In the past decade I studied various resources about time management, project management, and self management. Doing that I came to the conclusion that 80% of the common "self management tips" do not work as promised. That's why I developed invented my own system for being as productive as possible.

Ready to start learning?
Take This Course