Goal seeker table

Hi Mamadi,

Thank you for the forum question.

I am not sure that I understand exactly what you are looking for.

On the Data tab in the Forecast group we have the What if analysis. We have a Data Table tool and Goal Seek here. The Data table tool generate a table from one or two variables and Goal seek can change one variable in any kind of calculation models.

Please provide me with more details so I will know what you will like to do.

I found a useful video on Youtube to understand the Data Table tool.

https://www.youtube.com/watch?v=OdIFL8Tg7qI

Thanks




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector