Project Management Mastery

24:17

Build an Excel Task List Summary for Activities or Projects, Project Management Dashboard RAG Status

Күн бұрын

8:27

Change the Design of Excel Dashboards - 3 ways to change the Page Layout of your Excel Task List

14 күн бұрын

15:20

STEP by STEP: Excel Habit Tracker | 3 Categories | Automated Coloring

28 күн бұрын

11:12

Demo: Attendance & Leave Tracker / Sheets | Excel Template

Ай бұрын

1:13:11

STEP by STEP: Build a Powerful Excel Dashboard for Project/Task/Activities & Resource Management

Ай бұрын

35:12

STEP by STEP: Simple Sales Dashboard in Excel by Year and Segment

2 ай бұрын

30:21

Map & Compare Sales Data Across Regions in Excel (Template)- Excel How to and tutorial

2 ай бұрын

37:42

STEP by STEP Complete Invoice Printing System with Excel | Client and Product List

2 ай бұрын

22:22

Build Your Tasks/Project Budget Dashboard in Excel: Example - with Summary and Charts

2 ай бұрын

7:32

Tried and Tested Questions (2024) and What to Say for your Management interview

2 ай бұрын

52:21

STEP by STEP Excel Kanban, Task or Activity Board | Agile Scrum Project Tasks

2 ай бұрын

30:22

Create an Issue List in Excel | Issue Management for Project Management } Issue Log creation

3 ай бұрын

34:23

How to build an Automated Excel Program Dashboard or Report | Program Reporting |

3 ай бұрын

41:57

STEP by STEP Task, Project or Goals Simple EXCEL Dashboard | Agile | Management

3 ай бұрын

9:55

STEP by STEP Task tracking Create a Waffle Dashboard in EXCEL | Project Management

3 ай бұрын

43:37

Smart Excel To Do List with Backlog Management | Step by Step Excel tutorial | Planner #exceltips

3 ай бұрын

1:56

YouTube Channel(s) Introduction | Project Management Excel and Coaching

3 ай бұрын

27:25

Scheduling with Excel vs the Expense of Microsoft Project | Functionality Demo

4 ай бұрын

9:19

Top 3 Things Interviewers REALLY Want to Know (2024 Beyond Clichés) | Project Management

4 ай бұрын

24:19

EXCEL Project Dashboard / Report overview | Project Management Template walkthrough

4 ай бұрын

25:54

Step by Step Multi Tasks/Projects Tracking | Project Management and Task Management | Task List

4 ай бұрын

36:35

STEP by STEP Simple but Powerful Resource Allocation Planner for Tasks and Projects

4 ай бұрын

8:14

End to End Project Management Process in 6 minutes | Replace Prince2 & PMP | Risk and Issue Mgt

5 ай бұрын

4:18

MS Project Gantt Chart Intro | Simple Example for a Quick Overview

5 ай бұрын

43:40

EASY Step by Step Excel Task or Activity List | Project Management Dashboard

5 ай бұрын

5:30

Decoding Earned Value in Project Management: Simple Example & Visualization (2024 Guide)

5 ай бұрын

17:36

STEP by STEP Excel Task List with Resource Pics | Task Project Categories Status and Resourcing

6 ай бұрын

10:05

The 9 habits You Need to Track | Simple Project Management Hack! Level Up (Excel, Google Sheets...)

6 ай бұрын

6:45

What I Learned from my 1st 1000 Subs | YouTube, Excel and Project Management Experience.

6 ай бұрын

Пікірлер

@nickvandernet Күн бұрын

Brilliant, thank you. That was very good.

@ProjectManagementMastery 10 сағат бұрын

Thank for the feedback!

@divya1115 2 күн бұрын

I am trying to ge the work left populated as guided by you, bit its not just happening, not sure where Am I going wrong 😢

@ProjectManagementMastery 2 күн бұрын

Hi - It's hard to assess without seeing hat you're doing but the work left is (total work) less (total work * Completion %) =H12-(H12*J12)...

@batsaikhanbatmunkh6547 8 күн бұрын

thank you for the wonderful tutorial. Finish day calculation formula was not correct in my guess. Because if WORKDAY(J6-1,C6)-1 is sunday then it is become weekend. How about =IF(Weekend_work="No",WORKDAY(J6-1,C6),J6+C6).

@ProjectManagementMastery 8 күн бұрын

Cheers! Yes that rings a bell, I think there is another comment on this. THhe latest version has =IF(Weekend_work="N",WORKDAY(J6,C6)-1,J6+C6-1) and the note in the instructions. "Please note that when a task completes a Friday night - and there is no weekend work, the system puts the completion date on a Sunday night. This is to allow the Gantt chart to calculate properly the After Date - as in fact it positions itself the day before the next working day."

@jayprox4887 9 күн бұрын

Hi, I follow as per your video and have error (#name?). =IFS(J11=1,"Completed",ISBLANK(F11),"",I11<$D$16,"Late",J11=0,"Not Started",J11>0,"In progress") Please help😃

@ProjectManagementMastery 9 күн бұрын

@jayprox4887 Hi! Well that's odd, I just copied that in a blank excel and it works... Are you sure you have a recent version of Excel that can use IFS...???

@jayprox4887 8 күн бұрын

@@ProjectManagementMastery oh i see..i used excel 2010....thanks for the reply

@ProjectManagementMastery 8 күн бұрын

You can still do it with embedded several IF though...

@ProjectManagementMastery 8 күн бұрын

@jayprox4887 This is what Gemini gave me =IF(J11=1,"Completed",IF(ISBLANK(F11),"",IF(I11<$D$16,"Late",IF(J11=0,"Not Started","In progress"))))

@jayprox4887 4 күн бұрын

@@ProjectManagementMastery Thank you so much Sir

@Vishwesh2680 12 күн бұрын

Thank you sir, very good insight. I am wondering how did you get Late value. I have added the formula, however it seems Late is not coming up

@ProjectManagementMastery 12 күн бұрын

Hi - Late is calculated based on the task deadline and today's date. Check today's date is correct.

@arndtbergmeister7375 14 күн бұрын

Great video, like it very much. One thing for the high prio pie chart. I would prefer to combine time spent and work left (eq 100%) instead of a combination of total work and time spent, whichs ends up with more than 100%.

@ProjectManagementMastery 13 күн бұрын

@arndtbergmeister7375 Thanks for the tip and for the way you brought it, wish everyone was like you on the web! You are right, the Time spent vs Total work can be improved, I'm thinking more with % Completion then for a quick visual...

@joanbrodbeck3919 17 күн бұрын

Thank you Ben and yes I stuck it out till then end and built a resource file from you instructions. Very easily understood tutorial

@ProjectManagementMastery 16 күн бұрын

@joanbrodbeck3919 Wow thanks for the feedback and very well done!

@hanzelmalasaga3122 20 күн бұрын

I did not get the work required and the work left huhu

@ProjectManagementMastery 20 күн бұрын

Not sure what you mean...

@ShubhamYadav-nk7rh 22 күн бұрын

Sir, Thank you once again for this video. A few days back, I followed your video to create an HR Dashboard. That helped a lot. Now, taking the help from this video, I created a Resource Utility/Optimisation Tracker. The concept of Start and End buttons is a great idea, has helped me a lot to create a day-wise project/task tracker sheet for each individual candidate. Thanks again Sir. Best wishes . Namaste 🙏

@ProjectManagementMastery 22 күн бұрын

@ShubhamYadav-nk7rh Thanks for the feedback and well done for applying it!

@JohnOji-o8z 28 күн бұрын

Nice Stuff !

@ProjectManagementMastery 28 күн бұрын

Thanks for the visit

@kwezizabo6240 28 күн бұрын

This is really cool.. Please do send

@ProjectManagementMastery 28 күн бұрын

Thanks for the comment. Check your email!

@ShubhamYadav-nk7rh Ай бұрын

Sir, thank you so much for this tutorial. I followed the video step by step and could make a decent dashboard. Really grateful for this.

@ProjectManagementMastery Ай бұрын

@ShubhamYadav-nk7rh Thanks, It is very rewarding for me to hear feedback like yours!

@crazystats8401 Ай бұрын

Great product 👍👍

@ProjectManagementMastery Ай бұрын

Thanks, I love it too but I'm biased!

@garethcardus5244 Ай бұрын

Can you link this dashboard or one of the other task activity ones to the project dashboard and then subsequently the program dashboard

@ProjectManagementMastery Ай бұрын

That would be nice, but this would give us one of those 2 challenges: either too many tabs or external links which are often / always causing problems. Unless we have the project dashboard and the task list on one tab? In any case food for thoughts, (and while we're at it integrating the risk and issue lists!)

@garethcardus5244 Ай бұрын

Thanks Ben, all your videos have been so useful

@ProjectManagementMastery Ай бұрын

Glad you like them!

@susiwest Ай бұрын

Thanks Ben. So helpful :)

@ProjectManagementMastery Ай бұрын

Thanks for the feedback :-)

@DRSmicks 2 ай бұрын

The look of the colored tab is great, but the true power of a task list would be the ability to drag and drop the task from stage to stage and this appears to instead need users to both enter new tasks and change the status on the 'Step 1' white tab instead of where you'd want to stay viewing.

@ProjectManagementMastery 2 ай бұрын

Excel allows you to do things you would normally need to have a software to develop. Of course it is not perfect, specially when you do not want to have macros or VBA, but the things you can do "for free" are amazing, I find new uses everyday.

@Yun69541 2 ай бұрын

Hello, I want to buy this template

@ProjectManagementMastery 2 ай бұрын

@Yun69541 Hi. I do not have it in my shop yet but I can give you what i have if you contact me here and mention you want the template 996-22 < link removed >

@moniquelevendal4704 2 ай бұрын

Thank you very informative , just a question i do i minimise the gap between the series 4 point data lables?

@ProjectManagementMastery 2 ай бұрын

@moniquelevendal4704 Thank you! If you right click on the series and select Format Data series, it will give you the option to change the Gap Width...

@KhalidAl-Hadrami-vp3qq 2 ай бұрын

can I get the Excel template ?

@ProjectManagementMastery 2 ай бұрын

Not sure what you mean, this is MS project!

@irshadmurad 2 ай бұрын

Very nice

@ProjectManagementMastery 2 ай бұрын

Thank you sir!

@rashmiambale428 2 ай бұрын

Hi Ben, I have a corporate udemy and i am unable to find your course.

@ProjectManagementMastery 2 ай бұрын

@rashmiambale428 Hi there, I am not part of the corporate accounts, my course is only to be purchased. I have created this Free coupon for you to get it for free though.. FREEYT202405

@crazystats8401 2 ай бұрын

Oh my.... INSANE!!

@ivankulola5847 2 ай бұрын

I found this insight particularly valuable, especially the aspect of considering the interviewer's perspective. This is something we often do subconsciously after years of being interviewed but don't explicitly think about. This has reminded me of the importance of tailoring my preparation based on who I believe the interviewer will be. Knowing the interview stage, whether it's an HR screening, a technical interview with my future line manager, or a meeting with the head of programs or country director, usually helps prepare more effectively. Good Stuff!

@ProjectManagementMastery 2 ай бұрын

Sometimes they don't even tell you who is interviewing so it's good practice to ask them at the beginning of the IV!

@miniab4348 2 ай бұрын

This is so great. thanks for sharing this.

@ProjectManagementMastery 2 ай бұрын

Thanks for the feedback!

@pablojuancortez 3 ай бұрын

Looking for something like this for our R&D team, thanks for sharing!

@ProjectManagementMastery 3 ай бұрын

Any time!

@f.ssaleh5073 3 ай бұрын

Many Thanks for you❤

@ProjectManagementMastery 3 ай бұрын

@f.ssaleh5073 A pleasure thank you!

@Sh3ll834 3 ай бұрын

I'm loving this!!! Is it possible to group the colours together?

@ProjectManagementMastery 3 ай бұрын

@Sh3ll834 Thanks! If you are talking about the boards color yes you can as they are hardcoded. To group the other colors you just need to change them in the Cond formatting.

@agapenilo4375 3 ай бұрын

This is a great tutorial, however, i got lost when you started the Calculation sheet, and entered the calculations, (timestamp 29:59 - 30:04, i tried understanding it but i was unable to, may you please help with that?😢😢

@ProjectManagementMastery 3 ай бұрын

@agapenilo4375 You ask so nicely it's hard to say no. I think you are referring to this formula? "=COUNTIFS(Task_name,"<>""",Completion,"=0")" In this I check 2 things, first that there is no blank (<>"") in the task column, meaning we have a task in there, and there is another condition is that the task has not started, which translates into Completion% = 0%

@agapenilo4375 3 ай бұрын

@@ProjectManagementMastery, oh that makes sense, I did try that but I kept getting 0's, which is odd since you get a variation of numbers, Or maybe I did the Calculations sheet wrong😔

@agapenilo4375 3 ай бұрын

@@ProjectManagementMastery, oh that makes sense, I did try that but I kept getting 0's, which is odd since you get a variation of numbers, Or maybe I did the Calculations sheet wrong😔

@ProjectManagementMastery 3 ай бұрын

@agapenilo4375 I know it can be frustrating when we see a problem like this. If you want to email me what you have here, or if you get in touch I can send you a sample

@daivenotoole8300 3 ай бұрын

Thank you Sir...Very helpful

@ProjectManagementMastery 3 ай бұрын

Thanks for your comment!

@daivenotoole8300 3 ай бұрын

Insightful for presentation.🙏

@ProjectManagementMastery 3 ай бұрын

@daivenotoole8300 Yes it does not look lie Excel too much

@jubilantakku6993 3 ай бұрын

Great Content

@ProjectManagementMastery 3 ай бұрын

Thank you!

@ProjectManagementMastery 3 ай бұрын

Thank you!

@divad1214ify 3 ай бұрын

I'm curious what this would look like if you wanted to include multiple projects on the same tab with core tasks tracked below each project. I'm always on the lookout for a dashboard that allows for a higher level of project tracking that still allows me to capture some key tasks under each project. Love this tutorial!

@ProjectManagementMastery 3 ай бұрын

@divad1214ify You must be a medium of some sorts, I have a Program Dashboard coming up next week that works on a high level picking up data from a Project Dashboards like this one; kzfaq.info/get/bejne/jb12qrN41rSZoH0.html

@divad1214ify 3 ай бұрын

@@ProjectManagementMastery Love it! Keep me posted when its up! Great work

@anafrican807 3 ай бұрын

I am the biggest fan and beneficiary of your teachings... Is it possible to show us how you built the report from scratch. It is always helpful and more informative if you do these dashboards from a blank page

@ProjectManagementMastery 3 ай бұрын

I hear you, I have so many template ideas in my head that I sometimes take a shortcut and don't start my demo from scratch as it takes more time. But I will keep that in mind thanks for the feedback!

@crazystats8401 3 ай бұрын

Looks great. Not in your shop yet??

@ProjectManagementMastery 3 ай бұрын

No didn't get around to it yet. And I'm trying to motivate you to build it yourself!.. But it will be there soon.

@Varunrthd 3 ай бұрын

Yes please!

@ProjectManagementMastery 3 ай бұрын

@Varunrthd Hi. The template is not very well polished but if you use this link and ask for template 35, I can give you what I have. tinyurl.com/5az8kntd

@dhmacher 3 ай бұрын

"Aww, that's not a gantt chart, that's just a... whooah, that's pretty clever!" Very nice, thanks!

@ProjectManagementMastery 3 ай бұрын

Glad you liked it!

@harshalshelar 3 ай бұрын

i dont get in your project sheet under weeks for a particular who is under multiple projects his requirement for every project we have to change everytime ? , in your video you have assumed some percentage for once initially

@ProjectManagementMastery 3 ай бұрын

I don't think I understand your question but you can allocate a different availability over time for a specific resource.

@harshalshelar 3 ай бұрын

Different resources are performing different tasks in different weeks , so under project sheet before allocation everytime I have to change the percentages ? That will be cumbersome

@ProjectManagementMastery 3 ай бұрын

You might need to give me an example. You can have different resources performing different tasks but they need to be set in the Project Sheet as per MS project in front of each task. This is a project/task based resource allocation system. You should not change the allocation unless there has been availability changes or more work needs to be done on a task.

@harshalshelar 3 ай бұрын

@ProjectManagementMastery under project sheet in tasks I am assuming they are different projects for which allocation randomly initially you have placed , but for those projects (tasks) different resources will have different percentages in different weeks before allocation how to deal with this ?

@ProjectManagementMastery 3 ай бұрын

In this case you won't be able to use this software, in fact I don't think there is one that would do it. How can a system know on one task managed by 2 resources which resource is allocated how much? The only way you will be able to do this is to split that task in 2: task 1 for resource 1 and the other task 1 for Resource 2.