Simulando atingimento de Metas - [Excel]
In this video, I'll explain how to know if it's possible to reach your goal and make informed decisions about what to do next. Should I prioritize the indicator? Should I fight with the team to achieve the goal, or should I prioritize other indicators and dedicate efforts to what is truly achievable? What are the possible scenarios according to the behavior of my indicator? I'll show you in a simple way in Excel how to create these scenarios (optimistic, realistic, and pessimistic) and use statistics to your advantage in a simple and practical way. As a bonus, I'll also share a very good tool called Goal Seek so that the algorithm itself runs the simulation for you.
