Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
34 Videos (1h 53m)
    • Fomat Source Datahigh

      4:04
    • Create First Pivot Table

      4:06
    • Recommanded Pivot Table Format

      2:34
    • Re arrangement of Pivot Table Format

      2:15
    • Configure Field Header

      1:51
    • Connect with External Data

      3:28
    • Consolidating Data

      4:51
    • Managing Pivot Tables

      2:10
    • SubTotal and GrandTotal

      4:25
    • Format Values of Summary

      5:04
    • More than one Field

      2:58
    • Calculated Field

      4:03
    • Grouping Pivot Table

      2:27
    • 0301 Sorting Data

      3:07
    • 0302 Sort Data custom List

      3:39
    • 0303 Filter by selection

      2:21
    • 0304 Filter by Rules

      2:04
    • 0305 Filter data by search option

      2:46
    • 0306 Slicer

      3:45
    • 0401 Pivot Table Styles

      2:20
    • 0402 Pivot Table Styles SElfmade

      2:59
    • 0403 Report Layout

      3:37
    • 0501 Conditional Formatting

      3:22
    • 0502 Highlight Top Values

      5:35
    • 0503 Databar

      4:02
    • 0504 Color Scales

      2:41
    • 0505 icon highlight

      2:16
    • 0506 Edit n Clear Rules

      3:42
    • 0601 Creating Pivot Chart

      2:31
    • 0602 Chart

      2:41
    • 0603 Formatting Chart

      3:42
    • 0604 Layout of pivot chart

      2:17
    • 0605 Change chart type

      2:19
    • 0701 Printing pivot table

      7:26

About This Class

Pivot Table is very important and good feature in Microsoft Excel 2013. You can use pivot to make summary of large data in few clicks. Pivot Table can automatically sort, count, total or give the average of the data stored in one table or spreadsheet of MS Excel, displaying the results in a second table showing the summarized data. You can create dynamic reports by dragging & dropping the field heading of table.

I have been working in excel for more than 15 years and use PivotTable everyday to make MIS (Management information System) and dynamic reports. I put all my experience to create this course. 

We will start learning from basics of PivotTable, end with Advance Techniques for using pivot table. I will also explain some hidden features of pivot table with some practical examples for your practice.

This course is good for 

  • Students / Freshers graduates from any stream (Commerce, Engineer, Doctor etc.)
  • Working professionals can increase their productivity
  • Anyone who wants to make his / her career in MIS & Analytics of data

2

Students

--

Projects

0

Reviews (0)

Naveen Bhardwaj

Mechanical Engineer with specialization in CAD/CAM

My name is Naveen and i am a mechanical engineer.

i work as a senior CAD engineer in product design and developement department.

I have work experience on different CAD softwares and i also provide training of these softwares .

in all course ,i have given more emphasis on teaching real life skills that are essential for progressing in today's commercial environment.

See full profile

Business Finance