This paper aims at proposing a methodological strategy for teaching the modelling of dynamic scenarios from Multivariable Data Tables using Microsoft Excel as a technological tool. It provides a step-by-step guide for improving the teaching-learning method on the development of financial models, which could also be used in other areas. The methodology allows identifying the most important aspects of developing financial models so students-professors could be guided towards a more pedagogical approach promoting the incorporation of technological tools in the classroom. This work plays a pivotal role in financial modelling teaching since it provides relevant elements leading to the development of systematic thinking among university students based on cognitive activities. Also, various contributions to research on the teaching-learning process in modelling are discussed. For validating the proposal, an airport's financial valuation was used as a case study. As a result, this paper contributes to increasing the role of computational tools and students-professors involvement in the development of systemic thinking and cognitive skills.