How to Design an interactive Excel dashboard using Pivot Table Slicers - Step by step video

In this video, you will learn how you can transform your Excel task tracker into a dashboard with slicers using Pivot Tables.

Download the sample dashboard from this link: https://drive.google.com/file/d/1gleJ7fHIRBNksIBxSLz2JXuZEdNACiks/view?usp=sharing

Video Chapters: 00:00 Introduction 00:51 The Task Tracker Details 02:37 Create a Pivot table 04:37 Formatting the Pivot Table 05:53 Adding conditional formatting Bars 07:10 Adding Pivot Table Slicers 09:39 Team-member reports 15:51 Add graphs for team-member reports 16:55 Project-wise dashboards

Check more excel dashboard tutorials using this link: https://www.youtube.com/watch?v=xVhcQNRs-UA&list=PLRJY-_DDvSgIlLZuhQuwFFA6OPBjNyxvQ

Subscribe to the channel at: http://www.youtube.com/user/excelissimple?sub_confirmation=1

#exceldashboard #exceltasktracker #excelformulasandfunctions #exceldashboarddesign

------------------------

Welcome to Excel is Simple. A place where excel is taught in the dumbest possible way. You will find every type of excel tutorial; excel 2013 tutorial for beginners, excel 2010 tutorial for beginners, excel formulas and functions, excel pivot table tutorial, excel vlookup. Aptly this is one place which has all excel tutorial for beginners. Subscribe to my channel at http://www.youtube.com/user/excelissimple?sub_confirmation=1 Want some focused playlists. Click here and lean back: The IF formula explained: https://www.youtube.com/playlist?list=PLRJY-_DDvSgK7khaQJLqhry-PELQ0hLTe All excel formulas in one place: https://www.youtube.com/playlist?list=PLRJY-_DDvSgKsM7G8qQEAa3oWLDCUn401 Excel basics if you have just started: https://www.youtube.com/playlist?list=PLRJY-_DDvSgLUOnfRBwVQYZVVzOxaVz76

Share, like and post any questions on the videos ... https://www.youtube.com/watch?v=MArcLLrQS1Q