Tutorial to create an Excel Task Tracker, Dashboard and Charts - Excel Project Management

Download the sample spreadsheet from the link here: https://drive.google.com/file/d/0ByEbABzPDhXIRWFRREVNVTk1anc/view?usp=sharing

Chapters in the video: 00:00 Introduction 00:20 Task Tracker columns 01:57 Adding tables for validations 03:11 Formulas in the task tracker 05:01 Automatic updating status 08:58 Creating Dashboards from Task Tracker 15:32 Creating charts for the Dashboards

Check this step by step tutorial for a task tracker or to-do list. It will also guide you to create dashboards, reports, and charts easily.

#exceltasktracker #exceldashboard #excelreports #excelcharts #excelprojectmanagement

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

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=TQ9pxhYtnjY