Understanding Tables, Sheets and Split Screens in Microsoft Project

 

Split Screens in Microsoft Project

In this article we will learn following:

  • WORKING WITH SPLIT SCREENS  
  • UNDERSTANDING SHEET 
  • WORKING WITH TABLES
WORKING WITH TABLES in Microsoft Project

WORKING WITH SPLIT SCREENS 

Sometimes in Microsoft Project one view of your data is not enough! Project, therefore, allows you to split your screen horizontally into two views. For example, you might want to see tasks at the top and their resources at the bottom. One of these views is deemed to be the active view – as indicated by the active pane indicator at the left of the screen. 
WORKING WITH SPLIT SCREENS

WORKING WITH SPLIT SCREENS

UNDERSTANDING SHEET 

Sheet views of data are common to database and spreadsheet applications. Microsoft Project also uses sheet views where data is presented in rows and columns. In Project there are literally dozens of columns (called fields) for tasks and similarly for resources. To make it easier to work with these columns, oops fields, they have been organised into tables. 
UNDERSTANDING SHEET  in Microsoft Project

About Tables 

Since there are literally dozens of fields for both Tasks and Resources, Microsoft Project organises these in specialised groupings into tables. For example, fields for tasks associated with costs are organised into a Cost table, fields that are commonly used for data entry are organised into an Entry table, and so on. 
Tables in Microsoft Project

Task Tables 

There are 17 pre-defined tables for tasks as follows: 
Baseline
Earned Value
Export
Summary
Constraint Dates
Earned Value Cost Indicators
Earned Value Schedule Indicators 
Work
Task Tables  in Microsoft Project

Resource Tables 

There are 10 pre-defined tables for resources as follows: 
Cost
Entry – Material Resources
Hyperlink
Usage
Earned Value
Entry – Work Resources
Summary
Work
Entry
Export
Resource Tables  in Microsoft Project

WORKING WITH TABLES 

Microsoft Project consists of two databases: tasks which contains over 240 columns of data, and resources which contains over 200 columns of data. Tables display information from these columns (or fields) into organised and logical groupings. Once a Sheet view has been chosen you can change the table of fields that are presented. 
WORKING WITH TABLES  in Microsoft Project

Understanding Tables, Sheets and Split Screens in Microsoft Project

Understanding Tables, Sheets and Split Screens in Microsoft Project

Understanding Tables, Sheets and Split Screens in Microsoft Project

Leave a Reply

Your email address will not be published.