- #How to use microsoft excel 2010 to male schedule how to
- #How to use microsoft excel 2010 to male schedule professional
He is also a regular lecturer in the MS Community. Shares first place as the best lecturer of KulenDays 20 and PMI Conference 2009 in Zagreb. In addition, he was in TOP 10 lecturers at the MS SINERGY 2009 and MS VISIA 2009, 2010. He was named the best lecturer of WINDAYS 2008 while his lecture was also voted as the best. He is a regular lecturer for Project Management in MS Innovation Center in Varaždin, Logosoft Sarajevo in Bosnia and Herzegovina and SEAVUS GROUP in Skopje Macedonia. Today he works as a business consultant, adn Project Manager in PERPETUUM MOBILE d.o.o. He has got a lot of experience working with people in different business processes and also possesses great knowledge in information technologies and financial services. After completing his college he started working on projects in different business areas (banking, manufacturing, automotive industry, distribution, oil companies, etc.) developing and implementing ERP systems into different companies. Interests: Project Management and MS PROJECT
#How to use microsoft excel 2010 to male schedule how to
In my next Post, I will show how to view the Critical path in Master Project, how to unlink Sub Project from Master Project, and how to remove Sub Project from Master Project. so, if you want to be sure that you can not make any changes to Sub Project through Master file, always have opened only Master file, or open it first, before any other Sub Project. It depends of which file did you open first! If you open the Sub Project file first, and the a Master Project file, you will be able to change to the subproject in the Master Project. But, if you open both, Master and Subproject file that might not be true. If you have open only Master Project, everything is fine. No suppose that my Sub Projects are managed by different Project Managers, and I do not want to allow any changes to those Sub Projects from the Master Project! I will double click on the Sub Project Project2, and then:įrom now on, if I change anything in the Project 2 Sub Project from the Master Project, I will get this:Īnd it means that those changes can not be save in my Project2 Sub Project.īut be careful. Remember that any change you make in a Master or Sub Project file are instantly made in the other file (Sub Project or Master), because there are LINKED! Simply, add the new column in the Resource Sheet, named Project, and you will get: What if you have the Resources with the same name in the multiple Project like this? Why? Well, this is Master-Slave situation, and Project3 has to be Sub Project (slave), of Project1, and it can not be on the same level as the Master Project ( Project1) What if I want to outdent Project2 or Project3? I will insert the Project3 with collapsed Project 2, and I will get: Why? Because I did not collapse Project2 before I have inserted the Project3 as a Sub Project! Notice, that Project3 is now Sub Project of Project2. Now I will select the first blank row below Project2, and I will insert a new Sub Project, as I did it before, and I will get: I will click on the + sign, and I will get the Tasks from the Sub Project: firs empty row in my Master Project) and I will choose a Sub Project: I have another two “sub” Projects, and I want to insert them in the Master file! I will click in the row number 5 (e.g. If you have a Master-Slave situation with your Projects, and you are keeping all those Projects in separate files, but you want to see them all on the one file, first you shoul open your Master Project, like I will: Let’s go! Do you know what is Program, and what is Portfolio? Simply, Program is set of Related Projects, and Portfolio is set of unrelated Project or Programs!
#How to use microsoft excel 2010 to male schedule professional
For example, if you are using MS PROJECT SERVER 2010, then MS PROJECT PROFESSIONAL 2010 is serving as a client! You can do a lot with MS PROJECT 2010 PROFESSIONAL, but MS PROJECT SERVER 2010 is much stronger tool, than it is MS PROJECT PROFESSIONAL. If you are going to manage multiple Projects as a Program, or Portfolio, or both, and you want to do a serious job, then you should use MS PROJECT SERVER 2010. Before I start, I have to tell you something very important. I will explain how to Manage Multiple Projects with MS PROJECT 2010.
0 kommentar(er)
