How can I compare values measured before and after an experimental treatment when values are normalized such that all initial values are 100%?

Use the one-sample t test, which is part of the "Column statistics" analysis. Choose to compare the mean of each column against a hypothetical value (in this case, 100).