Excel Modeling for Professionals: Best Practices & Pitfalls

A behavioral researcher specializing in the study of human social preferences, this scholar employs both laboratory and field experiments to gain comprehensive insights into human behavior and decision-making. Their laboratory research primarily involves computer-based games with student participants, while their field experiments extend into natural environments with non-student subjects, allowing them to evaluate how well laboratory findings translate to real-world scenarios. Beyond their work on social preferences, they also investigate optimal labor contract design, examining various compensation models such as per-unit payment schemes and competitive reward systems to determine which structures most effectively motivate employee effort and productivity.

A renowned Excel authority and one of the world's foremost experts in VBA, this professional combines extensive teaching experience with hands-on expertise as a trainer, modeler, auditor, and VBA developer. Their comprehensive understanding of Excel extends from basic functionalities to advanced programming, making them a distinguished lead instructor who has contributed significantly to course content development while maintaining active involvement in practical Excel implementation across various professional contexts.

A pioneering figure in spreadsheet risk analysis and education, this professional co-founded both PerfectXL and EuSpRIG (European Spreadsheet Risk Interest Group), conducting extensive research on spreadsheet risk during their time at TU Delft. Currently serving as a faculty member at Leiden University, they combine their expertise in spreadsheet analysis with educational innovation, running a programming education program for young children, while their foundational research continues to inform and shape spreadsheet risk management courses and methodologies.