To increase voltage we use more turns on the secondary than the primary, but that will make the transformer's size way to big and it won't be practical.
No, that doesn't makes sense. The person who said that is unfamiliar with transformer design, and is assuming you continue onward with the same size wire, just making more turns of it. That's not true.
Transformers have a fixed amount of power which both primary and secondary must handle. Watt's Law says when voltage increases by factor X, current decreases by factor X also. Ohm's Law says since the current changed, the wire size can change in proportion as well!
Get it? If you use 10 times the windings, you are using 1/10 the wire cross-section, which means, the total amount of copper/aluminum remains the same regardless of secondary voltage! The varnish insulation takes some small amount of space, so finer wire is slightly larger, but not by a whole lot.
With transformers, the mass of copper/aluminum is decided by the total power of the transformer.
In order to use less turns on the secondary coil we increase the frequency, but I don't get what that means or how it is applied.
No, that too is nonsense. This person "knows a little bit" about transformers but it's jumbled so-called knowledge and they are wrong.
What frequency does is change the mass of the iron core of the transformer. Higher frequencies greatly shrink it. That's why electric locomotives (for whom mass is a virtue) use 16.667 Hz, and airplanes (for whom mass is a curse) use 400 Hz.
They still need about the same amount of copper/aluminum for a transformer of a given power rating.