Create This Dynamic Project & Job Schedule In Excel Today [Project Manager Pt2]

In this week’s training, I will show you how to create a dynamic project scheduler.

⬇𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘:

EXCEL COURSES:

EXCEL PRODUCTS:


TIMESTAMPS:
0:00 - Introduction
0:32 - Overview
3:40 - Selection Change Event
4:25 - Change Event
5:26 - Load Project
20:33 - Load Project Schedule
43:55 - Previous Month
45:29 - Next Month
46:25 - Show and Hide Filters
50:10 - Conditional Formatting

Follow me on my Social Media Accounts:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:

New Training Video Uploaded Every Tuesday And Saturday!

Thank you very much for your continued support,
Randy Austin

#exceltraining #projectmanager #projectscheduler #dynamicprojectplanning

[alfredreloj]

Been watching your videos for weeks now and it's been a great ride!

[SyedMuzammilMahasanShahi]

Yet another beautiful video ... Thanks Randy for the share.

[VishalTapase]

Randy sir
Wonderful skills and formatting

[erikguzik]

Quick comment about Time stamp 15:15 to 17:30 - as you go over the formula of the INDEX with SUMPRODUCT. One thing that may help some of us, when explaining how the formula is working, is to pull up the "EVALUATE FORMULA" in the Formulas ribbon and step thru the calculations. Its not always helpful but sometimes on complicated formulas it shows how it is working. Just something from my perspective that i have found useful at times. --- your results may vary .. :) :) ---

Dear Randy, thanks for this valuable app.

[yians]

Hi randy. Im so impressed on your skill and knowledge about excel. Your level and intelligence is unreachable indeed. It was a good help for me cause im working on a school.registrar. I hope you could provide some videos on student grade keeping and recording. I also wanted to.ask if it is possible to single click data( example subjects enrolled) on a table and automatically goes to another table. And every time you click the subjects it just adds up to the other table? Hope you notice me. Goodwork sir. I hope I can be like you. Cheers

[hadisheet]

Hello Randy,

hope all is well, definitely in love with your courses. However, 1 important question I have is about the buttons to add, cancel, and save new projects to the list. I cant seem to make the buttons switch from cancel or save to add new again.

your help would be highly appreciated on this matter !

thank you and regards,

[Papajohn]

Randy Hi,
First of all thank you for all the wonderful things you share with us. I have a proposition.
What if the assigned job is starting or ending on a public holiday (for example Sunday or Easter/Christmas or 4th of July). Is there a way to warn the user for it and furthermore to set up the date automatically to the fist working day? Considering that the public holidays may differs from country to country or by religion beliefs, the user should be able to modify the holidays.
Please consider the above idea and the implementation of it, to the project.
Thank you again!

[FAlsufyani]

Great work Randy
I'm wondering if the same person has 2 projects start at the same date and he should split his time between the two projects. when you create 2 new projects with the same start date, they will overlap each other in the calendar. is there a creative way to fix.

[renatajesus]

Hi, Randy!
Love your videos, as always.
I have a question. In the reservation Data Base that you created, would it be possible to have more than one room per reservation?
Like you have here.

[jillianonthehudson]

Hi Randy: Top notch as always. I was wondering about the subs to deal with December and January (prev month/next month)... Wouldn't that be addressable just by using modular arithmetic? -1 Mod 12 = 12, unless I'm missing something? That would save those extra steps?

[sarmyo]

Hello Randy I follow you from Spain, thanks for everything you share, you are excellent .. I have modified the project manager to adapt it to my needs (only until part 2 I really do not need more complications). but I can't find why it doesn't give me the name on the first day of the month in some projects, especially in the last ones, it's 70 projects. I have reviewed the code over and over again, the formulas etc. I hope you have time to answer. Cheers!

[gcisneros]

How would we go about color coding the projects? Say we enter bug fix the row is red etc. Awesome video btw!

[kjaan]

Hi Randy,
I didn't see any financial statements in the 100 application that you're selling.

[charlesdawnbeltran]

Hi Randy,
Great video. On the attachment part, is it possible to add 'download button' the file to desktop instead of just opening it?

[otrocomentariomas]

Great work, I've been spending hours watching and scratching the code to understand a lot of useful features to apply to different projects.

It's possible to add an useful Filter Button as an additional feature without affecting functionality? I saw the button was in this video but in part 3 was deleted.

I don't know if the best way is like add it updating the sheet based on a row criteria like "If b2=Pending" update all the sheet or like the Day/Month/Year buttons.

What do you think is the best way to add this feature without affecting functionality?

[chuckhamdan]

Randy, The hyperlink for Downloading the Project Manager Pt 2 is pointing to Project Manager Pt1.

[khichdi]

How to add additional Field like "Project mile stone" under project Management status below project Name? That should consist drop down like Req gathering, Enage COE, IT testing, SIT, UAT, Prod go-live etc.

[danielmajlath]

Hello, Everybody! I have troubles with the function in video above called IsNumeric(). Namely, this function gives to me "True" as a result for an empty cell, so when a cell from the range P4:AT37 is selected the whole code goes to Sub Project_Load and as a result of that a msgbox appears with a reminder for user to select a "correct Project" and the value of the cell I4 takes the "value" of that empty cell which is referenced to Target (Target columns+100). What is the problem? I'm I wrong with my code or instead of IsNumeric we supposed to use IsNumber or another logical AND in IF statement for empty cells?

[mtgen]

Is it possible to protect excel securely? Because password in sheets aren't secured enough.