Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
0 Hour(s) 47 Minute(s)
Language
English
Taught by
Javier Polanco
Rating
1 views
Course Overview
With real Companies examples learn the best tricks of Excel Pivot Tables in Just 1 Hour. Improve Decision Making Skills.
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.
Course Content
- 8 section(s)
- 10 lecture(s)
- Section 1 Introduction
- Section 2 Before creating Pivot Tables
- Section 3 Create your first Pivot Table
- Section 4 Create Customizable Groups
- Section 5 Powerful Filters
- Section 6 Custom Ranges
- Section 7 Create Pivot Charts and see Hidden Statistics
- Section 8 Conclusion
What You’ll Learn
- Format the data for better pivot tables
- Analyze the same data from different perspectives
- Create Dynamic Charts
- Create Pivot tables with ease
Skills covered in this course
Reviews
-
SSony Thapa
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!
-
DDallas Jurgens .
Hello, thank you for reading my comment. I did this course twice through. I found it to be highly valuable. This course is a true gem among the stones. The style is clear and engaging. This instructor is very encouraging and motivating. I actually feel better from taking this course.
-
GGan Miao Qian
The explanation is very clear and I have learn a lot of handy techniques and tips. It is great that the source is provided, so we can do practice after each module to refresh our memory. Just hope that there is transcript of video for us to download and the English subtitle can be improved. Thank you.
-
PPrakash M.S
Learn, Practice and Implement the Ultimate way to learn in short time, Just get into this right path- Excel Pivot tables
