98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Project Training and help » microsft+office+project+2003+courses+in+london - Exporting to Excel
microsft+office+project+2003+courses+in+london - Exporting to Excel
Resolved · Low Priority · Version Standard
Feisal has attended:
Project Intro Intermediate course
Exporting to Excel
How can I export Project data to Excel, without losing the task levels?
RE: Exporting to Excel
Hi Feisal
Probably the most reliable way to get data from Project to Excel is to use the export wizard. It involves a few steps - first from the file menu in Project choose save as...
then in the save as type dialogue box choose Excel Workbook and name your file.
The export wizard then begins, click Next.
You can either use the built in template or select your own data. Choose the project template to start with to see what Project does.
A new Excel file will be created using the entry table fields, correctly labelled.
Let us know if you need further information.
Kind regards,
Andrew
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
MS Project tip:Compare Work and DurationDuration is the timescale within which a task is done; Work is the specific time element used. For example, 3 days work in a duration of 2 weeks. To compare, add the Work field into the Entry table by right clicking a column heading to Add Field. |