as explain by Elias, this depends on the combi project / team / self positionning, which can make the day to day job as analyst completely different. Let me describe here several project situation you could face as analyst to give you an idea :
- Project situation 1 : analytics intensive
This corresponds to the situation you described, where appart the client facing dedicated to data collection, you'll spend you time crunshing data on excel. Depending on your performance, you will receive data on the analysis to perform or decide on your own.
- Project situation 2 : market research intensive
Assume you're working on due diligence project. Your tasks will most likely be dedicated to gather marker data et understand how the market is structured. To do that, you will either perform calls to internal expert, cold to calls to industry expert, reports review, and finally you will have to synthesis this data. So depending on the data you gather this could be / or not excel intensive in case the data you're gathering is more qualitative
- Project situation 3 : client interaction intensive
Some project such as PMO (project management office) require lots of client interaction and project management skills. You may only use excel to keep tracking of the project but not for data crunching.
- Project situation 4 : acting as "next grade"
Depending on the staffing available, and you current progression in the firm, you will be exposed at some the next grade responsibilit, and believe me this is not only about excel
To conclude, even if some project are lesst data intensive, keep in mind that in a junior position within a strategy consulting firm you should expect some heavy data computation project at some point.
Hope this helps