Excel Data Analytics

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

What you will learn

  • Introduction Of Data Analytics
  • Introduction Of Pivot Table & Pivot Charts
  • The Five Steps For Data Analytics With Pivot Tables & Pivot Charts
  • Format The Raw Data For Pivot Tables
  • Convert The Raw Data To Table
  • Create The Pivot Tables
  • Create Recommended Pivot Tables
  • Change Pivot Table Name & Design
  • Work With Pivot Table Builder
  • Clearing & Reapplying Pivot Table
  • Copy , Move And Delete The Pivot Table
  • Creating Groups In Pivot Table
  • Custom Calculation In Pivot Table
  • Sorting , Filtering In Pivot Table
  • Working With Slicer
  • Update The Data In Pivot Table
  • Create The Pivot Charts
  • Change Pivot Charts Name & Design
  • Create Line Charts
  • Create Bar Charts
  • Create Column Charts
  • Create Pie Charts
  • Insert Slicers & Connect With Reports
  • Analysis Pivot Table & Pivot Charts
  • Create Dynamic Pivot Table And Pivot Charts Based On Our Needs And Wants

What Will You Learn?

  • Excel Pivot Tables & Pivot Charts are an absolutely Fundamental tool for anyone working with data in Excel.
  • This course gives you a deep & comprehensive understanding of Excel Pivot Tables and Excel Pivot Charts.

Course Content

Section 1: Introduction

  • Introduction Of Data Analytics
    05:32
  • Introduction Of Pivot Table And Pivot Charts
    05:35

Section 2: The Five Steps For Data Analytics With Pivot Tables And Charts

Section 3: Pivot Table & Pivot Chart Example-01

Section 4: Format The Raw Data For Pivot Tables

Section 5: Convert Raw Data To Table

Section 6: Create Pivot Table

Section 7: Create Pivot Chart

Section 8: Analysis The Pivot Table & Pivot Charts

Section 9: Pivot Table & Pivot Chart Example-02

Student Ratings & Reviews

No Review Yet
No Review Yet