Hi there,
First, congratulations :)
Second...you only have a week until you get slammed with 70 hour weeks and a ton of stress. My biggest piece of advice is to enjoy your freedom :P You should be completely and absolutely bored by the time you start your role...so that you're ready and grateful for the challenge when it hits!
Third: Know that no-one can perfectly prepare for the job and that's the point: You will mess up, you will learn, you will be trained and supported. That's OK!
Now, for tips....
--------------------------------------------------------------------------------------
First: Read the 25 tips in my consulting handbook here: https://www.spencertom.com/2018/01/14/consulting-survival-guide/
--------------------------------------------------------------------------------------
Second: In terms of things you can learn/do to prepare beforehand:
1) Daily Reading
- The Economist, The Financial Times, BCG/Mskinsey Insights
2) Industry deep-dives
- Learn, in-depth, how the industries/companies your office advises, work. (PM me for an industry overview template)
3) Analytics tools
4) Excel
- https://www.preplounge.com/en/consulting-forum/free-online-resources-to-learn-excel-basics-6946
- Pivottables
- Working with data
- Key fuctions (vlookup, Index match, count and sum if/ifs, sumproduct, concat, etc.)
- Hotkeys (i.e. use keyboard more than your mouse)
- Financial modeling
5) Powerpoint
- https://www.preplounge.com/en/consulting-forum/powerpoint-skills-4072
- Wireframing
- Lead-in titles
- Best practices/standards
- Different layouts
- Quickly editing/updating slides
- Thinking in PowerPoint
6) Presentation skills / sharp communication
- There are some great online/virtual classes for this (including the academies meantioned above
--------------------------------------------------------------------------------------
Third: In terms of doing well in your role when you're there:
1) Understand the context/prompt (what role are you in, what company, who's watching, etc.)
2) Understand the objective (what, specifically, is expected from you...both day to day, and in your overall career progression)
3) Quickly process information, and focus on what's important - Take a lot of information and the unknown, find the most logical path, and focus on that.
4) Be comfortable with the unknown, and learn to brainstorm - think/speak like an expert without being one
In summary, there will always be a flood of information, expectations, competition etc. and not enough time. Find out which ones matter when. (i.e. be visibile and focus efforts on the things that people care about)
--------------------------------------------------------------------------------------
Fourth: Here are some great prior Q&As for you!
https://www.preplounge.com/en/consulting-forum/what-makes-a-good-consultant-how-to-get-a-good-review-6790
https://www.preplounge.com/en/consulting-forum/how-hard-is-it-to-excel-in-top-consulting-firms-6762
https://www.preplounge.com/en/consulting-forum/how-to-become-an-engagement-manager-and-partner-quickly-6722
https://www.preplounge.com/en/consulting-forum/need-to-learn-skills-in-the-ample-free-time-before-starting-at-an-mbb-what-should-i-do-6774