Tutorialspoint

Celebrating 11 Years of Learning Excellence! Use: TP11

MS Excel: Advanced Pivot Table Online Course

MS Excel: Advanced Pivot Table Online Course

Master all aspects of Pivot tables and dashboards in MS Excel

updated on icon Updated on Jun, 2025

language icon Language - Hindi

person icon Sujeet Kumar Advanced Excel Training In Hindi

category icon Office Productivity,Microsoft,Pivot Tables Data Analysis

Lectures -29

Duration -11.5 hours

Lifetime Access

4.4

price-loader

Lifetime Access

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

What you'll learn

  • How to create amazing looking dashboards using Pivot Tables

  • How to do a PivotTable (a quick refresher)

  • Advanced Pivot Table Method

  • Create Pivot Table with Dynamic Range

  • Advanced data analysis techniques

  • Advanced data analysis techniques

Pivot tables are a data processing technique that use statistical functions to summarize data from other tables. They allow users to expand, isolate, sum, and group data. The pivot function rotates a column into a row, aggregates values, and allows users to filter, sort, group, and create custom calculations   


Some advanced features of Excel pivot tables include:

  • Calculating the difference between columns

  • Smart custom number formatting

  • Double-clicking to view details

  • Creating custom groupings

  • Grouping date fields

    Here are some tips for using pivot tables in Excel:

    • Use the keyboard shortcut Alt + D + P to open the PivotTable and PivotChart Wizard

    • Use the keyboard shortcut Alt + N + V to quickly create a pivot table

    • Double-right click on a value inside a pivot table to see the data behind that aggregated value

    • An advanced pivot table in Excel is a way to link multiple pivot tables together so that you can filter all of them at once. This is instead of having to change the filter on each pivot table individually

    • Advanced Pivot Table Techniques You Should Know in 2024

      You can use “Data Model” feature of Excel to connect multiple tables and create pivots from them

    • Master the skills of advanced Excel including Pivot Tables with our comprehensive course. Learn to analyze, visualize data, and automate tasks

This course includes:

3 + Hours  of Videos Tutorials

Exercise files to practice what you learned


This course was recorded using Excel from Office 365. It's also relevant to those using other, recent versions of Microsoft Excel including Excel 2013, 2016, and 2019.

Goals

Learn how to use Pivot Tables in Excel as a powerful tool to effectively slice and analyze your data. This tutorial has everything covered!

Prerequisites

Familiar with Basic Excel

MS Excel: Advanced Pivot Table Online Course

Curriculum

Check out the detailed breakdown of what’s inside the course

Basic Pivot Table

8 Lectures
  • play icon 1. Data Analysis and Basic Pivot 20:20 20:20
  • play icon 2.Data Summarization with Pivot 20:25 20:25
  • play icon 3. Sorting and Moving in Pivot 12:30 12:30
  • play icon 4.Filtering Report in Pivot 13:39 13:39
  • play icon 5.Group Legend in Pivot 12:08 12:08
  • play icon 6.Project -1 Make Attendance on Bio Metric Data 20:10 20:10
  • play icon 7.Pivot Charts 20:51 20:51
  • play icon 8.Project -2 Make Sales Dashboard 29:32 29:32

Advanced Pivot Table

11 Lectures
Tutorialspoint

Pivot Dashboard

10 Lectures
Tutorialspoint

Instructor Details

Sujeet Kumar Advanced Excel Training in Hindi

Sujeet Kumar Advanced Excel Training in Hindi

I worked On Excel from 2003. I have also work more then 10 Company as MIS Executive and VBA Developer. I tried to give best in Excel . Now I work for 40 Company as Report Consultant. I give Every Example related to your work. With me you not Learn Only Excel Learn also Official Real Time Problem Solution

My Slogan - Not Do Hard Work . Do Smart Work - मेहनत तो गधा भी करता है

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515