Help with excel problem solving

Hi all,

I’m a consultant at an MBB. I have mostly done projects that are more on the qual side and know that I will be tested on quant soon.

I am familiar with excel and all the basic formulas (SUMIF, XLOOKUP, etc) but my problem mostly comes from problem solving and workbook structure.

For example, let’s say I’m analysing a category like pet food. I struggle to create the right type of dashboard that looks clean and is 100% dynamic. It’s not that I don’t know how to do simple profit / price, but that I look at some of my colleagues dashboards and they are so simple and easy to use. I feel like others get to the answer in 2 steps and I get there in 6.

How can I get better at the initial stages of workbook planning, making things efficient and dynamic, and more simple.

Let me know of any courses or resources that can be helpful. Specifically, I want to practise on non perfect datasets in a non case setting (I find training courses always use the most simple example data sets but in the real world the data is half the problem). Thanks!