
Step 6Check the boxes beside each type of table that you want Excel to import. Click "Next."
Step 5Click the "New Map" option button. Click "Next" to open a screen listing three types of tables that Excel can import: "Tasks," "Resources" and "Assignments."
Step 4Click the "Selected Data" option button. Click "Next."
Step 3Click "Save" to open the Project Export wizard. Click "Next."
Step 2Click the "Save as type" drop-down box and select "Excel Workbook."
Step 1Click "File" in the Project ribbon and select "Save As."
Microsoft Project is an effective management service for budgeting, tracking and analyzing project tasks. It stores data in tables whose contents you can easily migrate into Excel workbooks. Project saves its files directly as Excel workbooks, and its Export wizard customizes the transition by assigning Excel fields for each Project data column. Excel can then chart the data, perform spreadsheets functions on it, sort it or run Visual Basic macros on it.
Excel functions expand on Project's dedicated tools.
Комментариев нет:
Отправить комментарий