Excel Pivot Tables in a Nutshell
What you'll learn
- 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
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.
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.)
Who this course is for:
- 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
Course content
- 00:22Welcome!
- Preview00:45
- Preview01:08
Instructor
![Sebastian Glöckner](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 9,662 Reviews
- 144,593 Students
- 89 Courses
(Please scroll down for english version.)
Kennst Du das Gefühl, wenn Du am letzten Tag vor dem Urlaub plötzlich extrem viel geschafft bekommst? Nur, weil Du ein festes Ziel vor Augen hast? Für mich sollte jeder Tag so sein!
Ich bin Diplom-Informatiker und arbeite seit 14 Jahren als Vollzeit-Projektmanager und Consultant. Ich liebe es, komplexe Abläufe zu verstehen, Prozesse zu verbessern und Projekte zum Erfolg zu führen.
Seit fast 25 Jahren beschäftige ich mich außerdem mit Microsoft Excel und wende das auch täglich in meinen Projekten an.
Aus dem Grund gehen die meisten meiner Kurse hier in Richtung Projektmanagement und Excel. Da kann mir einfach keiner mehr was vormachen, und ich teile mein Wissen am liebsten mit echten Beispielen aus der Praxis.
--------------------------------------------------------------
English Version
Do you know the feeling when you suddenly get a lot of work done on the last day before your holiday? Only because you have a fixed goal in mind? For me every day should be like this!
I have a degree in computer science and have been working as a full-time project manager and consultant for 14 years. I love to understand complex processes, to improve processes and to lead projects to success.
I have also been working with Microsoft Excel for 25 years and apply it to my projects on a daily basis.
That's why most of my courses here focus on project management and Excel. Nobody can fool me anymore and I prefer to share my knowledge with real examples from practice.