Design a Simple Dashboard from a Task Tracker in Google Sheets

Link to sample sheet: https://docs.google.com/spreadsheets/d/1ZBiV21uyVlW4qww5V5s9AkHTi5E0Z6fDRgNSyUyECVA/edit?usp=sharing You can make a copy of the sheet and then edit it.

#googlesheetsdashboard #tasktracker #exceltasktracker #exceldashboard #googlesheetscharts #msexcel #googlesheets #excelformulasandfunctions #googlesheetsfunctions #googlesheetstasktracker #googlesheetstips #googlesheetstutorial

Design a Simple Dashboard from a Task Tracker in Google Sheets

You can also skip and go to the desired chapter from here: 00:00 Introduction 00:26 Task tracker 02:33 Adding Pivot Table 04:12 Table Chart 04:51 Bar Chart 06:00 Adding Gauge Charts 09:20 Adding Task Statuses 11:49 Add person wise reports 17:49 How to share the Dashboards ------------------------

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=arNiyCysy-I