How to use EXCEL to your BENEFIT - PIVOT TABLES & CHARTS
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.
Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
"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.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Introduction to PivotTable|
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.
In this lesson we talk about different sources for Pivot Table - internal and external.
Refresh Button in Data Ribbon
Mid-course Exercise for PivotTable (1)
|Section 2: PivotTable #Tools|
PivotTable Tools - Options Menu (Part 1)
PivotTable Tools - Options Menu (Part 2)
Mid-course Exercise for PivotChart (1, 2)
PivotTable Tools - Options Menu (Part 3)
PivotTable Tools - Design Menu
|Lecture 9||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)
|Section 3: #Consolidated PivotTables|
Consolidated Single-Page Field PivotTable Report
Consolidated Multi-Page Field PivotTable Report
|Section 4: Pivot Formula and Pivot Charts|
=GETPIVOTDATA - Formula
Let's now talk about PIVOT CHARTS
Theory is Over next to Practice
Mid-course Exercise for PivotTable (5, 6, 7)
|Section 5: Pivot Tables & Charts - Tips & Tricks|
Count Everything using Pivot TablesPreview
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
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
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.