Before training a neural network you need to partition the columns and the rows of your spreadsheet. Each column used by the neural network can either be tagged as an input or a desired output. The rows are then segmented into one or more of the following four groups:
Training - Data used by the neural network to learn from.
Cross Validation - Data used to evaluate the performance during the learning process to avoid over-training.
Testing - Data used to evaluate the performance after the training is complete.
Production - Input data to feed into the trained neural network to produce an output.