Channel | Publish Date | Thumbnail & View Count | Download Video |
---|---|---|---|
Publish Date not found | 0 Views |
DOWNLOAD the Excel file containing the finished dashboard and the steps to create it yourself: https://www.myonlinetraininghub.com/excel-project-management-dashboard
LEARN MORE
Join my Excel Dashboard course here: https://www.myonlinetraininghub.com/excel-dashboard-course
ALTERNATIVE TO SEQUENCE FUNCTION
If you do not have the SEQUENCE function, you can use two formulas instead:
Cell K5: =MIN(column start date) + output of the form control
Cell L5: =K5+1
Copy L5 across the columns as necessary.
SUBSCRIBE if you want more tips and tutorials like this one.
Please leave me a COMMENT. I read them all!
️ CONNECT with Mynda on LinkedIn: https://www.linkedin.com/in/myndatreacy/
SHARE this video and spread the love for Excel.
Or if you are short on time, please click on
EXCEL QUESTIONS: Get help in our Excel forum: https://www.myonlinetraininghub.com/excel-forum
TIME STAMP
0:00 Introduction and dashboard overview
1:34 Dashboard file structure and data
4:13 Project Summary PivotTable
7:50 Bar charts for task progress
11:45 Donut charts for task progress
14:56 Set color scheme
16:35 Budget progress charts
21:58 Slicers
24:05 Custom Chart Header
25:21 Conditional formatting in the Gantt chart
39:24 Outro
Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.