Interactive Excel Project Management Dashboard - FREE Download
Step by step tutorial on how to build an interactive Excel project management dashboard.
🔻 DOWNLOAD the Excel file containing the completed dashboard and steps for building it yourself: https://www.myonlinetraininghub.com/e...
🎓 LEARN MORE
Join my Excel Dashboard course here: https://www.myonlinetraininghub.com/e...
ALTERNATIVE TO SEQUENCE FUNCTION
For those who don't have the SEQUENCE function, you can use two formulas instead:
Cell K5: =MIN( start date column ) + output of form control
Cell L5: =K5+1
Copy L5 across columns as far as required.
🔔 SUBSCRIBE if you’d like more tips and tutorials like this.
💬 Please leave me a COMMENT. I read them all!
🧟♀️ CONNECT with Mynda on LinkedIn: / myndatreacy
🎁 SHARE this video and spread the Excel love.
Or if you’re short of time, please click the 👍
💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/e...
⏲ TIMESTAMPS
0:00 Introduction & Dashboard Overview
1:34 Dashboard File Structure & Data
4:13 Project Summary PivotTable
7:50 Task Progress Bar Charts
11:45 Task Progress Doughnut Charts
14:56 Set Color Scheme
16:35 Budget Progress Charts
21:58 Slicers
24:05 Custom Chart Header
25:21 Conditional Formatting Gantt Chart
39:24 Outro
Watch video Interactive Excel Project Management Dashboard - FREE Download online without registration, duration hours minute second in high quality. This video was added by user MyOnlineTrainingHub 24 March 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,273,458 once and liked it 40 thousand people.