BiggestSale: 17Courses in 3500Rs (500 Hrs), 10 Courses in 3000Rs

Excel Pivots & its Dashboards-Basic To Advance-English

Excel Pivots & its Dashboards-Basic To Advance-English

Everything you need to know about Excel Pivots. Complete Training

Created by Ajay Parmar

Material Includes

  • Files are attached for you to download

Course Description

  • A complete Training on Excel Pivots , Slicers , Pivot Charts and Dashboards, exercises and much more.
  • Deep dive into Pivot functioning by doing different level of exercises.
  • Rules to follow in Pivots – Data headers and data point layouts
  • Know the Pivot Designs, subtotal feature, Grand Total Feature, Repeat labels, Blank lines and many more.
  • Know the tabular form, compact form and others and their benefits. Shortcut keys to be used in Pivots
  • What is there in right click on pivot options – Hidden features like refresh on open, No data show, errors handling, blank data handling and many more.
  • How to summarize the data using Row or column fields – Benefits and disadvantages.
  • How to create Pivot percentage numbers and cumulative totals or comparisons in totals like may be if you want to summarize the data on process contribution over single item.
  • Ranking calculation in Pivots – its amazing
  • How to Create Slicers in Pivots and use in dashboards.
  • How to link many pivots with one single slicer only and why we should know that. Introducing the report connection. Easy and powerful.
  • How to customize the Slicers if you do not wish to use the ready made Slicer designs – its magnificent. Deep dive into slicer formatting.
  • Learn  how to use filters and slicers to make INTERACTIVE views of data without using any VBA Coding and formulas.
  • How to create formula in Pivots and how to use that.
  • Conditional Formatting in Pivots – Its amazing
  • Learn how to create Pivot Charts
  • How to create Pivot Dashboards in excel using all mentioned above features.
  • I have given you assignments also on Pivots- There are 15 exercises in the series so we can always know how much we have learnt so far. Don’t you worry, it has solutions as well explained in detail by me in the Pivot assignment section.

Course Curriculum

Training begins

  • Introduction to Pivots – Creating Pivots
    12:14
  • Subtotals, Layouts, Selecting fields to Color – Pivot Features – Deep Dive
    08:56
  • More Features – Insert Blank Lines, Item Labels, Grand Totals
    16:31
  • Sorting the Pivot Fields
    10:34
  • Identify the fields to be Sorted
    05:21
  • Date Group – Must know feature for dashboards
    21:40
  • GetPivotData function – Not many of us know this. Very Useful
    13:07
  • Calculate the Contributions on Process level, Sub Levels – Incredible Pivots
    30:29
  • More Contribution Percentages – Deep dive
    09:14
  • Calculate Difference between previous and next Fields and much more
    08:13
  • Ranking – Asc or Dsc order – Hidden Pivot feature
    06:53
  • Slicers in Pivots- Let us take a deep dive into it
    41:03
  • Sorting in SLICERS
    02:45
  • Amazing Features of SLICERS – hide or show unwanted Fields
    07:04
  • Remove Slicer field if no data available – Just loving it
    03:56
  • Design the way you want – SLICER Colors Customizations – My favorite
    03:57
  • Report Connection – Linking or de-linking of Slicer with Pivots – Must know
    11:51
  • Create Pivot Charts – For Dashboards
    36:30
  • Dashboard Making – Let us Begin
    37:02
  • Finishing the Dashboard
    29:30
  • Assignment Solutions – Refer to assignment text file for questions
    05:41
  • Assignment Discussion Continue
    14:13
  • Assignments Continues
    15:20
  • Assignments – More questions
    18:31
  • More exercises – Let us solve more questions
    10:22
  • Exercises still continues
    14:43
  • More practice More power in data analytics
    12:56
899.00
899.00 1,400.00

Excel Pivots & its Dashboards-Basic To Advance-English

899.00
899.00 1,400.00

Material Includes

  • Files are attached for you to download

Course Description

  • A complete Training on Excel Pivots , Slicers , Pivot Charts and Dashboards, exercises and much more.
  • Deep dive into Pivot functioning by doing different level of exercises.
  • Rules to follow in Pivots – Data headers and data point layouts
  • Know the Pivot Designs, subtotal feature, Grand Total Feature, Repeat labels, Blank lines and many more.
  • Know the tabular form, compact form and others and their benefits. Shortcut keys to be used in Pivots
  • What is there in right click on pivot options – Hidden features like refresh on open, No data show, errors handling, blank data handling and many more.
  • How to summarize the data using Row or column fields – Benefits and disadvantages.
  • How to create Pivot percentage numbers and cumulative totals or comparisons in totals like may be if you want to summarize the data on process contribution over single item.
  • Ranking calculation in Pivots – its amazing
  • How to Create Slicers in Pivots and use in dashboards.
  • How to link many pivots with one single slicer only and why we should know that. Introducing the report connection. Easy and powerful.
  • How to customize the Slicers if you do not wish to use the ready made Slicer designs – its magnificent. Deep dive into slicer formatting.
  • Learn  how to use filters and slicers to make INTERACTIVE views of data without using any VBA Coding and formulas.
  • How to create formula in Pivots and how to use that.
  • Conditional Formatting in Pivots – Its amazing
  • Learn how to create Pivot Charts
  • How to create Pivot Dashboards in excel using all mentioned above features.
  • I have given you assignments also on Pivots- There are 15 exercises in the series so we can always know how much we have learnt so far. Don’t you worry, it has solutions as well explained in detail by me in the Pivot assignment section.

Course Curriculum

Training begins

  • Introduction to Pivots – Creating Pivots
    12:14
  • Subtotals, Layouts, Selecting fields to Color – Pivot Features – Deep Dive
    08:56
  • More Features – Insert Blank Lines, Item Labels, Grand Totals
    16:31
  • Sorting the Pivot Fields
    10:34
  • Identify the fields to be Sorted
    05:21
  • Date Group – Must know feature for dashboards
    21:40
  • GetPivotData function – Not many of us know this. Very Useful
    13:07
  • Calculate the Contributions on Process level, Sub Levels – Incredible Pivots
    30:29
  • More Contribution Percentages – Deep dive
    09:14
  • Calculate Difference between previous and next Fields and much more
    08:13
  • Ranking – Asc or Dsc order – Hidden Pivot feature
    06:53
  • Slicers in Pivots- Let us take a deep dive into it
    41:03
  • Sorting in SLICERS
    02:45
  • Amazing Features of SLICERS – hide or show unwanted Fields
    07:04
  • Remove Slicer field if no data available – Just loving it
    03:56
  • Design the way you want – SLICER Colors Customizations – My favorite
    03:57
  • Report Connection – Linking or de-linking of Slicer with Pivots – Must know
    11:51
  • Create Pivot Charts – For Dashboards
    36:30
  • Dashboard Making – Let us Begin
    37:02
  • Finishing the Dashboard
    29:30
  • Assignment Solutions – Refer to assignment text file for questions
    05:41
  • Assignment Discussion Continue
    14:13
  • Assignments Continues
    15:20
  • Assignments – More questions
    18:31
  • More exercises – Let us solve more questions
    10:22
  • Exercises still continues
    14:43
  • More practice More power in data analytics
    12:56