Earned Value Analysis and Pivot Tables
Manage Yourself – not Time!
Project Management for Innovation and High Risk
Writing Project Objectives
Writing Project Options
Writing Project Deliverables
Writing a Project Scope
Writing Project Constraints
Assessing Project Risk


Validating Data in Excel
The Purpose of Project Control
Diagnosing Project Problems
Asking the right questions of the team
Taking Corrective Action (Part 1)
Taking Corrective Action (Part 2)


Printing to Impress
Using a Deadline Symbol in Microsoft Project

Using Pivot Tables in Excel
The Power of a Project Management Database
Automatic Colour Changes on the Gantt Chart
Preparing and Entering Data
The Horizontal Screen Split
Scaling for Screen and Print
Improving Gantt Chart Appearance
Durations, Work and Resource Units
Assigning Part-Time Resources
Examining Costs
Costing Material-Type Resources
Tracking a Project - No.1
Tracking a Project - No.2
Grouping Tasks and Resources
Displaying Information in MS Project Tables
Reporting Cash flows
Using Outline Code Fields
Creating Filters
Creating Your Own Tables

Flexible Resource Costing
Project Server 2003


Tactical vs. Value Decision Making
Will Decision-makers learn from Project Managers?
How to Make Decisions
Formulating the Decision
Building a Decision Context
Elements of a Good Decision Process
Decision Options and Criteria
White Paper: Fending off the Lawyers
Overview of Decision-making tools & techniques

 

Displaying Useful information in Microsoft Project Tables

The principal means of showing data in Microsoft Project is via ordinary tables. There are numerous such tables in the program and it is an easy matter to switch from one to the other.

The default opening table is the one called 'Entry' since it contains the type of fields we generally need for data entry. These include the names of the tasks, the duration estimates, predecessor numbers and resources. Occasionally we modify the other two columns that show, i.e. the start and finish dates.

To switch from one table to another simply select

View - Table
And make your selection.
Experiment with different tables.
You can do precisely the same thing on the resource side. First move to the resource sheet by means of :

View - Resource Sheet
Here too you will probably be seeing the default 'Entry' table which includes some of the essential resource information we need to enter such as resource names, availability (max units) and cost rates.

However, you use the same method as before to switch tables.

Adding columns
Click a column header and use the Insert - Column menu option to add a field. When the column definition form opens, select a field (you are always presented with the 'ID' field as the default) and possibly alter the title in the space provided.

Changing columns
Double click a column header and proceed as above.

Hiding a column
To remove a column, click the column header and use 'Edit -Hide column' or use the 'Delete' key on the keyboard. This will not delete information but simply remove the column from view.

In upcoming articles we will show how you can create your own tables with your own selections of column or field headers.

 

 

Numerix Pty. Ltd. ABN 83 003 504 970 Telephone: 61 2 - 9279 0900 Fax: 61 2 - 9279 4141 email info@numerix.com.au