Excel
Excel Powerhouse: From Data Exploration to Dynamic Models
Advanced Excel Data Exploration and Modeling
Mastering Complexity with Advanced Excel: This project showcases the use of advanced Excel features to analyze and model a wide range of topics. From data exploration using PivotTables and regression analysis to creating dynamical models like epidemics and population dynamics, Excel’s powerful tools are fully leveraged.
We also modeled physical scenarios, such as projectile motion with air resistance, using formulas based on Newton’s laws. Excel’s Solver, Scenario Manager, and dynamic charts allowed for sophisticated simulations, optimizing solutions and providing clear visualizations of complex behaviors.