How to use EXCEL to your BENEFIT - PIVOT TABLES & CHARTS

Without any books and terms and formulas, JUST REAL WORK EXPERIENCE! Pivot any data and save your precious time.
4.8 (6 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,630 students enrolled
$19
$40
52% off
Take This Course
  • Lectures 22
  • Length 2.5 hours
  • 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 10/2014 English

Course Description

"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!

What are the requirements?

  • Open a blank MS Excel and be ready to the most efficient route to Pivot tools

What am I going to get from this course?

  • 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

What 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.

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

Section 1: Introduction to PivotTable
04:51

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.

04:35

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

Refresh Button in Data Ribbon
1 question
Mid-course Exercise for PivotTable (1)
07:12
Section 2: PivotTable #Tools
PivotTable Tools - Options Menu (Part 1)
06:32
Shortcut quiz
1 question
PivotTable Tools - Options Menu (Part 2)
07:46
Slicers
1 question
Mid-course Exercise for PivotChart (1, 2)
04:42
PivotTable Tools - Options Menu (Part 3)
05:56
PivotTable Tools - Design Menu
06:09
10.3 kB

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

Mid-course Exercise for PivotTable (2, 3, 4)
08:11
Section 3: #Consolidated PivotTables
Consolidated Single-Page Field PivotTable Report
07:22
Consolidated Multi-Page Field PivotTable Report
07:23
Section 4: Pivot Formula and Pivot Charts
=GETPIVOTDATA - Formula
09:26
Let's now talk about PIVOT CHARTS
20:01
Theory is Over next to Practice
00:46
Mid-course Exercise for PivotTable (5, 6, 7)
04:53
Section 5: Pivot Tables & Charts - Tips & Tricks
Count Everything using Pivot Tables
Preview
10:39
Very few know it - The Secret Link between Tables and PIVOT Tables
02:34
Number grouping in Pivot Tables
03:24
Setting the problem - Loan Portfolio - Part 1
08:13
Setting the problem - Loan Portfolio - Part 2
03:41
Disclosure 1 - Problem Solution
09:39

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

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.

Hörmətlə,

Anar

Ready to start learning?
Take This Course