Blog

cách chuyển từ project sang excel | Z photos

25
cách chuyển từ project sang excel | Z photos
cách chuyển từ project sang excel | Z photos

While Project desktop has many built-in reports that let you present all sortsof project data to your stakeholders, you can also export your project data to Excel for in-depth data analysis and visual reporting. In Excel, you can create PivotTable reports, charts, and use many other features that help you create a more visual report.

You’ll have to map your project data for proper arrangement in Excel, but the Export Wizard will guide you along the way.

Bạn đang xem: cách chuyển từ project sang excel

  1. Choose File > Export > Save Project as File, and under Other File Types, double-click Microsoft Excel Workbook.

    Save Project file as Microsoft Excel workbook

    (In Project 2010, choose File > Save As, and next to Save as type, choose Excel Workbook.)

  2. In the Save As dialog box, pick a location for the workbook.

  3. In the File name box, type the name you want, and choose Save.

    The Export Wizard appears.

    Xem thêm: download 4k video downloader full crack | Z photos

    Export Wizard

  4. Choose Next to get started.

  5. On the Data step, choose Selected Data, if it’s not already selected.

  6. On the Map step, choose New map to create your own data settings for mapping your data from Project fields to appropriate Excel fields.

    To use a predefined or previously defined map, choose Use existing map, and then pick the map you want to use.

  7. On the Map Options step, pick the types of data you are exporting and the options you want.

  8. On the Task Mapping, Resource Mapping, or Assignment Mapping steps, edit any mapping assumptions Project made, and enter any new mapping fields:

    • In the From column, type or select a Project field, and then press Enter.

    • Xem thêm: Sự khác nhau giữa Adobe photoshop CS và Adobe photoshop CC

      Use the buttons below the mapping table to insert or remove rows, or apply a Project table for mapping.

    • Use the Move buttons to rearrange fields.

    • Under Preview, verify the layout of your export map.

  9. If needed, pick a specific export filter in the Export filter box.

  10. Choose Next.

  11. On the End of Map Definition step, choose Save Map if you want to use it again, and type a name in the Map name box. The new map will be added to the list of predefined maps.

  12. Click Finish.

To view your exported project data, open the workbook in Excel.

Danh mục: Blog
Nguồn: https://zphotos.org

0 ( 0 votes )

Z photos

https://zphotos.org
Z Photos Blog cập nhật tin tức, thiết bị và công nghệ các bài viết, video, mẹo, hướng dẫn và thủ thuật nhiếp ảnh

Bài Viết Liên Quan