Hello!
Congrats of that offer!
You do very well trying to anticipate here: if there is one thing I wish I had done before joining McKinsey, that would have been Excel. 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).
Excel skills are part of the core skill-set of consultants, and it´s great that you want to practice them. PFB a list of the most popular commands:
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
Hello!
It´s much better than the old test used to be.
It's a gamified test
Divided into 2 games, 1h to complete both of them:
1st one is a game about keeping an ecosystem balanced
2nd one is a defense game
It´s fun and there is not really a "way" to prep for it.
My advise would be to be fresh when you do it and pick a right enviroment -during my BCG test in their office there was construction in the patio and the screen was even shaking-.
Hope it helps!
Cheers,
Clara
Hello!
Congrats of that offer!
You do very well trying to anticipate here: if there is one thing I wish I had done before joining McKinsey, that would have been Excel. 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).
Excel skills are part of the core skill-set of consultants, and it´s great that you want to practice them. PFB a list of the most popular commands:
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
Hello!
It´s much better than the old test used to be.
It's a gamified test
Divided into 2 games, 1h to complete both of them:
1st one is a game about keeping an ecosystem balanced
2nd one is a defense game
It´s fun and there is not really a "way" to prep for it.
My advise would be to be fresh when you do it and pick a right enviroment -during my BCG test in their office there was construction in the patio and the screen was even shaking-.
Hope it helps!
Cheers,
Clara