- Visual reports are just Excel…pivot charts, or Visio pivot diagrams.…Because of that, you can reuse a customized…visual report simply by saving it as a template.…You can also create your own templates from scratch.…Well let's run a built-in visual report.…On the Report tab, I click Visual Reports…and I'll select Baseline Work Report.…To generate the report, down at the bottom right,…I'm going to click the View button,…and that opens it up in Excel.…
Now I can make the changes that I want to this report.…For example, I'm going to change the title.…I click that text box and I'm going to add…"by Time" in the title.…Then, over in the PivotChart Fields pane,…I'm going to switch Tasks and Weekly Calendar.…I'm going to drag Weekly Calendar down…into the Access Categories section…so that the X-axis will have time.…And then I'm going to drag Tasks…up into the Filter section.…
When I look at it, now I have work by time.…Let's save this as a template.…Here's how you do that.…In Excel, you go to the File tab,…and we're going to choose Save As.…
Author
Updated
11/5/2015Released
5/14/2015Viewers will then learn how to customize fields and generate cool graphical and visual reports. Finally, the course shows how to share various customizations and configurations as well as best practices for managing multiple projects.
- Recalculating duration, work, and units for assignment changes
- Adding, removing, and replacing resources
- Defining part-time resources
- Setting cost rates
- Accounting for overtime costs
- Working with earned value
- Exchanging data with other programs
- Customizing fields and reports
- Sharing customizations
- Sharing resources and linking tasks between projects
Skill Level Intermediate
Duration
Views
Related Courses
-
Management Tips
with Todd Dewett7h 50m Intermediate -
Deke's Techniques
with Deke McClelland155h 53m Intermediate -
Excel 2013 Essential Training
with Dennis Taylor6h 32m Intermediate -
Photoshop CC 2015 Essential Training
with Julieanne Kost12h 27m Beginner
-
Introduction
-
Welcome2m 1s
-
-
1. Options for Opening and Saving Project Files
-
2. Mastering Resource Assignments
-
Keeping task duration fixed3m 26s
-
Maintaining total task work3m 33s
-
3. Managing Project Costs
-
4. Working with Earned Value
-
5. Exchanging Data with Other Programs
-
Hyperlinking in Project6m 3s
-
-
6. Customizing Fields
-
Understanding custom fields3m 32s
-
Naming a custom field2m 35s
-
-
7. Customizing Graphical Reports
-
8. Customizing Visual Reports
-
9. Sharing Customizations
-
10. Working with Multiple Projects
-
Creating a master project4m 32s
-
Conclusion
-
Goodbye1m
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Creating a custom visual report template