Reporting

Formation MS Office Project - Reporting in Geneva, Zurich, Huston, San-Antonio, Dallas, Los Angeles, San Diego, New York, Washington, Chicago, San Francisco and anywhere in Switzerland, USA, Great Britain and Germany.

375.-/d

ID : 812

Goal : Learn to use the built-in reports and to create custom reports, even with mappings and Excel wizards, export to Access and use of XML / XSL.

Audience : Project manager seeking to push the limits of MS Project with desktop tools for analysis, web and VBA.

Prerequisites : Work with big and medium sized projects (200 tasks minimum). Working experience of MS Project is recommended as well as working with MS Excel, MS Access. HTML is an advantage.

Goals :

- Introduction

- Printing options for tables and views

- Printing Gantt for one resource between two dates using filters

- Gantt Image Export Tool

- Creation of simple and complex filters setup

- Creating basic and complex groups

- Accessing and display of integrated reports

- Creating new reports using (or not) filters and groups

- Organizing reports

- Limits of integrated reports

- Export Excel tables/charts using the Analysis toolbar wizard

- Standard export with mapping on Excel tables or PivotTables

- Creating and organizing mapping using custom filters and groups

- Export using XML Wizard from the Analysis toolbar and custom standard XSL

- Export data to HTML for Intranet

- Using MS Access export to generate advanced reports

- VBA development to export to any file type

- Training Conclusion

Pedagogical method : This participative training is based on examples proposed by the trainer.

Suggested duration for presentiel training (days) : 1

Suggested duration for on-line training (days) : 1.2

Daily price in face-to-face : 375 CHF

Daily price in remote : 180 CHF

Daily price in remote for students : contact us (only if student card!)

Daily price in remote (with recording) : 1875 CHF

Prices are per day per trainee without course material, without certificate, without evaluation, without exam, without training room or computer (these are each optional and must be requested in addition in the contact form for the establishment of the quote).

Tags : ms project training, MS project course, reporting, export, xml, project xml, export project xml, VBA, VBA.

Contents