Excel Pivots & Dashboards (Basic to Super Advance)

Name: Excel Pivots & Dashboards (Basic to Super Advance)
Rating: 4.1 (12 reviews)

Data Analysis, Summary Reports, Dashboards using Advance Pivots - Super Advance knowledge coming in your way.

Created byajay parmar

Last updated 2/2023

English

English [Auto],

What you'll learn

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 every thing 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. Pls check the course Curriculum for more details

Course content

7 sections • 29 lectures • 7h 14m total length

A quick demo- What you are going to Learn3:05
Learn to master Excel pivots and dashboards from basics to advanced, including pivot features, layout options, subtotal, contribution reports, ranking, data analysis, and creating slice-based dashboards.
Introduction to Pivots - Creating Pivots12:13
This section teaches us how to create the pivots reports and about the 4 pivot sections

Subtotals, Layouts, Selecting fields to Color - Pivot Features - Deep Dive8:55
Learn to create pivot tables in Excel, add category, manufacturer, item name, and cost, apply subtotals and layouts, color headers, and switch between compact and outline forms for year‑wise dashboards.
More Features - Insert Blank Lines, Item Labels, Grand Totals16:30
Sorting the Pivot Fields10:33
Learn to sort pivot table data, using descending and alphabetical orders, and create custom sort lists to control how fields appear.
Identify the fields to be Sorted5:21
Date Group - Must know feature for dashboards21:39
GetPivotData function - Not many of us know this. Very Useful13:07

Calculate the Contributions on Process level, Sub Levels - Incredible Pivots30:28
More Contribution Percentages - Deep dive9:14
Calculate Difference between previous and next Fields and much more8:13
Ranking - Asc or Dsc order - Hidden Pivot feature6:53
Explore ranking in Excel pivots, using ascending or descending order, with hidden pivot features, and understand cumulative totals, percentage of running total, and category context effects.

Assignment Solutions - Refer to assignment text file for questions5:40
Question asked :Crete a report which shows top and bottom 3 performers in quantity field
but remember with quantity we should see CP and SP also.
Assignment Discussion Continue14:12
Assignments Continues18:30
Master pivot table grouping by date, month, and quarter; troubleshoot missing data and use time intelligence to analyze quarterly performance across category and subcategory.
Assignments - More questions15:20
Explore building and formatting slicers in Excel pivots, create calculated fields for total expenditure by multiplying quantity by gold price, customize selected and unselected item visuals, and practice through assignments.
More exercises - Let us solve more questions10:22
Explore hands-on data analysis with pivot tables and filters to identify items whose average quantity exceeds a threshold over the last three years, exclude zeros, and interpret performance.
Exercises still continues14:42
Create and format a pivot by zone and month, apply currency formatting, and build dashboards with frozen headers, slicers, and clear naming for easy data exploration.
More practice More power in data analytics12:56
My other Courses with links1:56

Requirements

Microsoft Excel 2010-2021 or Office 365 - Perfect choice For Window 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 of Charts for one of the topic in this course called Pivot Charts.

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 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.

Who this course is for:

All those students who take a keen interest in Data Analysis , want to create excel reports, produce one click summary reports.
Those who know basic or advance excel but do not know Pivots in-depth. You dont need to be an expert in excel to start this course. Just that you have to be data enthusiastic
Professionals who want to pursue a career in data analysis or business intelligence

Excel Pivots & Dashboards (Basic to Super Advance)

What you'll learn

Explore related topics

Course content

Introduction to PIVOTS - Let us Begin from Basics2 lectures • 15min

Most important and Used Pivot Features for Data Analysis & Reporting6 lectures • 1hr 16min

Calculate Percentages of one item over others - Hidden Features to be explored4 lectures • 55min

Pivot SLICERS - Game Changing factor6 lectures • 1hr 32min

Pivot CHARTS - Graphs are possible in Pivots1 lecture • 36min

Make Dashboards now -Finally wait is over & time to implement everything learnt2 lectures • 1hr 7min

Time to Check your Scorecard by doing these Assignments-Solutions given also8 lectures • 1hr 34min

Requirements

Description

Who this course is for: