Hi,

in my last blog post I was finished the Scheduling! In my next posts, I will temporary forget my “Wedding Project”, and I will start to explain how to set up, and manage the Resources in MS PROJECT 2010. It is very important part of MS PROJECT in many ways. If you ever had a problems with resources in your MS PROJECT 2010, you should read those posts very carefully!

You can enter your resources in many ways. The best way is through Resource sheet!

Before I start with explanation what each row means, I will show you how can you export your resources from your E-mail address book, and from excel.

If you have your resources in your address book, you do not have to retype them in the Resource sheet. Instead of that, just open the Resource sheet, and click on the Resource Tab, then click on the Add Recourses, and then on the Address Book:

and you will get:

After you select and Add your resources, click on the OK button and you will get:

They are here! It is easy isn’t it? You should fill other fields like Max units, Std. Rate, etc., but it is easier that retype the whole story!

What are the other fields, and what do they mean? You will find out if you will continue to read my next posts!

If you import Resources from excel template, first you should give that template to someone who will fill it! It can be HR department, or someone who is responsible for managing Resources for your Project.

To get the Template you should follow this steps:

Start excel and then choose:

and then:

When you Double click on this template you will get:

and you will get sheet in which you can enter your resources, like I will do in my example:

Of course, you can fill the other fields

Now you should save this excel template:

and You will get:

Now, you can close your excel file, and go back to your Project file.

On the File Tab, click Open:

And you will get:

Now choose your file:

and you will get:

and then:

Because I have already imported some resources from my E-mail book, I will Append those Resources from my Excel file to the existing resources:

And I will get:

After that you will get “next” screen. If you did not change the layout of your excel template and layout of Resource sheet n MS PROJECT 2010, you should click on the Finish button:

and, finally you will get:

That was the easier part of Managing Resources. Next time, we are going to some “serious” business.

Until then,

Best regards!