How much time do consultants spend working with data on spreadsheets/powerpoints?

consulting
New answer on Jan 20, 2020
5 Answers
950 Views
Anonymous A asked on Jan 11, 2020

Overview of answers

Upvotes
  • Upvotes
  • Date ascending
  • Date descending
Best answer
Clara
Expert
Content Creator
replied on Jan 11, 2020
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut

Most of it!

And the time you are not working with the data crunching numbers, you are:

  • Working with the clients trying to get the cited data or validate it
  • Presenting data-driven conclusions to clients or leadership

Hence, client management skills are equally important.

However, key thing is to be pretty confortable at least with Excel by the time you start, in order to survive -deadlines are super tight-.

Hope it helps!

Cheers,

Clara

Was this answer helpful?
Nathaniel
Expert
replied on Jan 20, 2020
McKinsey | BCG | CERN| University of Cambridge

Hello there,

Consulting's bread and butter is data-drifven problem solving, meaningt that as much as possible, each core issues identified and recommendations formulated need to be based on a certain logic supported by data.

As such, 70-80% of the time is spend on requesting, consolidating, analyzing, and pulling insights from data. Now, there are various kinds of data, numerical data in form of spreadsheets, observational data points, or anecdotes (non-numerical data which involves statements from various sources).

The rest are typically spent to interact and help your client couinterpart in their top-mind issues.

For some projects, more client handling is required, but still we spent the other times mostly to build a sound structure supported by tangible logics and data.

Hope it helps.

Kind regards,
Nathan

Was this answer helpful?
Luca
Expert
Content Creator
replied on Jan 12, 2020
BCG |NASA |20+ interviews with 100% success rate| 120+ students coached |GMAT expert 780/800 score

Hello,

As other experts said, it depends on the project and on the team. Usually in a team there is a responsible for the excel model and a responsible for the presentation. You will anyway spend on average 70% of the time with excel and powerpoint, half of that handling data.

Best,
Luca

Was this answer helpful?
Antonello
Expert
Content Creator
replied on Jan 12, 2020
McKinsey | MBA professor for consulting interviews

Hi,
it strongly depends on the project, but they will be your basic tools. You are going to work with these at least 2 hours a day.

Best,
Antonello

Was this answer helpful?
Vlad
Expert
Content Creator
replied on Jan 11, 2020
McKinsey / Accenture Alum / Got all BIG3 offers / Harvard Business School

Hi,

It really depends on the project. I would say that depending on the day / type of project you will spend 1-5 hours with the client. Rest is internal team brainstorming and coordination and excel / ppt. FYI the day can be 12-18 hours:)

Best

Was this answer helpful?
Clara gave the best answer

Clara

Content Creator
McKinsey | Awarded professor at Master in Management @ IE | MBA at MIT |+180 students coached | Integrated FIT Guide aut
65
Meetings
17,084
Q&A Upvotes
67
Awards
55 Reviews