Tags
Language
Tags
April 2024
Su Mo Tu We Th Fr Sa
31 1 2 3 4 5 6
7 8 9 10 11 12 13
14 15 16 17 18 19 20
21 22 23 24 25 26 27
28 29 30 1 2 3 4

Dashboard with Advance Pivot

Posted By: lucky_aut
Dashboard with Advance Pivot

Dashboard with Advance Pivot
Duration: 57m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 550 MB
Genre: eLearning | Language: English

Play more with Pivot by creating interactive Dashboard

What you'll learn:
Create Powerful Dashboard
Learn Advance Pivot
Slicers and building connection
Interactive and Dynamic dashboard

Requirements:
Should complete the Pivot Basic course
Check my profile and complete "Learn Pivot Tables in Excel from Scratch"

Description:
In this course, you will be guided step by step to create the beautiful and attractive dashboard using Pivot and Pivot chart option. You will also learn how to make it dynamic and interactive using slicer. Post completion of this course, you would be more powerful and confident in using Pivot tables effectively. As a bonus section, I have also included to freeze the unhide option to protect your raw data. While using the hide option, its quite easy to unhide it, but if you know how to freeze the unhide option, it makes your dashboard more safer.
I have also provided raw data excel file which is used in this curriculum and have also provided the final version of dashboard for your reference.
This course is designed using Excel 2016 and it works well for all the above version as well as 2010+. However, I would recommend to use Excel 2016 or above to learn this course
If have not completed my basic course on Pivot Table, then I would recommend you to go to my profile, and under list of courses, complete "Learn Pivot "Tables In Excel From Scratch" and then visit this section.
Happy learning and wish you good luck.
Who this course is for:
An Individual who wants to derive meaningful insights from data and make decisions

More Info