Excel Intermediate is so popular, Why?
Excel is for everyone. An employer is looking that you can create basic spreadsheets with formatting, basic formulas and functions like SUM, AVERAGE and COUNT. For the high-end skilled jobs you'll need complex function skills.
Functions are different to Formulas. Formulas use operations like + - * / where as Functions follow a structure. They both start with = A Functions has = Function Name ( in that order. There are over 300 Functions in Microsoft Excel.
Formatting Excel spreadsheets made easy by using the correct tools. Most useful tools are Conditional Formatting and Format as Table features.
Don't under estimate the power of basic formatting. Techniques for pulling a part data. You have used Text To Column but have you tried Flash Fill. Changing Settings to force data to perform differently.