Hello!
Congrats of that offer!
If there is one thing I wish I had done before joining McKinsey, that would have been Excel. So great that you are thinking about this now, since it can really be a game changer, so I would really focus on that (more than pptx, industry knowledge, etc., that are nice-to-have, but not deal breakers).
Train the Street is great, but get any that makes you familiar with:
Basic operations: SUM, SUMPRODUCT
Text transformations: CONCATENATE, LEFT, RIGHT, & operator,
Connecting different datasets: VLOOKUP, HLOOKUP, INDEX(MATCH(),MATCH())
Conditional-based operations: SUMIF, COUNTIF, SUMIFS, COUNTIFS, COUNTA
Learn how to analyze data using Pivot Tables
There are plenty of online materials:
Microsoft Support: https://support.office.com/en-us/excel
Kubicle: https://kubicle.com/personal (go for the 7 days free trial - Excel for Business Analytics)
Hope it helps!
Cheers,
Clara