Excel & Python for Project Managers

by Danny Munrow, Johann Strauss, Hayden Schwartz

Reactive PublishingThis book gives project managers the real tools needed to plan, model, and deliver with confidence. It shows how to combine the accessibility of Excel with the automation power of Python to create a predictive project engine that eliminates guesswork, reduces overruns, and strengthens decision-making at every stage.You learn how to build financial models that track budgets, simulate cost scenarios, and measure burn rates with precision. You also learn how to construct dynamic Gantt timelines, automate schedule updates, model resource constraints, and forecast completion dates using data instead of intuition. Every chapter moves from fundamentals to practical application, with ready-to-use templates, walkthroughs, and code samples that integrate seamlessly into real project workflows.The book covers variance analysis, cash flow timing, Monte Carlo simulations, sensitivity testing, milestone forecasting, risk scoring, automated reporting, and building dashboards that clearly communicate project health to executives and stakeholders. You'll learn how to convert manual reporting into automated pipelines that sync schedules, budgets, and status indicators in real time.Whether you manage IT projects, construction, operations, finance transformations, or cross-functional initiatives, this guide gives you the tools to forecast more accurately, allocate resources more intelligently, and deliver projects on time and on budget. It is designed for project managers who want to elevate their analytical capabilities, reduce uncertainty, and manage complexity with modern, data-driven methods.