Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add How to use EXCEL to your BENEFIT - PIVOT TABLES & CHARTS to your Wishlist.

Add to Wishlist


Without any books and terms and formulas, JUST REAL WORK EXPERIENCE! Pivot any data and save your precious time.
4.6 (7 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.
1,633 students enrolled
Last updated 1/2016
$10 $40 75% off
1 day left at this price!
30-Day Money-Back Guarantee
  • 2.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Spend 70% LESS TIME thus to save 70% MORE TIME FOR PERSONAL LIFE
"It takes one minute to build, and saves hours of work" - recent quote by one of my top performing students
Transfer any data into PivotTable/Chart faster and more efficiently than anyone else
Handle complex tasks using the attached Excel workbooks
Throw bulk of data from place to place discovering patterns and trends that are not visible from Excel tables
Amaze everyone with the fastest skills to handle the data
Make never seen presentations within Excel using PivotTables and PivotCharts
Work independently and come up with new solutions to a given problem
View Curriculum
  • Open a blank MS Excel and be ready to the most efficient route to Pivot tools

"Pivot Tables and Pivot Charts have helped me save loads of time when dealing with data in Excel and from other sources" - a recent feedback from a student.

I believe that most part of what I learned came from real life experiences. Working in a professional services firm required an extensive use of MS Excel - lots of formulae, tons of tables, thousands of charts and the list goes on. On the bright side, all this load makes you figure your way out of lengthy and enormous tasks.

This is where PIVOT TABLE & PIVOT CHART came for help.

Pivot tools in MS Excel assist us on handling big data, discovering hidden trends, and delivering amazingly professional presentations.

I did my best to build this course following my own learning format. No Books, No formulas, No lengthy talks - JUST THE DOING!

This course is designed to promote the strength of PIVOT tools in Excel and assist every student to quickly get into the DOING!

No need to worry about the new tools, there are dozens of examples, a number of solutions to problems I faced myself - all of which are ATTACHED TO THE CURRICULUM in order to make the course as smooth as possible.

Good luck!

Who is the target audience?
  • This course is designed to start you off from not knowing Pivot Tools to its expert. It is also very useful for students who are looking for a deeper insights into Excel functionality. Very useful tips are presented no matter in which area you are going to apply this course. Handling data becomes very easy upon completion of this course.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 22 Lectures Collapse All 22 Lectures 02:23:55
Introduction to PivotTable
3 Lectures 16:38

What is Pivot Table? How can it make our excel lives easier? Get an introduction to Pivot Table and let's see what we can expect from it.

Preview 04:51

In this lesson we talk about different sources for Pivot Table - internal and external.

Understanding Data Sources for PivotTables

Refresh Button in Data Ribbon
1 question

Mid-course Exercise for PivotTable (1)
PivotTable #Tools
7 Lectures 39:16
PivotTable Tools - Options Menu (Part 1)

Shortcut quiz
1 question

PivotTable Tools - Options Menu (Part 2)

1 question

Mid-course Exercise for PivotChart (1, 2)

PivotTable Tools - Options Menu (Part 3)

PivotTable Tools - Design Menu

What I want you to do in this exercise is to prepare 2 Pivot tables showing the below information:

1) Should show # of Drama movies in by all stores

2) Should show the percentage of Childrens movies compared to the total movies by all stores

A new exercise released!
10.3 kB

Mid-course Exercise for PivotTable (2, 3, 4)
#Consolidated PivotTables
2 Lectures 14:45
Consolidated Single-Page Field PivotTable Report

Consolidated Multi-Page Field PivotTable Report
Pivot Formula and Pivot Charts
4 Lectures 35:06

Let's now talk about PIVOT CHARTS

Theory is Over next to Practice

Mid-course Exercise for PivotTable (5, 6, 7)
Pivot Tables & Charts - Tips & Tricks
6 Lectures 38:10

Very few know it - The Secret Link between Tables and PIVOT Tables

Number grouping in Pivot Tables

Setting the problem - Loan Portfolio - Part 1

Setting the problem - Loan Portfolio - Part 2

Disclosure 1 - Problem Solution
About the Instructor
4.5 Average rating
95 Reviews
1,965 Students
4 Courses

Azərbaycanca aşağıda

ACCA has been ruling around for over a century now, and it is getting more and more common to see job requirements pointing to ACCA qualification. Basically, it is a standard of today. However, getting through all required 14 exams of the qualification is one big decision to make and needs persistent motivation to finalise.

My name is Anar and I have over 5 years of professional experience in one of the world´s leading professional services firm as an ACCA qualified public accountant. I finalise my ACCA qualification in October 2013, after two and a half of years of consistent learning.

Below are some of my nominations to highlight:

- ACCA Top affiliate - 42nd worldwide place (out of over 50,000 professionals)
- ACCA P4 - Advanced Financial Management, 11th worldwide place (out of over 50,000 professionals)
- ACCA P7 - Advanced Audit and Assurance, 19th worldwide place (out of over 50,000 professionals)
- ACCA P1 - Governance, Risk and Ethics, 10th worldwide place (out of over 50,000 professionals)

With over 4 years of successful ACCA teaching I now offer my experience to the students worldwide.

My expertise area includes:

- Advanced Excel Skills
- Financial Accounting +5 years of practical experience
- Management Accounting +5 years of practical experience
- Performance Management
- (Advanced) Financial Reporting +5 years of practical experience
- Corporate Reporting
- (Advanced) Audit and Assurance +5 years of practical experience
- (Advanced) Financial Management +5 years of practical experience
- Corporate Governance and Risk +5 years of practical experience
- Business Analysis

You can ask me any question via Udemy discussion forum in my courses

Best regards,


ACCA artıq hər gün daha da geniş yayılır və indi daha çox iş elanlarında ACCA tələbini görmək mümkündür. Bu artıq standart halını alıb. Lakin, bütün bu 14 imtahana hazırlaşmaq olduqca ciddi fikirləşilməsi lazım olan bir qərardır.

Mənim adım Anardır və ACCA kvalifikasiyamı 2013-cü ilin Oktyabrında almışam. Bununla belə 4 ildən artıqdır ki, ACCA treyninqləri deməklə təcrübə qazanmışam.

Mənə hər hansı sualınız olarsa buyurub verə bilərsiniz.



Report Abuse