Home > Store

Project 2013 In Depth

Register your product to gain access to bonus material or receive a coupon.

Project 2013 In Depth

eBook (Watermarked)

  • Your Price: $25.59
  • List Price: $31.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.


  • Copyright 2014
  • Dimensions: 7" x 9-1/8"
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 0-13-314337-6
  • ISBN-13: 978-0-13-314337-9

Do more in less time!

This book’s packed with intensely useful Project 2013 knowledge, tips, and shortcuts you just won’t find anywhere else. It’s the fastest, best way to master every phase of project management with Project 2013: initiation, planning, scheduling, resource assignments,
tracking, revision, completion, and more. You’ll get comfortable with Project 2013’s most valuable new features…master powerful new cloud-based tools for running your projects…even learn to manage complex project portfolios for your entire organization!

•    Discover what’s new in Project 2013 and get started with new projects fast

•    Apply project management best practices through Project 2013

•    Initiate, plan, and organize projects to maximize your odds of success

•    Create realistic schedules for your project and all your team members

•    Define task logic to intelligently link sequences of activities

•    Identify and eliminate bottlenecks before they interfere with your project

•    Use Project’s automated scheduling engine to optimize efficiency

•    Review and tweak your schedule using views, tables, filters, and groups

•    Track your project’s progress and analyze your performance to date

•    Adjust resources, tasks, and schedules to reflect project changes

•    Officially close your project, and evaluate it via Lessons Learned analyses or Earned Value tracking

•    Tailor Project 2013 to your individual and organizational needs

•    Leverage Project 2013’s powerful cloud-based collaboration features

•    Customize reports, including Project 2013’s advanced Visual Reports

•    Work with multiple projects at once and resolve complex resource allocation problems

•    Integrate Project 2013 with other Microsoft Office and third-party applications All In Depth books offer

•    Comprehensive coverage with detailed solutions

•    Troubleshooting help for tough problems you can’t fix on your own

•    Outstanding authors recognized worldwide for their expertise and teaching style

Learning, reference, problem-solving...the only Project 2013 book you need!

Sample Content

Table of Contents

I Getting Started with Microsoft

Project 2013

1 Power of Microsoft Project

2013 1

Essentials of Project Management 1

    Projects Are Temporary 3

    Project Objectives Are Specific and Measurable 3

    Projects Are Constrained by Time, Cost, Scope, and Quality 3

What Project Can Do for You 5

Enterprise Versus Standard Thinking 7

    Desktop Tools: Project Standard and Project Professional 7

What’s New in Project 2013 8

    Reports 8

Consultants’ Tips 11

    Go Ahead and Ignore Project

    Management If It Suits Your Role 11

    Communicate 11

    Define Project Roles 11

    Define Project Deliverables Prior to Building the Schedule 12

    Define the Project Goal 12

    Create the Work Breakdown Structure 12

    Communicate the Schedule to Your Project Team 12

    Acquire Commitment from the Project Team 13

    Track Your Project Performance During Execution 13

    Close Your Project and Retain History 13

2 Microsoft Project Quick

Start 15

Five Process Groups for Projects 16

    Initiating Process Group 16

    Planning Process Group 17

    Executing Process Group 17

    Monitoring and Controlling Process Group 17

    Closing Process Group 18

Navigating Project 18

    Introducing the Gantt Chart View 21

    Scrolling, Selecting, and Entering Data Fields 23

    Exploring the Look and Feel of Project 23

    Exploring the Project Window 24

    Project’s Help Feature 25

Using Team Planner to Start Managing Resources Quickly 26

Define Project Scope 27

    Build and Decompose the WBS 28

    Create a Project Schedule Using Microsoft Project 30

    Use Project Schedule Templates or Create a New Project 31

    Set Project Attributes 32

    Build Your Project Schedule Using the WBS 35

    Enter or Adjust Summary Tasks and Subtasks 36

    Create Milestones 37

    Set Deadlines 38

    Create Task Dependency Relationships 39

    Create Your Team and Assign Resources 41

    How Duration, Work, and Resource Units Affect Your Project Schedule 44

    Enter Estimates 45

    Review the Schedule for Overallocation or Other Potential Issues 46

    Inactivating Tasks 47

    Baseline Your Schedule 48

Track Your Project 49

    Obtain Project Status 49

    Enter Your Tracking Data 50

    Analyze Your Status 53

Close Your Project 54

Consultants’ Tips 55

    Formulas That Affect Your Schedule 55

    Create a WBS 55

    80/20 Rule 56

    Project Is a Tracking Tool 56

    Always Baseline! 56

    Split Window and Views 56

3 Microsoft Project and the Project Management Domain 57

History of Project Management 57

Exploring Project Management Industry Standards 58

    Project Management Body of Knowledge (PMBOK) 58

    PRINCE2 61

WBS, Phases and Control Points, Methodologies, and Life Cycles 63

    Work Breakdown Structure (WBS) 63

    Managerial Control 64

Using Microsoft Project with Methodologies and Life Cycles 65

    Waterfall Development Process 66

    Iterative Development 66

    Research Project 69

Accommodating Teaming Styles 69

Consultants’ Tips 70

    Determine the Approach to Use in Managing Your Project 70

    Use WBS as a First Step in Project Definition 70

    Use the 5×9 Checklist for Planning 70

II Organizing for Success—Project

Initiation and Planning

4 Getting Started After the Business Initiative Is Approved 71

Organizing Projects for Success 71

    Define Measure of Success 72

    Clarify Constraints and Boundaries 73

    Define the Final Deliverables 74

    Establish Change Control Process 75

Work Breakdown Structure 76

    Work Breakdown Structure Concepts 76

    WBS and Scheduling 78

    Use of Templates 80

WBS Numbering 80

    Creating Custom WBS Codes 82

    Inserting, Deleting, and Moving Tasks with Custom WBS Codes 84

    Editing Custom WBS Codes 84

    Renumbering the Custom WBS Codes 86

Scope Control and Change Control 87

Consultants’ Tips 87

    Understanding a Work Breakdown Structure 87

    Define the Full Scope of Your Project 87

    Build WBS First 88

    Define Project Work Packages 88

5 Setting Up Project for Your Use 89

Setting the Task Mode 89

    Setting the Task Mode 89

    Understanding the Task Mode 91

Defining Project Information 91

    Understanding the Project Information Dialog Box 92

    Defining Project Properties 97

Defining Calendars 101

    Calendar Hierarchy 102

    Modifying and Defining Base Calendars 102

    Setting Project and Resources Calendar 108

Defining Custom Fields 112

    Custom Fields Concept 112

    Defining Custom Fields 114

Defining Environment Options 115

    Defining Project Standards 116

Consultants’ Tips 130

6 Creating Your Project

Schedule 131

Entering Project Tasks 131

    Entering Tasks Using the Gantt Chart View 132

    Creating Task Names 139

    Entering Task Durations 141

    Editing Tasks Using the Task Information Dialog Box 146

Manipulating the Task List 148

    Displaying Long Task Names 148

    Adjusting the Height of Task Rows 149

    Undoing Changes in the Task List 150

    Inserting, Deleting, and Clearing 151

Copying, Cutting, and Moving Tasks 152

    Using the Fill Command 153

Defining Summary Tasks and Subtasks 154

    Understanding Duration of Summary Tasks 155

    Indenting and Outdenting Tasks 155

    Collapsing and Expanding the Outline 157

    Editing Outlined Projects 158

    Selecting the Display Options for Outlining 158

    Using Rollup Taskbars 159

Defining Milestones 160

Attaching Notes to Tasks 162

    Typing and Formatting Notes 163

    Inserting Hyperlinks in Notes 164

    Inserting Objects in Notes 165

    Attaching Notes to the Overall Project 167

Attaching Hyperlinks to Tasks 168

    Attaching Hyperlinks to Existing Files or Web Pages 168

    Attaching Hyperlinks to New Files 170

    Attaching Hyperlinks to Tasks or Resources in the Same Project 170

    Using Hyperlinks to Create Email Messages 171

    Editing and Deleting Hyperlinks 171

    Placing Hyperlinks in the Custom Text Fields 171

Defining Recurring Tasks 172

    Creating Recurring Tasks 172

    Editing Recurring Tasks 175

Creating WBS Codes 176

Using Other Views to Create Tasks 176

    Using the Task Entry View 177

    Using the Task Sheet View 178

Using the Timeline View 179

Consultants’ Tips 182

7 Defining Task Logic 183

Manipulating Your Schedule 185

    Using the Multiple Undo and Redo Feature 185

    Using Change Highlighting to View Changes 185

Linking Tasks 186

    Understanding Task Relationships 187

    Defining Dependency Links 187

    Defining the Types of Dependency Link Relationships 189

    Using the Finish-to-Start Relationship 190

    Using the Start-to-Start Relationship 190

    Using the Finish-to-Finish Relationship 191

    Using the Start-to-Finish Relationship 192

    Choosing the Dependent Tasks 193

    Allowing for Delays and Overlaps 194

    Entering Leads and Lags 195

    Linking Summary Tasks 196

    Creating Links by Using the Menu or Toolbar 197

    Creating Links by Using the Task Information Dialog Box 198

    Creating Links by Using the Task Form View 199

    Creating Links by Using the Entry Table 201

    Creating Links by Using the Mouse 203

    Working with Automatic Linking Options 205

    Modifying, Reviewing, and Removing Dependency Links 206

    Auditing Task Links 207

    Using the Task Inspector 209

    Using Task Path 210

Defining Constraints 211

    Understanding Types of Constraints 212

    Entering Task Constraints 216

    Creating Constraints in the Task Information Dialog Box 216

    Creating Constraints in a Task Table 218

    Creating Constraints in the Task Details Form 219

    Responding to Warnings from the Planning Wizard 220

    Deciding to Honor Links or Honor Constraints 221

    Finding and Reviewing Tasks That Have Constraints 224

    Removing Task Constraints 225

    Resolving Conflicts Caused by Constraints 225

    Creating a Modified Constraint Dates Table 226

Performing Advanced Actions on Tasks 227

    Entering Deadline Dates 227

    Filtering for Missed Deadline Dates 229

    Splitting Tasks 229

Consultants’ Tips 232

    The Deadline Feature 232

    Scheduling Logic 232

    Deadlines Versus Sponsor Schizophrenia 232

    Connecting Tasks with the Mouse 233

    Showing Detail in the Gantt Chart 233

8 Defining Project Resources 235

Understanding How Project Uses Resources and Costs 235

    Cost Resources 237

Defining Resources and Resource Information 237

    Understanding Resource Types 238

    Understanding Budget Resources 238

    Distinguishing Single and Group Resources 238

    Using Generic Resources for Common Skills 239

Using the Resource Sheet View 239

Defining Resource Information Using the Resource Information Dialog Box 241

Using the Resource Fields to Define Resource Details 242

    Using the Resource ID Field 242

    Interpreting the Indicator Field 243

    Specifying Resource Names Using the Name Field 243

    Using Resource Type to Categorize Resources 243

    Using the Material Label to Specify Units of Resource Measure 244

    Using the Initials Column to Shorten Resource Names 244

    Using the Group Field to Categorize Resources 245

    Using the Max Units and Resource Availability Table to Specify Resource Availability 246

    Selecting Resource Calendar to Specify Resource Base Availability 249

    Specifying the Resource Working Time 249

Defining Resource Costs 252

    Applying the Standard Rate to a Resource 252

    Applying the Overtime Rate to a Resource 253

    Applying the Cost Per Use to a Resource 254

    Understanding the Cost Rate Tables 254

    Selecting the Cost Accrual Type 256

Using the Task Form View to Add Additional Resources 256

Understanding Resource Constraints 257

Working with Resources 258

    Setting the Automatically Add New Resources and Tasks Option 258

    Sorting Resources 259

    Grouping Resources 263

    Filtering Resources 264

Consultants’ Tips 267

9 Understanding Work Formula

Basics 269

Understanding Task Levels 269

Work, Duration, and Units 270

Tasks with Multiple Assignments 271

Understanding Resource and Task Assignments 272

Reviewing the Essential Components of Work Resource Assignments 272

Understanding the Resource Assignment Fields 273

    Assigning a Resource to a Task 274

    Understanding the Assignment Units Field 274

    Assigning the Work 277

    Assigning the Duration 278

Understanding the Work Formula 278

    Applying the Work Formula in New Assignments 279

    Applying the Work Formula in Changes to Existing Assignments 288

Selecting Task Settings 289

    Setting the Task Type 291

Schedule Modifiers That Affect the Complexity of the Scheduling Engine 292

    Task Mode 293

    Project Scheduling the Resource Assignment to Start When the Task Starts 293

    Splitting Task Assignments 293

    Scheduled Delay Effects 293

    Leveling Delay Effects 294

    Work Contour Effects 294

    Resource Availability Effects 295

    Calendar Effects 296

    Effort-Driven Task Effects 296

    Effects of Using Driver Resources 297

Consultants’ Tips 297

    80/20: Using Task Modes 297

    Work Formula Factors 298

    80/20: Using Task Types 298

    80/20: Using Effort-Driven Task Types 298

    The Difference Between Calendar Duration and Actual Assignment Duration 299

10 Scheduling Single and Multiple

Resource Assignments 301

Mechanisms: Methods for Adding Resources 302

    Adding Resources Using the Assign Resources Dialog Box 302

    Adding Resources by Using Drag-and-Drop 303

    Assigning Resources with the Team Planner View 304

    Assigning Resources with the Task Entry View 305

    Assigning Resources Using the Task Information Dialog Box 306

    Assigning Resources with the Task Table 308

Creation: Assigning a Single Resource 309

    Assigning a Resource Using the Assign Resources Dialog Box 310

Creation: Assigning Multiple Resources 312

    Calculating Task Duration with Multiple Resources 312

    Understanding Effort-Driven Tasks 313

    Understanding the Driver Resource Concept 317

Maintenance: Modifying Existing Resource Assignments 320

    Modifying Resource Assignments 321

    Entering the Assignment Values 322

    Assigning Resources with the Task Usage View 325

    Modifying Work Schedules with the Task Usage View 326

    Using the Assignment Information Dialog Box 329

    Scheduling a Late Start for an Assignment 330

    Splitting a Task Assignment 333

    Removing Resource Assignments from One or More Tasks 333

    Replacing a Resource on an Assignment 335

How-To’s: Modifying Resource Assignments 336

    Graphing Resource Availability 336

    Scheduling Resources for a Specific Amount of Work 339

    Contouring Resource Usage 339

    Selecting a Predefined Contour Using the Assignment Information Dialog Box 344

    Using Overtime to Shorten Duration 345

    Selecting a Cost Rate Table for an Assignment 348

    Assigning Fixed Costs and Fixed Contract Fees 349

    Scheduling with Task Calendars 351

    Adding Delay to an Assignment 353

Consultants’ Tips 355

    Make Judicious Use of the Team Planner and Manually Scheduled Tasks 355

    80/20: Use the Task Entry View for Resource Entry and Modifying Assignments 356

    Depth: Calculation of the Default Units Value Used When Assigning a Resource 356

    Config: Turn Off Automatic Resource Creation 356

    Forward-Scheduling Versus Backward-Scheduling 356

11 Using Standard Views, Tables, Filters, and Groups to Review Your Schedule 357

What Can I View Using Microsoft Project? 357

Viewing Strategies 359

    Strategies on Using Views 359

    Strategies for Using Tables 362

Understanding Standard Views 366

    Calendar View 367

    Gantt Chart Views 369

    Team Planner View 373

    Network Diagram View 375

    Descriptive Network Diagram Views 376

    Task Usage View 377

    Tracking Gantt View 378

    Resource Graph View 378

    Resource Sheet View 380

    Resource Usage View 380

    Bar Rollup View 381

    Milestone and Milestone Date Rollup Views 382

    Relationship Diagram View 383

    Resource Allocation View 384

    Resource and Resource Name Form Views 384

    Task, Task Detail, and Task Name Form Views 386

    Task Entry View 387

    Task Sheet View 388

Understanding Standard Tables 389

    Task Tables 389

    Resource Tables 391

Understanding Filtering and Grouping 393

    Exploring Filters in Microsoft Project 393

    Exploring Standard Groups 398

Combining Views, Tables, Filters, and Groups to Review Project Schedule Details 401

    Does My Schedule Contain the Needed Milestones? 401

    Do I Know My Critical Path? 403

    Are My Tasks Linked? 405

    Does My Schedule Contain Constraints? 406

    Are All Needed Task Details Included? 407

    Making Sure There Is Flexibility in the Schedule 407

    Are My Resources Overallocated? 407

    Is My Schedule Baselined? 408

    How Do I Communicate the Tasks? 408

    How Do I Present My Project Schedule to the Project Sponsors? 409

Consultants’ Tips 410

    Stop Expecting Your Resources and Sponsors to Look at the Same Views You Do 410

    Use the Team Planner When Resource Planning Is Your Main Goal 410

    Keep It Simple 410

    Easy Way to Not Accidentally Type in Actuals When Using Resource or Task Usage Views 410

12 Performing a Schedule Reality

Check 411

Auditing the Schedule for Reasonableness 411

    Looking for Logic Errors 412

    Schedule Estimation Methods 413

    Looking for Technique Errors 414

Reviewing the Big Picture: Critical Path Analysis 417

    What Is My Current Critical Path? 418

    How Can I Reduce the Duration of My Critical Path? 419

    Strategies for Crashing the Schedule 420

    Strategies for Fast Tracking the Schedule 420

Reviewing the Project-Level Statistics 421

    Methods of Examining Your Schedule 422

Strategies for Analyzing Costs 423

    Reviewing the Cost Table 423

    Reducing the Cost of Work 424

Finalizing the Schedule 424

Baselining the Schedule 425

    Saving Your Project Baseline 425

Consultants’ Tips 428

    Are You a Pessimistic or an Optimistic Estimator? 428

    Schedule Problems Checklist 428

    Avoiding the “While You Are Here” Syndrome 430

    Deleting Baselined Tasks 430

III Project Execution Through Completion

13 Tracking Your Project Progress 431

Overview of Tracking 431

Working with Project Baselines 432

    Viewing Baselines 433

    Using Usage Views to Show Time-Phased Details 434

Tracking Your Project’s Performance and Costs 436

    Understanding Fields Used in Updating the Project Schedule 436

Entering Tracking Information at the Task Level 438

    Editing the Task Actual Start Date 440

    Editing the Task Actual Finish Date 440

    Editing Task % Complete (Percentage Complete) 441

    Editing Task Actual Duration 442

    Editing Task Remaining Duration 442

    Editing Task Actual Work 443

    Editing Task % Work Complete 443

    Editing Task Remaining Work 443

Editing Task Time-Phased Actual Work 444

    Entering Tracking Information at the Assignment Level 444

    Editing Assignment Actual Start 445

    Editing Assignment Actual Finish 445

    Editing Assignment Actual Work 446

    Editing Assignment % Work Complete 446

    Editing Assignment Remaining Work 446

Editing Assignment Time-Phased Work 447

    Understanding the Calculation Options That Affect Tracking 447

    Using the Updating Task Status Updates

    Resource Status Option 449

    Using the Actual Costs Are Always Calculated by Project Option 450

    Using the Edits to Total Task Percentage Complete Will Be Spread to the Status Date Option 452

    Options to Reschedule Parts of Partially Completed Tasks 453

Using Microsoft Project’s Facilities for Updating Tasks 455

    General Shortcuts 455

    Update Tasks Form 455

    Update Project Form 456

Consultants’ Tips 458

    Always Keep the Original Baseline 458

    Regular Statusing of Team Assignments 458

14 Analyzing Performance 459

Reviewing the Current Status of a Project 460

    Reviewing the Status Via the Current Schedule 460

    Reviewing the Status Via the Project Plan 465

Analyzing Performance with Earned Value Analysis 474

    Understanding Earned Value Measurements 475

    Controlling the Calculation of Earned Value 485

    Summary of Using Earned Value Analysis in Project 487

    Earned Value Report 489

Using Analysis Views and Reports 490

    Analysis Views 491

    Analysis Reports 494

Analyzing the Critical Path 495

Consultants’ Tips 495

    Project Performance Analysis Prerequisites 495

    Project Performance Analysis Areas 496

    Project Performance Analysis Options 496

15 Using Reports for Tracking and

Control 497

Using Reports 497

    Reports and the Iron Triangle 499

    Using Reports for the Project Sponsor 508

Using Visual Reports 510

    Using Visual Reports for Project Analysis 512

    Using Visual Reports for the Project Sponsor 517

    Using Visual Reports for the Project Team 523

Consultants’ Tips 524

    When to Use Reports 524

    When to Use Visual Reports 525

    Customize the Out-of-the-Box Reports for Your Project Needs 525

16 Revising the Schedule 527

When Things Don’t Go According to Plan 527

    Critical Path Changes 528

    What Can Go Wrong 529

    Prevention and Avoidance 530

When Recovery Is the Only Option 530

    Reducing Project Scope 531

    Reducing Project Cost 532

    Reducing Scheduled Duration 532

Rebaselining Strategies 534

Consultants’ Tips 534

    Regularly Review Your Project Schedule 534

    Perform Risk Management and Contingency Planning 534

    Make Your Project Estimates as Realistic as Possible 534

17 Closing the Project 535

Project Close Process Group 536

    Closing the Contractual Agreement 536

    Implementing Project Close Custom Fields 538

Performing Final Reporting 539

    Cost Overruns Report 540

    Additional Out-of-the-Box Closing Reports 540

Performing a Project Retrospective: Lessons Learned 542

Archiving Your Schedule 543

Celebrating Your Project Results 546

Consultants’ Tips 546

IV Tailoring Microsoft Office Project 2013 to Your Needs

18 Managing Project Files Locally and in the Cloud 549

Saving and Protecting Project Files 550

    Working with the Organizer and the Global File 550

    Designating the Default Save Location and Format 550

    Version Compatibility 552

    Saving a File 552

    Your Account 555

    Providing Security for Saved Files 555

    Saving the Workspace 558

    Project Safe Mode 558

Creating and Using Project Templates 559

    Creating a New Project Template 559

    Modifying Existing Template Files 561

    Opening a Template File to Create a New Project 561

Working with the Organizer and the Global File 562

    Global.mpt File 565

    Manipulating Objects Using the Organizer 565

Consultants’ Tips 568

    Global.mpt 568

    Using the Organizer 568

    Protecting Your Project Files When Sharing 568

    Basic Steps for Starting a Project 568

    Use Templates and Keep Them Simple 568

19 Formatting Views 569

Sorting the Tasks or Resources in a View 569

    Selecting the Sort Keys 570

    Selecting the Sort Operation 571

Formatting Text Styles for Categories of Tasks and Resources 571

    Selecting an Item to Change 572

    Changing the Style of Text Displays 574

Formatting Font for Selected Text 575

Formatting Gridlines 575

Using the Outline Options 577

Formatting Timescales 578

    Changing Timescale Tiers 579

    Completing the Timescale Definition 581

    Changing the Display of Non-Working Time 582

Using Page Breaks 583

Formatting the Gantt Chart Views 583

    Formatting the Gantt Chart View Manually 583

    Using the Gantt Chart Wizard 594

Formatting the Calendar View 596

    Formatting the Timescale for the Calendar 597

    Selecting Calendar Bar Styles Options 598

    Setting the Layout Options for the Calendar View 599

Formatting the Network Diagram View 600

    Using the Box Styles Options 600

    Using Data Templates for Network Diagram Nodes 601

    Using the Box Options 604

    Controlling the Network Diagram Layout 604

    Using the Zoom Command 609

Formatting the Task Form and Resource Form Views 609

    Sorting the Form Views 610

    Formatting Details of Form Views 610

Formatting the Resource Graph View 612

    Reviewing the Format Options for the Resource Graph View 614

    Selecting the Details to Display 615

    Using the Bar Styles Dialog Box 617

Formatting the Resource Usage View 619

    Choosing the Details for the Resource Usage View 619

    Formatting the Detail Styles in the Resource Usage View 620

Formatting the Task Usage View 621

Formatting the Task Sheet and Resource Sheet Views 622

Consultants’ Tips 622

    Get Familiar with the Default Views First, Then Customize 622

    Customizing the Gantt Chart View 623

    Sorting Views 623

20 Reports Part I: 2013 Reports 625

Understanding the New Reports 625

    Accessing the Reports 626

    Common Report Elements 627

    Dashboards Reports Category 629

    Resources Reports Category 632

    Cost Reports Category 634

    In Progress Reports Category 636

    Miscellaneous Category Controls 638

Customizing Sections of Reports 639

    Customizing a Text Box or a Shape 639

    Adding or Customizing a Picture 640

    Adding or Customizing a Chart 642

    Adding or Customizing a Table 645

Customizing Reports 646

    Customizing an Existing Report 647

Creating Reports 647

    Creating a New Report Based on an Existing Report 647

    Designing a New Report 648

Using the Common Customization Controls 649

    Themes 649

    Choosing the Page Setup Options for a Report 650

Saving and Sharing Custom Reports 650

Consultants’ Tips 651

    Right Report for the Right Audience 652

    Avoid Too Much Navel Gazing 652

21 Reports Part II: Visual Reports 653

Reports Part II: Visual Reports 655

Understanding OLAP Cubes for Visual Reports 658

Understanding Excel and Visio in Relation to Project 659

    Using Excel While Working with Visual Reports 659

    Using Visio While Working with Visual Reports 664

Reporting Capabilities 665

    Customizing Excel Visual Reports 665

    Customizing Visio Visual Reports 680

    Creating Visual Reports Using Excel 688

    Creating Visual Reports Using Visio 692

Sharing and Saving Visual Reports 693

    Saving a Visual Report Template Using Excel 694

    Saving a Visual Report Template Using Visio 694

    Saving a Reporting Cube 694

    Saving a Reporting Database 696

    Printing a Visual Report 697

Consultants’ Tips 697

    80/20: Choose the Right Data Resolution for Your Reporting Goals 697

    Save Customized Reports as Templates for Later Use 698

22 Customization Almost Beyond

Reason: Views, Tables, Filters,

Groups, Fields, Toolbars, and Menus 699

Creating and Customizing Tables 700

    Entering a Table Name 702

    Adding and Changing the Columns in the Table 702

    Completing the Definition of the Table 705

    Changing Table Features from the View Screen 707

Creating and Customizing Views 708

    Entering the Name of the View 711

    Selecting the Starting Format 711

    Selecting the Table for the View 712

    Selecting the Group for the View 713

    Selecting the Filter for the View 713

    Displaying the View Name in the Menu 713

    Saving the View Definition 714

    Creating a Combination View 714

Printing Views 715

    Preparing Your Screen and Choosing Fundamentals for Your Printed View 716

    Filtering, Sorting, Grouping, and Enhancing the Display 716

    Using Page Breaks 717

    Using the Page Setup Dialog Box 717

    Previewing the Printed View 726

    Printing 727

Creating and Customizing Filters 729

    Naming a Filter 730

    Defining Filter Criteria 730

    Using More Filter Criterion Tests 733

    Using Interactive Filters 737

    Creating Calculated Filters 738

    Creating Multiple Criteria Filters 739

    Creating Custom Filters with AutoFilter 740

Creating Custom Groups 741

    Accessing Custom Groups 741

    Selecting Grouping Fields 742

    Defining Group Intervals 743

    Formatting Group Displays 744

    Saving Custom Groups 745

Creating and Customizing Fields 745

    Accessing the Custom Fields 746

    Naming Custom Fields 746

    Creating Calculated Custom Fields 747

    Controlling Custom Field Behaviors 749

    Creating Custom Indicator Fields 749

    Managing Custom Fields 754

Organizing Views and Other Custom Elements in Project Files 754

Customizing the Ribbon 756

Customizing the Quick Access Toolbar 762

Customizing the Status Bar 765

Consultants’ Tips 767

    Create Views the Right Way 767

    Name Organizer Objects Appropriately 767

    Resolve Unexpected View Results 767

    Know Your Audience When Using Graphical Indicators 767

    Keep an Excel Configuration Workbook 768

    Making the Most of the “Ribbon” 768

V Microsoft Project 2013 Knowledge In Depth

23 Working with Multiple Projects 769

Using Windows Commands 769

    Viewing All the File Windows at the Same Time 771

    Hiding and Unhiding Open Windows 772

    Using the Save Workspace Command 772

Comparing Project Versions 773

Displaying Tasks from Different Projects in the Same Window 776

    Using the New Window Command 776

    Filtering and Sorting Consolidated Projects 778

Creating Master Projects 780

    Combining Projects into One File Using the Insert Project Menu 781

    Working with Inserted Projects 782

    Breaking Apart a Large Project Using Inserted Projects 784

    Master Projects Using Hammock Tasks 784

    Maintaining Inserted Projects 786

    Identifying Tasks That Are Inserted Projects 787

Creating Links Between Tasks in Separate Projects 788

    Sharing Resources Among Projects 791

    Creating the Shared Resource Project 792

    Using the Resource Pool 792

    Discontinuing Resource Sharing 795

    Identifying Resource Pool Links 796

    Viewing Resource Loads Without Sharing a Pool 796

    Saving Multiple Files in a Workspace 797

Consultants’ Tips 798

    Using Master Files 798

    How Do I Tell Which Task Is from Which Project When They Have the Same Names? 799

    Sharing Resources Between Projects 799

24 Resolving Resource Allocation

Problems 801

Understanding How Resource Allocation Problems Occur 801

    Why Should I Care About Resource Workload Conditions? 802

    What Is the Problem? 802

    What Causes Resource Overallocation? 804

    When Should I Ignore Resource Allocation Problems? 804

Visualizing Resource Allocation Conditions 805

    Resource Max Units, Calendars, and Other Settings 805

    Team Planner 808

Resource Graphs 808

    Resource Sheet 809

    Split Views and Windows 811

    Resource Usage Time-Phased Data 813

    Groups, Filters, and Sorting Tasks with Resources 814

    Review Task Relationships 815

Strategies for Correcting Resource Allocation Problems 816

    Process Check: Review Project Scope and Other Business Issues 817

    Replacing or Adding Resources 817

    Splitting Tasks 818

    Linking Tasks 819

    Adjusting Resource Units 820

    Using the Level Resources Tools 821

    Manual Strategies to Correct Resource Allocation Problems 827

Consultants’ Tips 832

    Use Team Planner and Manually Scheduled Tasks Where Appropriate 832

    Establish Guidelines for Resolving Resource Allocation Issues 832

    Examples of Resource-Leveling Scenarios 832

    Receiving an “Overallocation Cannot Be Resolved” Warning 833

    Resource(s) Indicate Overallocation Condition After Leveling 833

25 Exporting and Importing Project

Data 835

Exchanging Project Files Across Microsoft Project Versions 836

Exchanging Project Data with Other Applications 837

    File Formats Supported by Project 837

Working with Import/Export Maps 838

    Understanding Import/Export Maps 838

    Reviewing the Predefined Import/Export Maps 840

    Creating and Using an Export Map 844

    Creating and Using an Import Map 849

Exchanging Data with Microsoft Excel 854

    Exporting Project Data to an Excel Worksheet 855

    Exporting Project Data to an Excel PivotTable 859

    Importing Project Data from the Excel Format 859

Working with Web-Enabled Project Data 865

Working with Text File Formats 865

    Exporting Project Data in the Text Formats 865

    Importing Project Data from Text Formats 868

Importing a Task List from Outlook 868

Consultants’ Tips 872

    Import/Export as a Legacy Feature Set 872

    Design the Data Layout Prior to Import/Export 872

    Using Export/Import Versus Copy/Paste 872

    Copying and Pasting Using Excel 872

    Be Aware of Additional Data When Importing/Exporting 872

    Using the XML Export Will Not Keep Some of the Usage Data 872

26 Manipulating Data Using Other

Applications 873

Copying Data Between Applications 873

    Copying Data from Other Applications into Project 875

    Copying Project Data into Other Applications 877

Linking Data Between Applications 879

    Linking Project Data Fields from External Sources 879

    Refreshing Linked Data in Project 881

    Deleting Links to External Sources 883

    Identifying Tasks or Resources with Links Attached 884

    Pasting Links to Project Data in Other Applications 884

Working with Objects 884

    Pasting Objects 885

    Inserting Objects 887

Placing Objects into Project 888

    Pasting Objects in the Gantt Chart View 888

    Inserting Objects in the Gantt Chart View 889

    Placing Objects in the Notes Field 893

    Placing Objects in the Task or Resource Objects Box 893

Placing Objects into Other Applications 896

    Using the Copy Picture Command to Copy a View 897

Consultants’ Tips 901

    “Legacy” Features 901

    File Sizes 901

Index 903


Submit Errata

More Information

InformIT Promotional Mailings & Special Offers

I would like to receive exclusive offers and hear about products from InformIT and its family of brands. I can unsubscribe at any time.


Pearson Education, Inc., 221 River Street, Hoboken, New Jersey 07030, (Pearson) presents this site to provide information about products and services that can be purchased through this site.

This privacy notice provides an overview of our commitment to privacy and describes how we collect, protect, use and share personal information collected through this site. Please note that other Pearson websites and online products and services have their own separate privacy policies.

Collection and Use of Information

To conduct business and deliver products and services, Pearson collects and uses personal information in several ways in connection with this site, including:

Questions and Inquiries

For inquiries and questions, we collect the inquiry or question, together with name, contact details (email address, phone number and mailing address) and any other additional information voluntarily submitted to us through a Contact Us form or an email. We use this information to address the inquiry and respond to the question.

Online Store

For orders and purchases placed through our online store on this site, we collect order details, name, institution name and address (if applicable), email address, phone number, shipping and billing addresses, credit/debit card information, shipping options and any instructions. We use this information to complete transactions, fulfill orders, communicate with individuals placing orders or visiting the online store, and for related purposes.


Pearson may offer opportunities to provide feedback or participate in surveys, including surveys evaluating Pearson products, services or sites. Participation is voluntary. Pearson collects information requested in the survey questions and uses the information to evaluate, support, maintain and improve products, services or sites, develop new products and services, conduct educational research and for other purposes specified in the survey.

Contests and Drawings

Occasionally, we may sponsor a contest or drawing. Participation is optional. Pearson collects name, contact information and other information specified on the entry form for the contest or drawing to conduct the contest or drawing. Pearson may collect additional personal information from the winners of a contest or drawing in order to award the prize and for tax reporting purposes, as required by law.


If you have elected to receive email newsletters or promotional mailings and special offers but want to unsubscribe, simply email information@informit.com.

Service Announcements

On rare occasions it is necessary to send out a strictly service related announcement. For instance, if our service is temporarily suspended for maintenance we might send users an email. Generally, users may not opt-out of these communications, though they can deactivate their account information. However, these communications are not promotional in nature.

Customer Service

We communicate with users on a regular basis to provide requested services and in regard to issues relating to their account we reply via email or phone in accordance with the users' wishes when a user submits their information through our Contact Us form.

Other Collection and Use of Information

Application and System Logs

Pearson automatically collects log data to help ensure the delivery, availability and security of this site. Log data may include technical information about how a user or visitor connected to this site, such as browser type, type of computer/device, operating system, internet service provider and IP address. We use this information for support purposes and to monitor the health of the site, identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents and appropriately scale computing resources.

Web Analytics

Pearson may use third party web trend analytical services, including Google Analytics, to collect visitor information, such as IP addresses, browser types, referring pages, pages visited and time spent on a particular site. While these analytical services collect and report information on an anonymous basis, they may use cookies to gather web trend information. The information gathered may enable Pearson (but not the third party web trend services) to link information with application and system log data. Pearson uses this information for system administration and to identify problems, improve service, detect unauthorized access and fraudulent activity, prevent and respond to security incidents, appropriately scale computing resources and otherwise support and deliver this site and its services.

Cookies and Related Technologies

This site uses cookies and similar technologies to personalize content, measure traffic patterns, control security, track use and access of information on this site, and provide interest-based messages and advertising. Users can manage and block the use of cookies through their browser. Disabling or blocking certain cookies may limit the functionality of this site.

Do Not Track

This site currently does not respond to Do Not Track signals.


Pearson uses appropriate physical, administrative and technical security measures to protect personal information from unauthorized access, use and disclosure.


This site is not directed to children under the age of 13.


Pearson may send or direct marketing communications to users, provided that

  • Pearson will not use personal information collected or processed as a K-12 school service provider for the purpose of directed or targeted advertising.
  • Such marketing is consistent with applicable law and Pearson's legal obligations.
  • Pearson will not knowingly direct or send marketing communications to an individual who has expressed a preference not to receive marketing.
  • Where required by applicable law, express or implied consent to marketing exists and has not been withdrawn.

Pearson may provide personal information to a third party service provider on a restricted basis to provide marketing solely on behalf of Pearson or an affiliate or customer for whom Pearson is a service provider. Marketing preferences may be changed at any time.

Correcting/Updating Personal Information

If a user's personally identifiable information changes (such as your postal address or email address), we provide a way to correct or update that user's personal data provided to us. This can be done on the Account page. If a user no longer desires our service and desires to delete his or her account, please contact us at customer-service@informit.com and we will process the deletion of a user's account.


Users can always make an informed choice as to whether they should proceed with certain services offered by InformIT. If you choose to remove yourself from our mailing list(s) simply visit the following page and uncheck any communication you no longer want to receive: www.informit.com/u.aspx.

Sale of Personal Information

Pearson does not rent or sell personal information in exchange for any payment of money.

While Pearson does not sell personal information, as defined in Nevada law, Nevada residents may email a request for no sale of their personal information to NevadaDesignatedRequest@pearson.com.

Supplemental Privacy Statement for California Residents

California residents should read our Supplemental privacy statement for California residents in conjunction with this Privacy Notice. The Supplemental privacy statement for California residents explains Pearson's commitment to comply with California law and applies to personal information of California residents collected in connection with this site and the Services.

Sharing and Disclosure

Pearson may disclose personal information, as follows:

  • As required by law.
  • With the consent of the individual (or their parent, if the individual is a minor)
  • In response to a subpoena, court order or legal process, to the extent permitted or required by law
  • To protect the security and safety of individuals, data, assets and systems, consistent with applicable law
  • In connection the sale, joint venture or other transfer of some or all of its company or assets, subject to the provisions of this Privacy Notice
  • To investigate or address actual or suspected fraud or other illegal activities
  • To exercise its legal rights, including enforcement of the Terms of Use for this site or another contract
  • To affiliated Pearson companies and other companies and organizations who perform work for Pearson and are obligated to protect the privacy of personal information consistent with this Privacy Notice
  • To a school, organization, company or government agency, where Pearson collects or processes the personal information in a school setting or on behalf of such organization, company or government agency.


This web site contains links to other sites. Please be aware that we are not responsible for the privacy practices of such other sites. We encourage our users to be aware when they leave our site and to read the privacy statements of each and every web site that collects Personal Information. This privacy statement applies solely to information collected by this web site.

Requests and Contact

Please contact us about this Privacy Notice or if you have any requests or questions relating to the privacy of your personal information.

Changes to this Privacy Notice

We may revise this Privacy Notice through an updated posting. We will identify the effective date of the revision in the posting. Often, updates are made to provide greater clarity or to comply with changes in regulatory requirements. If the updates involve material changes to the collection, protection, use or disclosure of Personal Information, Pearson will provide notice of the change through a conspicuous notice on this site or other appropriate way. Continued use of the site after the effective date of a posted revision evidences acceptance. Please contact us if you have questions or concerns about the Privacy Notice or any objection to any revisions.

Last Update: November 17, 2020