Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Life Purpose Meditation Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Data Science
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Blender
30-Day Money-Back Guarantee

This course includes:

  • 5.5 hours on-demand video
  • 47 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Office Productivity Microsoft Pivot Tables

Excel Pivot Tables - beyond Advanced

In-depth, crisp knowledge upgrade for those who use Pivot Tables already. Great start for those who have never used it.
Rating: 4.1 out of 54.1 (67 ratings)
356 students
Created by Dr. Nitin Paranjape
Last updated 6/2017
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • 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

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.

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. 

Who this course is for:

  • If you have already worked on Pivot tables, you will gain most. You are revisiting Pivot Tables in this course. You will soon realize how much of precious time you have wasted in misusing Pivot Tables in the past. In addition, you will learn more capabilities which you never thought were possible using Pivot Table.
  • If you have never used pivot tables, thank your stars. You are in the right place! You are free from the bias of bad habits others have learnt. Start from scratch and become super-proficient in Excel based data analysis.
  • This course is not about just features and "advanced" capabilities. It is about building the right mindset to learn from the past in order to improve the future. Everyone who wants to build a better future can benefit from this course.

Course content

13 sections • 44 lectures • 5h 29m total length

  • Preview04:01

  • Preview07:30
  • Data Clean up
    01:48
  • Filling up Empty Cells
    06:29
  • Data Clean up using Flash Fill
    04:46
  • Converting Cross-tab to Tabular Format
    04:51
  • Preview09:16

  • Create a Simple Pivot Table
    10:04
  • Using Pivot Tables to Audit Data Quality
    07:00
  • Preview09:07
  • Create Pivot Charts to understand the data better
    06:35
  • Focused analysis using filtering
    18:25
  • Select, reorder, rename fields and items
    15:38
  • Test
    1 question

  • Categorizing text items using Grouping
    09:28
  • Preview05:07
  • Grouping by Weeks, Months, Quarters and Years
    06:20
  • Handling fiscal years which do not start in January
    08:11

  • Choosing the right summary - Sum, Count, Avg ...
    07:30
  • View Percentage of Total
    04:27
  • Preview08:19
  • Percentage of Parent total in hierarchical data
    05:23
  • Instant Running totals and Ranking
    06:06
  • The importance of the Index option
    04:08
  • Value Quiz
    1 question

  • Calculations within Pivot Tables
    06:29
  • Which field to put in which area?
    03:54
  • Preview11:26
  • The Power of Double Click! Drilldown, Lineage and more...
    03:52
  • Month on Month growth
    1 question

  • Preview07:34
  • Creating smart Pivot charts
    12:52
  • Data Visualization Primer
    10:51
  • Using Conditional Formatting with Pivot Tables
    12:30
  • Grand totals and SubTotals
    10:52

  • Subtotals and Filters Tab
    06:39
  • Layout and Print Tab
    13:41

  • Layout and Formatting tab
    05:16
  • Totals and Filters tab
    05:01
  • Display tab
    07:04
  • Printing and Alt Text tab
    05:02
  • Data tab
    06:10

  • Pivot Tables: Problems and Solutions
    03:57
  • Preview07:00

Instructor

Dr. Nitin Paranjape
Microsoft Most Valuable Professional for Office System
Dr. Nitin Paranjape
  • 4.4 Instructor Rating
  • 1,948 Reviews
  • 6,324 Students
  • 2 Courses

Microsoft’s Most Valuable Professionals for Office 

Microsoft Regional Director (honorary title)

Written 2 books and 1000+ blog articles 

Coached 273,000+ professionals in 2100+ organizations across 18 countries

Covers the entire Office 365 platform including Excel, Power BI, Exchange, Skype for business, OneDrive, SharePoint, Yammer.

My sessions are often referred to as "Magic Show" or "Eye Openers"

CEOs, CFOs and other senior leaders love my sessions and the only question they ask is "Why did I know all this earlier". They can see the loss of efficiency potential in their past lives after my session. 

Unfortunately, there is no UNDO button for past life. However, after attending my sessions, you are yourself the magician. Office is a catalyst to your growth. 

I am fully aware that nobody wants Office as their revenue mechanism. However, you must realize that irrespective of your area of specialization, most probably, you are using Office for 2 to 8 hours every day. If you do not know Office and especially Excel, your talent and expertise will not be able to express itself fully. It may even hinder your growth. 

There are thousands of experts. Most of them specialize in a particular area. In my case, I have taken a lot of effort (12 years of my life) to ensure that I understand all tools from the Office 365 platform. That knowledge coupled with hundreds of thousands of actual interactions with users gives me a unique insight into the minds of users and what technology has to offer. All this is not my achievement. It is a great platform made available to the world by Microsoft. 

Unfortunately, I don't know of a single person who has attempted to understand and utilize this powerful platform to her advantage. 

It is my passion to share what I know with the world - in a simplistic yet powerful way so that you can grow in your career and business beyond your imagination. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.