Making a network diagram isn’t too hard to do, once you get the hang of it. I have a very detailed guide to making a network graph with Cytoscape here. It includes information on how to get your data set up for an edge list.
Cytoscape is powerful and allows you to perform all kinds of measurements and customizations, but there are other tools that can also produce network diagrams but are easier to use. You already learned how to use Google Fusion Tables to make a network diagram. You can also use Palladio to make a network diagram; see my tutorial here. Some students tell me that they like Polinode, although I haven’t tried it. Try signing up for a 7-day free trial.
On reason network analysis can be confusing is that it has its own specialized vocabulary. Here is a glossary of terms.
And here is the video that shows you how to “melt” rows into one column.