A relatively direct consequence of the (nontrivial) spectral theorem is the following (Lang, Algebra, chap. XV, corollary 7.3):
Let $E$ be a non-zero finite dimensional vector space over the reals, with a positive definite symmetric form $f$. Let $g$ be another symmetric form on $E$. Then there exists a basis of $E$ which is orthogonal for both $f$ and $g$.
In this basis, $f$ and $g$ would then have the following forms
$$f(x) = \sum_{i=1}^{\dim E} \lambda_i\,x_i^2 \qquad g(x)=\sum_{i=1}^{\dim E} \mu_i\, x_i^2.$$
Because $f$ is positive definite, $\lambda_i > 0$ and you could modify the basis so that $\lambda_i = 1$. But of course, there is no way to change the signs of the $\mu_i$. Alternatively, you could change the basis so that $\mu_i \in \{-1,0,1\}$, but you have to make a choice: you cannot have a simple form for both the $\lambda_i$'s and the $\mu_i$'s.
I hope this falls to your definition of "reducing simultaneously" the forms to "sums of squares". Anyway, there isn't really hope for a better statement.