As teachers of subjects related to information and management systems at the Universitat Jaume I who are aware of the growing use of these functions for organizations, especially for SMEs that account for the majority of companies in our region, and of the demand for a professional profile that combines knowledge and specific skills of each field of knowledge with skills of a technological nature, the authors felt it would be useful to write a manual that provides students with the basic aspects of using dynamic tables. Students will have access to the more advanced options of Power Pivot based on the relationship between different data sources.

One of the main advantages of these dynamic tables is precisely their ability to analyze data from different perspectives, and their ability to respond to different situations or needs. The practical cases will give allow students a better understanding of the potential of dynamic tables in the management of any type of organization.