Brief Introduction
In-depth, crisp knowledge upgrade for those who use Pivot Tables already. Great start for those who have never used it.Description
I don't like to call it Advanced.
Why? I believe what we know is "Basic", and what we don't know (or don't want to know) is called "Advanced".
Once you know something, it becomes basic.
Many of us have been using Pivots for decades. We think we already know Pivot Table. But trust me, there is vast amount of unexplored stuff - waiting to be exploited. This is course is for those who have used Pivots and attended other Pivot Courses.
This is not a tips and tricks course. It provokes you to think, learn and apply the knowledge to your own work or business.
If you do not know Pivot tables, don't worry. This course starts from scratch and helps you become a master Pivot analyst. Those who already know Pivot Tables are in for a surprise. For example, do you know that the raw data must be an Excel table before you create a Pivot Table? Most probably, you will ask me a question: "What is an Excel table?"
Try out the free preview videos and you will notice the difference instantly.
Requirements
- Requirements
- Excel version 2007 or above.
- If you have used Pivot Tables before, this course will expose you to undiscovered gems and surprise you at every turn. What people do not realize is using pivot table everyday is not the same as knowing Pivot Table!
- If you have never used Pivot tables before, you will discover and master a very powerful tool which will help you in personal as well as professional context.
Knowledge
- Understand what is data analysis and why should we use it (in very simple, jargon-free manner)
- How to identify bad data from good data (Easy to analyze data = Good data)
- How to convert bad data to good data
- Understand the real meaning of analytics and how analytics can help you grow in your business or career
- Look at existing data as an opportunity to know more
- Deliver existing reports / MIS much faster
- Deliver much more than what is expected in terms of reports creation and submission
- Unearth new and useful information from the same familiar data
- Interpret data in a more comprehensive manner
- Understand how to simplify interpretation using data Visualization
- Understand how to handle large amount of data in Pivot Tables
- Learn a new method of generating dashboards
- Learn a revolutionary new way of sharing reports with others (including very large files)
- Learn how to improve performance of Pivot Tables
- Add value beyond your job description
- Grow faster in their career
Advanced Data Analytics & Story-Telling Techniques
- 4.4
-
![]()
![]()
![]()
![]()
![]()
Learn story-telling with data skills to derive insights from raw data using slicers, pivot-tables and graphs in Excel Hey, welcome to our latest course Advanced Data Analytics in Excel online course....
Microsoft Excel - Data Analysis with Excel Pivot Tables
- 4.6
-
![]()
![]()
![]()
![]()
![]()
Master Excel pivots & learn data analysis w/ advanced Excel cases from a top Excel & business intelligence instructor "This is a great Excel course....
Excel Crash Course: Dashboards, Data Analysis & Heatmaps
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn core, business-focused Excel skills for data analysis, data visualisation and dashboard modelling in 3 hours Maximizing office productivity is a key skill to learn....
Analyze Data to Answer Questions
- 4.6
-
![]()
![]()
![]()
![]()
![]()
This is the fifth course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs....
