Solved

Using Excel to document steps

Posted on 2014-01-27
3
310 Views
Last Modified: 2014-01-27
Greetings!

I need to document about 350 steps in a systems build process which have branching and merging paths and various dependencies I want to represent. I am looking to have one tab with all the data listed in a table, then be able to pivot and provide constrained views on successive tabs.

Do you happen to have an example of a spreadsheet/table with brancing, merging and dependencies represented?

Thank you!
JohnD
0
Comment
Question by:johndarby
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 5

Expert Comment

by:RAdministrator
ID: 39812506
Hi, don't have anything like that and don't recommend Excel for it. You should use Visio which does what you are requesting.
0
 
LVL 42

Accepted Solution

by:
pcelba earned 500 total points
ID: 39812525
I would recommend MS Project or similar software to do this task.
And MS Project isn't the only option. You may look at RationalPlan (http://www.rationalplan.com/)

Also free software exists, e.g. OpenProject: https://www.openproject.org/
0
 
LVL 5

Expert Comment

by:RAdministrator
ID: 39812535
Yes, pcelba is right, MS Project would be another solution, and with more charting and display options.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question