incorporate excel to project and make formulas

[jasmin]

hi!

i am a newbie user of project software, i have searched and inquired on help
but couldn't find a way on how to incorporate excel to ms project software. I
have tried to insert some columns but cannot do a formulation to have my
desired data.

My boss keeps telling me that on the ms project, they wouldn't move the good
things of excel formulation.

Is there someone out there who can help me? I would really appreaciate it
because the will be in a meeting next week and they want me to finish this
all up.

thanks

 

[St Dilbert]

You can't copy cells between Excel and Project like you can between
different Excel workbooks.

Project is not Excel, it's not Excel in disguise or an Excel add-on.
What they have in common is displaying lots of rows and columns and
even some calculation capabilities and they both have a lot of "good
stuff" in them.

I remember a sentence from the foreword of Microsoft press' official
book on using MSp, written by a Microsoft guy responsible for the
application: "Project is not a spreadsheet, it is a database that
understands time"...

I guess this misperception about Project being extremely similar to
Excel happens a lot. I'm pretty sure, most of what you want for a
project environment can be supported with the tool MS project. But you
will have an unnecessarily frustrating learning curve if you stick to
the misperception of the two applications being very similar.

 

[JulieS]

Hi jasmin,

To add to St. Dilbert's answer: You can create formulas in custom
fields in MS Project, but the process is a bit different.

Mike Glen (Project MVP) has written a excellent series of articles on MS
Project. You may read the articles through the following link:
http://project.mvps.org/mike's_tutorials.htm

Articles 14 & 15 address customizing fields.

Take a look at Mike's articles and see if that starts you in the correct
direction. If you need additional assistance, please post back with
specific details about what data you are trying to get from Project, and
we'd be happy to help.

--
I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for FAQs and more information about
Microsoft Project.

 

[Wiley]

Can you be more specific as to what you need the formula to do?