Excel Pivots & Dashboards (Basic to Advanced Course)
Everything you need to know about Excel Pivots. Complete Training
Office Productivity,Microsoft,Pivot Tables
Lectures -28
Resources -6
Duration -7 hours
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
This course has 7 sections to give you 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 maybe if you want to summarize the data on process contribution over single item.
Ranking calculation in Pivots - it's 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 - it's 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 a formula in Pivots and how to use that.
Conditional Formatting in Pivots - It's amazing
Learn how to create Pivot Charts
How to create Pivot Dashboards in Excel using all the above-mentioned 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 worry, it has solutions as well explained in detail by me in the Pivot assignment section.
Goals
Take your data analysis talent from ZERO level to PROFESSIONAL level with Excel Pivot Tables.
Learn to use the most POWERFUL tool in Excel to easily summarize and create fantastic reports.
Excel Pivots from Basic to Super Advance Level - Covering everything about Pivots.
If you have always wanted to analyze & summarize data in seconds, then this is the right course.
You will learn how to Create Dashboards, Slicers, Pivot amazing features and so much. Please check the course curriculum for more details.
Prerequisites
Microsoft Excel 2010-2021 or Office 365 - Perfect choice For Windows users.
Mac users are welcome, but please make a note that the Pivot Table interface varies across platforms.
Need to know Basic Excel and Basic Charts for one of the topics in this course called Pivot Charts.
![Excel Pivots & Dashboards (Basic to Advanced Course) Excel Pivots & Dashboards (Basic to Advanced Course)](https://d3mxt5v3yxgcsr.cloudfront.net/courses/18556/course_18556_image.jpg)
Curriculum
Check out the detailed breakdown of what’s inside the course
Training Begins
28 Lectures
-
Introduction to Pivots – Creating Pivots 12:13 12:13
-
Subtotals, Layouts, Selecting fields to Color – Pivot Features – Deep Dive 08:55 08:55
-
More Features – Insert Blank Lines, Item Labels, Grand Totals 16:30 16:30
-
Sorting the Pivot Fields 10:33 10:33
-
Identify the fields to be Sorted 05:21 05:21
-
Date Group – Must know feature for dashboards 21:39 21:39
-
GetPivotData function – Not many of us know this. Very Useful 13:07 13:07
-
Calculate the Contributions on Process level, Sub Levels – Incredible Pivots 30:28 30:28
-
More Contribution Percentages – Deep dive 09:14 09:14
-
Calculate Difference between previous and next Fields and much more 08:13 08:13
-
Ranking – Asc or Dsc order – Hidden Pivot feature 06:53 06:53
-
Slicers in Pivots- Let us take a deep dive into it 41:02 41:02
-
Sorting in SLICERS 02:45 02:45
-
Amazing Features of SLICERS – hide or show unwanted Fields 07:03 07:03
-
Remove Slicer field if no data available – Just loving it 03:56 03:56
-
Design the way you want – SLICER Colors Customizations – My favorite 24:59 24:59
-
Report Connection – Linking or de-linking of Slicer with Pivots – Must know 11:50 11:50
-
Create Pivot Charts – For Dashboards 36:29 36:29
-
Dashboard Making – Let us Begin 37:01 37:01
-
Finishing the Dashboard 29:30 29:30
-
Assignment Solutions – Refer to assignment text file for questions 05:40 05:40
-
Assignment Discussion Continue 14:12 14:12
-
Assignments Continues 15:20 15:20
-
Assignments – More questions 18:30 18:30
-
More exercises – Let us solve more questions 10:22 10:22
-
Exercises still continues 14:42 14:42
-
More practice More power in data analytics 12:56 12:56
-
Resources
Instructor Details
![ajay parmar](https://www.tutorialspoint.com/assets/profiles/392043/profile/200_1105481-1637139304.jpg)
ajay parmar
Course Certificate
Use your certificate to make a career change or to advance in your current career.
![sample Tutorialspoint certificate](/market/public/assets/newDesign/img/primePacks/V-certificate.png)
Our students work
with the Best
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfc bank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
![adobe logo](/market/public/assets/newDesign/img/adobe.png)
![adp logo](/market/public/assets/newDesign/img/adp.png)
![apple logo](/market/public/assets/newDesign/img/apple.png)
![armani logo](/market/public/assets/newDesign/img/armani.jpg)
![bosch logo](/market/public/assets/newDesign/img/bosch.png)
![capegemini logo](/market/public/assets/newDesign/img/capegemini.png)
![cisco logo](/market/public/assets/newDesign/img/cisco.png)
![hdfcbank logo](/market/public/assets/newDesign/img/hdfcbank.png)
![ibm logo](/market/public/assets/newDesign/img/ibm.png)
![intel logo](/market/public/assets/newDesign/img/intel.png)
![mastercard logo](/market/public/assets/newDesign/img/mastercard.png)
![netflix logo](/market/public/assets/newDesign/img/netflix.png)
![qualcomm logo](/market/public/assets/newDesign/img/qualcomm.png)
![samsung logo](/market/public/assets/newDesign/img/samsung.png)
![sony logo](/market/public/assets/newDesign/img/sony.png)
![unilever logo](/market/public/assets/newDesign/img/unilever.png)
![walmart logo](/market/public/assets/newDesign/img/walmart.png)
Related Video Courses
View MoreAnnual 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 Annual Membership](/market/public/assets/newDesign/img/membership-large-small.jpg)
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now![Online Certifications Online Certifications](/market/public/assets/newDesign/img/traning-for-a-team.png)