How to use EXCEL to your BENEFIT - PIVOT TABLES & CHARTS
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,635 students enrolled
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

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.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,635 students enrolled
Last updated 1/2016
English
Learn Fest Sale
Current price: $10 Original price: $40 Discount: 75% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
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
Requirements
  • Open a blank MS Excel and be ready to the most efficient route to Pivot tools
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!

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
04:35

Refresh Button in Data Ribbon
1 question

Mid-course Exercise for PivotTable (1)
07:12
+
PivotTable #Tools
7 Lectures 39:16
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

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)
08:11
+
#Consolidated PivotTables
2 Lectures 14:45
Consolidated Single-Page Field PivotTable Report
07:22

Consolidated Multi-Page Field PivotTable Report
07:23
+
Pivot Formula and Pivot Charts
4 Lectures 35:06
=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
+
Pivot Tables & Charts - Tips & Tricks
6 Lectures 38:10

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
About the Instructor
Anar Heydarli, ACCA
4.5 Average rating
95 Reviews
1,972 Students
4 Courses
viralACCA.com

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