Constructing Network Diagram On Excel

Creating a detailed network diagram with visio is an effective way to design and document a computer network as in the following illustration.

Constructing network diagram on excel. Creating a network diagram can be an involved process that begins after you ve determined predecessors to your activity. Network diagrams can be drawn on paper with a pencil or with project management software like microsoft visio. After creating the table you can then proceed to constructing the precedence diagram project network diagram. Here s a simple example that can help you learn how network diagrams can be useful in any project you manage.

A network diagram is a project management flow chart that displays the relationships between all the components of a project. The relationships between each activity and subsequent activities are indicated by the arrows. To illustrate this process i use a simple network diagram created in excel. Using the detailed network diagram template and the data link features you can create a diagram that shows how equipment is logically or physically connected add initial data to identify each shape.

When constructing a network diagram it is necessary to understand dependencies precedents and leads and lags. Not only do they make your worksheets more visually appealing they also serve a definite function. The nodes and links are connected so it is very easy to rearrange the network diagram. The network diagram shown above displays the activities as boxes which are referred to as nodes.

Arrange project activities in order of execution to create a precedence diagram. This is a quick tutorial on using the graphic tools in excel 2013 to create network diagrams. In personal finance or business for example a network diagram can give you a bird s eye view of income sources and expenditures. You find out how to draw the network diagram for a sample project from the information in.

Microsoft excel also has the tools you need to make a professional looking network diagram. Understanding the core concepts associated with creating a network diagram is critical to passing the pmp exam. An example precedence diagram is shown in the image. Refer to the table while creating the project network diagram.

The illustrative format makes it easy to determine the flow of the project where you currently are in the project s life cycle and links between parallel and successive activities as well all with just a quick glance. Excel lacks the specific shapes necessary to create a network diagram without spending hours creating custom shapes from scratch or paying for additional extensions.